Management Information Systems (33:136:370) 
Spring 2016, Professor Eckstein
Assignment 7

Due: Friday, March 25
 

Perform the normalizations in each the following problems, preferably without adding any new (synthetic) fields.  Draw an entity-relationship diagram and write a database design outline for each problem.
 

Q1.   Problem 5 of draft chapter 9 (fire and rescue squad records).    
 

Q2.  Problem 4 of draft chapter 9 (the car wash).  To avoid adding a synthetic key field, you may need to use a composite foreign key, for which the standard notation looks like "(x, y) foreign key to Z".