Database systems:

Transform the given ER model into a set of 3NF relations. Use the format shown below 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 here is the notation you will be required to use on exams. Be sure that all relations are in 3NF