For each of the following EER diagrams from Chapter 3: I. Transform the diagram into a...

For each of the following EER diagrams from Chapter 3:

I. Transform the diagram into 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 3-6b

b. Figure 3-7a

c. Figure 3-9

d. Figure 3-10

e. Figure 3-11

Reference figure 4-5

Reference figure 4-23