DATABASE DESIGN AND DEVELOPMENT

About this Course

  • 197 students enrolled
  • 4 instructors

Course Description

In the information age today, enormous amount of data is kept in files and databases. The knowledge to manipulate and manage these files is beyond doubt. By using a database package, the students will be able to appreciate the needs for database systems rather than the traditional file systems.

Course Learning Outcomes

1 ) Demonstrate lifelong learning skills in task related to relational database management system.
2 ) Construct the database structure and Structured Query Language statements.
3 ) Analyse the database fundamental concepts, design and development.

Course Details

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

Join this course

 Syllabus

1.1 Data and Information
1.2 Introducing the Database
1.3 The Importance of Database Design
1.4 Evolution of File System Data Processing
1.5 Database Systems

2.1 The Importance of Data Models
2.2 Data Model Basic Building Blocks
2.3 Business Rules
2.4 The Evolution of Data Models
2.5 Degrees Of Data Abstraction

3.1 A Logical View of Data
3.2 Keys
3.3 Integrity Rules
3.4 The Data Dictionary and the System Catalog
3.5 Relationship within the Relational Database
3.6 Indexes

4.1 Basic Modeling Concepts
4.2 The ER Model
4.3 Developing an ER Diagram
4.4 A Comparison of ER Modeling Symbols
4.5 The Challenges of Database Design

5.1 The Need for Normalization
5.2 The Normalization Process (1NF, 2NF, 3NF)
5.3 Improving the Design
5.4 Normalization and Database Design
5.5 Denormalization

6.1 The Information System
6.2 The Systems Development Life Cycle (SDLC)
6.3 The Database Life Cycle (DBLC)
6.4 Database Design Strategies
6.5 Centralized versus Decentralized Design

7.1 Introduction to SQL
7.2 Data Definition Commands
7.3 Data Manipulation Commands
7.4 SQL Operators
7.5 Additional Data Management Commands
7.6 Additional Select Queries
7.7 Subqueries
7.8 Joining Database Tables

8.1 Introduction to Specific Area of Database (i.e. Big Data etc)
8.2 Conceptual model on the Specific Area of Database
8.3 Data Management Issues

Our Instructor

NOR INTAN SHAFINI BINTI NASARUDDIN

 Course Instructor
UiTM Kampus Jasin

NOR AZLINA BT AZIZ FADZILLAH

 Course Instructor
UiTM Kampus Seremban 3

DR. NOORADILLA BINTI ABU HASAN

 Course Instructor
UiTM Kampus Seremban 3

DR. ROZIANAWATY BT OSMAN

 Course Instructor
UiTM Shah Alam

 Frequently Asked Questions

A1 : Anyone who wants to learn more about database design

A2 : Definitely yes!