For each of the following E-R diagrams from Chapter 2: I. Transform the diagram to a re...

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-11a

d. Figure 2-11b

e. Figure 2-15a (relationship version)

f. Figure 2-15b (attribute version)

g. Figure 2-16b

h. Figure 2-19

figure 4-23 Representing functional dependencies

Figure 4-5

Figure 2-8

Figure 2-9b

Figure 2-11b

Figure 2-15a

Figure 2-15b

Figure 2-16

Figure 2-19