|
For the example below we have one big table. Put the table in 3rd normal form.
Eid = Employee id, Pid = project id, Mid = Manager id
Functional Dependencies are:
Eid -> ename eid -> pid pid -> mname
Pid -> pname Pid -> mid Mid -> mname
Eid Ename Pid Pname Mid Mname
E01 John p1 Eco DBMS m1 Becky
E02 Mary p2 Admin. m2 Joe
E03 Mark p2 Admin m2 Joe
E04 Travis p3 Educ. m1 Becky
how to do this? As in first form we have to eliminate duplication but in this table I can't capture any duplicate record?
|
