Question: Transform the ER model below into a set of 3NF relations. Use the format showri here for relations: FACULTY (FacID, LastName, FirstName, Rank, DeptID) FK

 Transform the ER model below into a set of 3NF relations.

Transform the ER model below into a set of 3NF relations. Use the format showri here for relations: FACULTY (FacID, LastName, FirstName, Rank, DeptID) FK DeptID DEPT DEPT (DeptID, DeptName, DeptPhone) You must underline all components of each primary key. Denote each foreign key directly beneath the relation that contains the foreign key, as shown above. Do not use the graphical notation from the textbook. The notation shown above is the notation you will be required to use on this exam. Be sure that all relations are in 3NF (if you follow the transformation rules taught in class, they will be)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!