Course Materials:
Required:

• Database Systems - Design, Implementation, and Management 10e by Coronel/Morris/Rob (Course Technology)

Other Books of Interest:

• A Guide to mySQL Pratt and Last (Thomson Course Technology)

---

Click here for the Course Syllabus

Lecture Notes

Click below to open a lecture and view online.
You can then print or save a copy on your machine

• Chapter 1 - Database Systems
• Chapter 2 - Data Models
• Chapter 3 - Relational Database Model
• Chapter 4 - E-R Modeling
• Chapter 5 - Advanced Data Modeling
• Chapter 6 - Normalization of Database Tables
• Chapter 7 - Introduction to SQL
• Chapter 8 - Advanced SQL      SQL code to create tables and run queries from lecture
• Chapter 10 - Transaction Management & Concurrency Control
• Chapter 12 - Distributed Database Management Systems

---

Assignments

Homework 1: (Due Feb 4)
• Chapter 1 - Problems 1-10 (page 30-31) Page 1 Page 2
• An Access exercise to clear the cobwebs

Homework 2: (Due Feb 6) Chapter 2 - Problems 14,15, 16a, 16b

Homework 3: (Due Feb 20) Chapter 3 - Problems 8, 11, 12, 13, 14, 18, 19, 22, 23

Homework 4: (Due Mar 11) ER and Normalization         In Class Examples

Homework 5: (Due Apr 8)Chapter 7 Problems - 7.1, 7.2, 7.5, 7.6, 7.8, 7.11, 7.12, 7.13, 7.16, 7.21. 7.22, 7.23, 7.24 (treat the query from 23 as a saved query and use it to complete 24), 7.26, 7.27, 7.29 (uses 4 tables), 7.30, 7.31         Answers to homework

Homework 6: (Due Apr 22)Chapter 8 Problems - 8.3, 8.5, 8.6, 8.7, 8.8, 8.10, 8.11, 8.13, 8.14, 8.15         Answers to homework

Chapter 10 Solved exercises

Chapter 12 Solved exercises

---

Articles & Downloads

• mySQL (software and documentation)
• Microsoft SQL Server Express Edition
• Oracle Database 11g Express Edition
• A Relational Model of Data for Large Shared Data Banks E.F. Codd, CACM, June,1970
• The Entity-Relationship Model - Toward a Unified View of DataPeter Chen, ACM Trans. on Database Systems, March 1976