Database System Design (2001)

Textbook | Lecture Notes | Handouts and Solutions | Projects | Recommended Readings | Useful Links | Homepage

Textbook

The course uses A First Course in Database Systems  by Jeff Ullman and Jennifer Widom as the textbook. This book covers many important points in the teaching of database systems. The approach at HUST has been to use the first database course, CS183, to cover the material most useful to the great majority of students in Computer Science: databases from the point of view of the database designer, user, and application programmer. The course has been given to advanced undergraduates and beginning master students in Chinese and foreign master and PhD students in English.

Some of the features of the textbook are:

  1. Comprehensive coverage of SQL programming.
  2. Design of databases using both the E/R model and the ODMG-standard ODL are covered and contrasted.
  3. Explains object-oriented and object-relational database programming with coverage of the ODMG-standard OQL and object-oriented features of SQL3.
  4. Covers advanced database programming, including integrity constraints, assertions, triggers, and recursion in SQL3.
The Table of Contents of the Second Edition (Database Systems: The Complete Book) gives more detail regarding the scope of the latest book.

Lecture Notes

Lecture Note 1.   Introduction to Database Systems (PDF).
Lecture Note 2.   Entity-Relationship(E/R) Model (PDF).
Lecture Note 3.   More E/R: ODL (PDF). 
Lecture Note 4.   Keys, Subclasses, Weak entity sets (PDF). 
Lecture Note 5.   Design principles, Network and hierarchical models (PDF).
Lecture Note 6.   Relational model (PDF). 
Lecture Note 7.   More relational model: Functional dependencies (PDF). 
Lecture Note 8.   Normalization (PDF). 
Lecture Note 9.   Relational algebra (PDF). 
Lecture Note 10. SQL queries (PDF). 
Lecture Note 11. More SQL: Database Modification (PDF).
Lecture Note 12. Schemas: Views: Nulls (PDF). 
Lecture Note 13. Outerjoins: Constraints: Triggers (PDF). 
Lecture Note 14. PL/SQL, Embedded SQL (PDF).
Lecture Note 15. 3NF: Multivalued dependencies: 4NF (PDF).
Lecture Note 16. Datalog (PDF). 
Lecture Note 17. Recursion and stratification in SQL3 (PDF). 
Lecture Note 18. OQL (PDF).
Lecture Note 19. More OQL (PDF).
Lecture Note 20. SQL3 objects (PDF).

Notes: This course is taught in English.

Handouts and Solutions

Solutions to Exercise 1 . 
Solutions to Exercise 2 . 
Solutions to Exercise 3 . 
Solutions to Exercise 4 . 
Solutions to Exercise 5 . 

Middle Term Examination.

Final Examination.

Projects

Here is a small project about The Shutter Shop.

Recommended Readings

1. Database System Concepts (Abraham Siberschatz, Henry F.Korth and S.Sudarshan), China Machine Press, Mc Graw_Hill.
2. An Introduction to Database Systems (C.J.Date), China Machine Press, Addison_Wesley.
3. Database System Implementation (Hector G. Molina, Jeff Ullman and Jennifer Widom), China Machine Press, Prentice Hall.
4. The Concepts of Database Management (Philip J.Pratt and Joseph J.Adamski), China Machine Press, Prentice Hall.
5. Database Processing - Fundamentals, Design and Implementation (David M. Kroenke), Publishing House of Electronics Industry, Prentice Hall.

Useful Links

If you are ready to be devoted to database systems, you should cherish these web sites which directs you to numerous precious web resource. 

Forum

 Here opens a forum for Database System Design. Welcome to it.

Ruixuan Li
College of Computer Science and Technology,
Huazhong University of Science and Technology 
Wuhan 430074, Hubei, P.R.China
Phone: 86-27-87544285
E-mail: rxli2001(a)hotmail.com