Question: For the question below, there is one big table representing electrical work done for various jobs. Put the table in normalized form as specified. JID

For the question below, there is one big table representing electrical work done for various jobs. Put the table in normalized form as specified. JID = Job ID, J_Date = Job Date, J_Name = Job Name EID = Employee ID, E_Name = Employee Name PID = Part ID, P_Name = Part Name, P_Price = Part Price, Qty = Quantity Used Functional Dependencies are: JID -> J_Date JID -> J_Name PID -> P_Name PID -> P_Price JID -> EID EID -> E_Name PID and JID -> Qty JID J_Date J_Nam EI E_Nam PI P_Name P_Pric Qty e D e D e 10 01/14/20 Johnso 2 1 14 n 1.20, 12, Wire 1.50 3 2, Wire, 1.50, 3, Switch, 3.75, 1, 7 1 2 3 4 Bolt, 5, Amy 1, 2 10 01/15/20 Blakely 1 2 14 Rahul Fan 130.00 1 Put the above table in 1NF Table(s) (5 points) Put the above table(s) in 2NF (5 points) Put the above table(s) in 3NF Tables (5 points) Final set of Tables with meaningful names and PKs and FKs (15 points). NOTE: The final set of tables should have meaningful names with Primary Keys and Foreign Keys* clearly identified. The format should be as follows: Faculty (FID, LName, Phone, Salary) Course (CID, Course_Name, FID*)

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!