• Instructor: Rynson Lau
• Teaching Assistant: Cora Chang
• Semester: A
• Hours: 26-hour lectures (2 hours/week) and 13-hour tutorials (1 hour/week)

Objectives

• understand the organization and functionality of files and databases, and
• be able to manipulate file and database contents for information retrieval.

Assessment

• Coursework: 40% (1 assignment and 1 test)
• Examination: 60% (2 hours)

Notes for Download

• Week 1: Module Overview and Lecture 1.
• Week 2: Tutorial 1 (with solutions) and Lecture 2.
• Week 3: Tutorial 2 (with solutions) and Lecture 3.
• Week 4: Tutorial 3 (with solutions) and Lecture 4.
• Week 5: Tutorial 4 (with solution) and no lecture (holiday).
• Week 6: no tutorial (holiday) and Lecture 5.
• Week 7: Tutorial 5 (with solutions) and test (Test Paper).
• Week 8: Pre-Laboratory Information, Laboratory 1, Solutions 1, and Lecture 6.
• Week 9: Laboratory 2, Solutions 2, Lecture 7 and Laboratory Assignment (submission deadline: 2 Dec.).
• Week 10: Tutorial 6 (with solution) and Lecture 8.
• Week 11: Tutorial 7 (with solution) and Lecture 9.
• Week 12: Laboratory 3, Lab3-4NF and Lecture 10.
• Week 13: Laboratory 4 and Module Revision.

Reference Books

• Database System Concepts, Fifth Edition
  A. Silberschatz, H. Korth, and S. Sudarshan, McGraw-Hill, 2005.

• Fundamentals of Database Systems, Fourth Edition
  R. Elmasri and S. Navathe, Addison Wesley, 2003.

Last updated on 19 Nov., 2008.