Question: 3 . 3 Convert the following report into a set of 3 NF tables. Clearly describe and show each step. You only need to provide

3.3 Convert the following report into a set of 3NF tables. Clearly describe and show each step. You only need to provide relational schema. (25)
\table[[\table[[EMP_I],[D]],\table[[EMP_NAM],[E]],\table[[EMP_SU],[R]],\table[[POS_I],[D]],\table[[POS_DES],[C]],\table[[DEP_I],[D]],\table[[DEP_DES],[C]],\table[[SALAR],[Y]]],[78990,Masibonge,Griffiths,8,Manager,,,45000],[73220,Safwaan,Zuma,7,\table[[Programm],[er]],1,Spouse,38000],[76440,Sammy,George,20,Designer,,,25000],[79001,Elizabeth,\table[[Makhany],[a]],7,\table[[Programm],[er]],2,\table[[Spouse,],[Girl]],38000],[77991,Rakhil,Joseph,20,Designer,4,Girl, Boy,25000]]
 3.3 Convert the following report into a set of 3NF tables.

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