Chapter 4, Problem 4.28PAE

For each of the following E-R diagrams from Chapter 2 C:

1. Transform the diagram to a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).
2. For each relation, diagram the functional dependencies (see Figure 4-23 for an example).
3. If any of the relations are not in 3NF, transform them to 3NF.

1. Figure 2-8
2. Figure 2-9b
3. Figure 2-11a
4. Figure 2-11b
5. Figure 2-15a (relationship version)
6. Figure 2-15b (attribute version)
7. Figure 2-16b
8. Figure 2-1912