E-R Diagram

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 createdChoose 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? Order now and Get 10% Discount! Use Code "GET10" in your order"