Course Aims & Objectives:
This course introduces the concepts and the principles of database design.

Specifically, this course aims to:

1. specify how data are organized and stored in a typical database system and acquire the techniques for manipulating data under the relational data model;
2. identify and execute the steps involved in the analysis & design of databases;
3. introduce data modeling technique for database systems;
4. introduce the relevance of transaction management for application development.

At the end of the course, students will be able to analyze & design database systems for real applications.

Units: 3

Level: P6

Medium of Instruction:  English 

Keyword Syllabus:
The database approach; the relational model; relational algebra; SQL; life cycle for database applications; database requirement analysis & design techniques: Entity-relationship (ER), Normalization & denormalization, logical & physical database design; data conversion; transaction management.

Teaching Pattern:
Duration of course: 1 semester
Current mix of lecture/tutorial/laboratory, other: 2 hrs. lecture; 1 hr. tutorial.

Assessment Pattern:
Examination duration: 2 hours
Percentage distribution of marks for coursework, examination, other: 40% CW, 60% Exam
Grading pattern: Standard (A+AA-...F)
For a student to pass the course, at least 30% of the maximum mark for the examination must be obtained.

Pre-requisite(s): Nil

Pre-cursor(s):
CS5302

Equivalent Course(s):
*CS3401 Database Systems
*CS3403 Advanced Database Systems