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?

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions