Consider the following E-R diagram. Transform this E-R diagram into

 

  • 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?
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Get 15% Discount: Coupon code [ SAVE15 ]