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