Dr. Robert K. Moniot

Back to Classes page

CSEU 3500 -- Data Base Systems, Spring, 2004

Syllabus: Click Here

Homework Schedule

1. Due February 4: Chapter 1
2. Due February 18: Chapter 2
3. Due March 3: Chapter 3
4. Due March 24: Chapter 4, first set
5. Due April 7: Chapter 4, second set
6. Due April 21: Chapter 6
7. Due May 5: Chapter 7

Quiz Schedule

1. February 4: Chapter 1 (all), Chapter 2 (sections 1-5)
2. February 18: Chapter 2 (sections 5-9), Chapter 3 (section 1)
3. March 10: Chapter 3 (sections 2-5), Chapter 4 (sections 1-2)
4. March 31: Chapter 4 (sections 1-7)
5. April 14: Chapter 4 (sections 9, 11), Chapter 6 (sections 1-4)
6. May 5: Chapter 7 (sections 1-7)

Resources

• Here is a link to the textbook's web page.
• Various alternative solutions to the hospital database design, Exercise 2.3.
• SQL commands to install the employee database and populate it with data for the homework exercises 4.2. If you do not use PostgreSQL, you may need to make minor changes in syntax (e.g. eliminating comments) in order to make it acceptable to your database system.
• SQL commands to install the banking database and populate it with the data of Chapter 3 for use in practicing queries.
• Instructions for using SQL on erdos.
• Quick reference for SQL select statement.
• Quick reference for SQL where clause.
• Guide to drawing and using functional dependency diagrams.