CSC 240: The Week beginning Nov. 15
Reading:
Section 13.6 in
Database Systems: Design, Implementation, & Management
(Rob and Coronel)
Homework:
Read Chapter 11 of
Database Nation
(Simson Garfinkel) and write a summary of or reaction to what you read.
Submit an ER diagram for your projects (Multimedia services database and the other one of your own design). The latter should have
At least four entities, list the important properties, indicate a primary key
At least one one-to-many relationship
At least one many-to-many relationship
State the relationships in two ways, such as, "A Congress person may be on many committees" and "A committee consists of many congress persons."
Test 3 has been scheduled for Friday December 3.
Due Nov. 22
Monday:
ER Modeling: Spa exercise
ER Modeling: User Groups exercise
Wednesday:
Perform the following database design exercises in groups or on your own.
Bus Route Entity-Relationship Modeling exercise
Temporary Employment Entity-Relationship modeling exercise (Problem 4.5 from Rob and Coronel)
Friday:
Two simple security measures and reports
Movie database