Figure 4-40 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.