For each of the following E-R diagrams from Chapter 2:
I. Transform the diagram to a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema):
II. For each relation, diagram the functional dependencies (see Figure 4-23 for an example).
III. If any of the relations are not in 3NF, transform them to 3NF.
a. Figure 2-8
b. Figure 2-9b
c. Figure 2-lla
d. Figure 2-llb
e. Figure 2-15a (relationship version)
f. Figure 2-15b (attribute version)
g. Figure 2-16b
h. Figure 2-19