• Consider the following E-R diagram.
  • Transform this E-R diagram into a set of 3NF relations.
  • State and justify all referential integrity rules for the 3NF relations you created
  • Choose primary keys for the files that would hold the data for these  relations. Did you use attributes from the relations for primary keys  or did you design new fields? Why or why not?