INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

About this Course

  • 148 students enrolled
  • 5 instructors

Course Description

In the information age today, the need to advance knowledge in developing a database management system is crucial. This course emphasized on the database concepts, principles, design, development and managing database systems. By acquiring the knowledge, the students will be able to appreciate the need for implementing database systems.

Course Learning Outcomes

1 ) Demonstrate information management and retrieval in database system using RDBMS concepts and database case study.
2 ) Show the significant queries in Structured Query Language using RDBMS.
3 ) Determine the design of a database based on knowledge of the Entity-Relationship Model and 3NF relation to achieve a concrete database design.

Course Details

STATUS : Open
DURATION : FLEXIBLE
EFFORT : 4 hours per week
MODE : 100% Online
COURSE LEVEL : Beginner
LANGUAGE : English
CLUSTER : Science & Technology ( ST )

Join this course

 Syllabus

Introducing the Database
The Importance of Database Design
Evolution of File System Data Processing
Problems with File System Data Processing
Database Systems

Data Modeling and Data Models
The Importance of Data Models
Data Model Basic Building Blocks
Business Rules
The Evolution of Data Models
Degrees of Data Abstraction

A Logical View of Data
Keys
Integrity Rules
The Data Dictionary and the System Catalog
Relationships within the Relational Database
Data Redundancy Revisited
Indexes

Entity Relationship (E-R) Modelling
Basic Modelling Concepts
The E-R Model
Developing An ER Diagram
A Comparison of ER Modelling Symbols
The Challenge of Database Design
Conflicting Goals
Extended Entity-Relationship Modeling up to Disjoint and Overlapping Constraint

Database Tables and Normalization
The Need for Normalization
The Normalization Process up to 3NF
Normalization And Database Design
Denormalization

Changing Data Into Information
The Information System
The Systems Development Life Cycle (SDLC)
The Database Life Cycle (DBLC)
DBMS Software Selection
Database Design Strategies

Introduction to SQL
Data Definition Commands
Data Manipulation Commands
Queries
Advanced Data Definition Commands
Advanced Select Queries

Our Instructor

NIK NAHDIYA BINTI NIK KAMARUZAMAN

 Course Instructor
UiTM Kampus Machang

ROBIZAH BINTI HAJI SUDIN

 Course Instructor
UiTM Kampus Machang

PROFESOR MADYA TS. DR. NOORIHAN BINTI ABDUL RAHMAN @ ABDUL RASHID

 Course Instructor
UiTM Kampus Machang

NOORFADZILAH BINTI ARIFIN

 Course Instructor
UiTM Kampus Machang

 Frequently Asked Questions

A1 : UNDER CONSTRUCTION