Question: Please normalize this table up to 3 normal form. You need to explain the steps of normalization by showing functional dependencies and show the final

Please normalize this table up to 3 normal form. You need to explain the steps of normalization by showing functional dependencies and show the final normalized tables. (Ex.
Sname Saddress, Sphone ) ***You need to identify whether there is one attribute as PK or a set of attribute as PK. If there is only one attribute as PK, then the table is already in 2NF because non-key attributes are fully dependent on the PK. If there are more than one attribute as PK - like 2 attributes, then you need to identify specific non-key attributes that are fully dependent on both attributes or attributes that are partially dependent on one of attributes, which makes tables in 2NF.
EMP NUM EMP EMP EMP DEPENDENTS DEFT DEPT NAME BIP- NAGERILE EMPDOB |EMP-HIRE EMP- ENP-BAS | EMP COM LNAME |EDUCATION DATE |TRAINING|E. MISSION SALARY RATE 015 willaker IBBA.MRA SLS Geraild (spouse), Mary John MATO H. Marin Mrtin Salies Agent 25195 717 L1,12 8255 003 (daughter), (son) mith BBA MKTG MarktiH.Martin Sales Agent 28942 38732 019 McGuie INT oAnne (spouse) SVC 19750 G.Ortez IDB Adnua |21751 |36356 ILLLJ.LA. |12 x LIS
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
