Figure 4-38 shows an EER diagram for a university dining service organization that provi...

Figure 4-38 shows an EER diagram for a university dining service organization that provides dining services to a major university.

a. Transform the EER diagram to a set of relations and develop a relational schema.

b. Diagram the functional dependencies and determine the normal form for each relation.

c. Convert all relations to third normal form, if necessary, and draw a revised relational schema.

Reference figure 4-38