CS3402 Database Systems

2009-2010 Semester A

• 20-NOV: Please send the batch file to cs3402@cs.cityu.edu.hk.
• 20-NOV: Please submit the report of the mini-project to mailbox no. 52 located outside the CS general office.
• 19-NOV: You can find the fifth assignment here. Deadline: 26-NOV.
• 19-NOV: Marks (full marks: 70) and common answers of the quiz.
• 12-NOV: You can find the fourth assignment here. Deadline: 19-NOV.
• 12-NOV: Marks and common answers of the third assignment.
• 02-NOV: The quiz will be held on 12-NOV (week 11). The scope is from the beginning up to and including Chapter 8.
• 29-OCT: You can find the mini-project and the provided dataset here. Deadline 30-NOV.
• 29-OCT: You can find the third assignment here. Deadline: 05-NOV.
• 29-OCT: Marks and common mistakes of the second assignment.
• 15-OCT: You can find the second assignment here. Deadline: 22-OCT.
• 08-OCT: Marks and common mistakes of the first assignment.
• 30-SEP: Head's message about academic dishonesty and plagiarism
• 17-SEP: You can find the first assignment here. Deadline: 24-SEP.
• Assessment pattern
• You need to use Adobe Acrobat Reader to view the .pdf file.










Week	Date	Content		Lecture	Tutorial
1	03-SEP-09	Chapter 1: Databases & Database Users Chapter 2: Database System Concepts and Architecture		Cap 1 Cap 2	Tut 1
2	10-SEP-09	Chapter 3: Data Modeling Using the Entity-Relationship Model		Cap 3	Tut 2
3	17-SEP-09	Chapter 5: Relational Data Model and Relation Database Constraints		Cap 5	Tut 3
4	24-SEP-09	Chapter 6: Relational Algebra		Cap 6	Tut 4
6	08-OCT-09	Chapter 7: Relational Database Design by ER-to-Relational Mapping		Cap 7	Tut 6
7	15-OCT-09	Chapter 8: Schema Definition, Constraints and Queries		Cap 8	Tut 7
8	22-OCT-09	Cont. Chapter 8: Schema Definition, Constraints and Queries			Tut 8
9	29-OCT-09	Chapter 10: Functional Dependencies and Normalization for Relational Databases		Cap 10	Tut 9
10	05-NOV-09	Cont: Chapter 10: Functional Dependencies and Normalization for Relational Databases			Tut 10
11	12-NOV-09	Quiz, Cont. Chapter 10			Tut 11
12	19-NOV-09	Chapter 17: Introduction to Transaction Processing Concepts and Theory		Cap 17



References:
• Elmasri & Navathe, Fundamentals of Database Systems, 5th edition, 2007.
• Garcia-Molina, Ullman, Widom, Database Systems: The Complete Book, 2nd edition, 2009.
• Silberschatz, Korth, Sudarshan, Database Systems Concepts, 5th edition, 2006.


Useful links:
• Oracle Database SQL Reference
• Academic Regulations and Records Office
• Wikipedia









Victor C S Lee Assistant Professor Department of Computer Science City University of Hong Kong Tat Chee Avenue Kowloon, Hong Kong

Phone : 852- 2788 8617 Facsmile : 852 - 2788 8614 E-Mail : csvlee@cityu.edu.hk Room : B6415