Question: Normalize the given table of company data into 1st Normal Form, 2nd Normal Form and 3rd Normal Form. The table shows information about Projects,

Normalize the given table of company data into 1st Normal Form, 2nd Normal Form and 3rd Normal Form. The

Normalize the given table of company data into 1st Normal Form, 2nd Normal Form and 3rd Normal Form. The table shows information about Projects, Employees and Departments: P_ID P_Name P_Saving E_ID E_Name D_ID D_Name 101 JAK 1000 111 Ju 1 AA 101 JAK 1000 222 Wu 2 BB 101 JAK 1000 333 Su 3 CC 102 JFK 2000 444 Ka 3 CC 102 JFK 2000 555 Ja 2 BB 102 JFK 2000 666 Ma 1 AA 103 GBG 3000 777 Du 3 CC 103 GBG 3000 888 Hi 2 BB 103 GBG 3000 999 Bu 1 AA Describe the normalization steps you follow in each Normal Form(1st, 2nd, and 3rd) and list the relations in each Normal Form. For example: 1st NF: To transpose a relation into 3rd NF we need to eliminate repeating groups. Hence, the give table has ..... as repeated groups. The output relations are: R1, R2(... .) 2nd NF: To transpose a relation into 2nd NE, we need to 3rd NF: To transpose a relation into 3rd NF we need to.....

Step by Step Solution

3.30 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1st Normal Form 1NF The ... View full answer

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 Programming Questions!