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: Data Modeling Technique
  • Lecture 2 Relational Algebra
  • Lecture 3: Data normalization
  • Lecture 4: Structual Query Language
  • Lecture 5: Query Optimization
  • Lecture 6: Database Recovery
  • Lecture 7: Concurrent Transactions Management
  • Lecture 8: Object-Oriented Database
  • Lecture 9: XML Database
  • Lecture 10: Data Conversion
  • Lecture 11 Reverse Engineering
  • Lecture 12: File Systems
  • 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.