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".