Business Rules :
- An employee may work in many departments.
- Each employee has a unique employee number.
- Each departments has many managers.
- An employee has only one manager for each department
- Each manager can manage only one department.
- Each employee has only one Name.
The given table is in which normal form?
according to me the following FDs can be generated:
eid → ename
eid,dept → manager
manager → dept
with the above FDs the relation should be in 1NF, but the answer given is 2NF. HOW?
NOTE : according to the solution eid should be the primary key. BUT how can you find manager with only eid?