Subject Descriptions - Subject Information

Calendar: 2017 Postgraduate
Faculty: Faculty of Engineering and Information Sciences
Department: School of Computing and Information Technology

Subject Information
Subject Code MCS9315
Subject Name Database Design and Implementation
Credit Points 6
Pre-Requisites MCS9235
Co-Requisites None.
Restrictions None.
Equivalence ITCS921
Assessment 1. Assignments - 3*10%
2. Class tests - 4*5%
3. Final examination - 50%
General Subject No.

Subject Description
This subject investigates the process of relational database design starting from conceptual database design, through logical database design, denormalisation, up to and including physical database design and administration. The topics include conceptual database design based on Object Modelling Technique, methodologies for conceptual design, view integration, logical database design, database normalisation and denormalisation, physical database design including persistent storage allocation, indexing, view materialisation, partitioning, and clustering of relational tables.

Subject Learning Outcomes
On successful completion of this subject, students will be able to:
1. Design a relational database using Object Modelling Technique in a systematic manner.
2. Prove the correctness and efficiency of the final design using the formal techniques.
3. Carry out cost/benefit analysis of the final design in the terms of physical database design techniques.
4. Implement the design using commercially available database management systems.
5. Carry out the basic functions of database administrator such as user management, access rights management and profiles management.
6. Explain an internal organisation of a sample relational database system.
7. Design indexing schemas and carry out performance evaluation of database indexing techniques.
8. Design materialised view, partitioned relational tables and clustered relational tables.