Objective:

• This course introduces the concepts and the principles of design, implementation and management in one site environment of relational, object-oriented and XML database systems.

Lecture and Tutorial:

• • Lecture 1: Extended Entity Relationship Model
  • Lecture 2 Relational algebra
  • Lecture 3: Data normalization
  • Lecture 4: Structural Query Language
  • Lecture 5: Object-oriented database
  • Lecture 6: XML database
  • Lecture 7: Database Recovery
  • Lecture 8: Database Concurrency Control
  • Lecture 9: Query Optimizer
  • Lecture 10: Reverse Engineering
  • Lecture 11 Schema Integration
  • Lecture 12: Data Conversion
  • Lecture 13: Review

Coursework:

• In class review question right after each lecture in the classroom. Students are encouraged to discuss with each other before answering the question.
• Homework tutorial question to be worked at home and submitted in each tutorial session. Students are encouraged to ask questions on related concepts in open forum.
• Team project assignment on developing a retail stores database system with prototype implementation to be submitted in week 14 with a report document and voiced movie demonstration.

Course Intended Learning Outcomes (CILOs)

• Students will be asked about the major conceptual theories of database system including data modeling, data normalization, data recovery and data concurrency control etc.
• Students will be questioned on how to apply the learnt database systems theories in case studies.
• Students will be required to demonstrate their technical skill in building up a workable database system.
• Students will be requested to document their work in a report on the methodology of developing a database system.
• Students will be encouraged to work with their classmates on team project assignment.
• Students will be examined on their courework with open book and open notes.