Course Aims & Objectives:
This course introduces the concepts and principles of the database design in a single site environment. Specifically, this course aims to introduce:

1. how data files are organized and stored; and the techniques for manipulating data stored in them;
2. the procedures and steps involved in the design of databases; and
3. understand the strengths and limitations of the various file organisations and be able to determine the proper organisation for a given application.

On the completion of the course, students should be able to design simple database systems for different applications.

Units: 3

Level: B3

Medium of Instruction: English

Keyword Syllabus:
Fundamental Files Concepts; File Organization; Creation, Retrieval, and Update of Data; Basic Database Models; Relational Database Model: Relational Algebra & Relational Calculus; SQL; Entity-relationship (ER) & Extended Models.

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): Nil

Equivalent Course(s): Nil