276 views
0 votes
0 votes

Business Rules : 

  1. An employee may work in many departments.
  2. Each employee has a unique employee number.
  3. Each departments has many managers.
  4. An employee has only one manager for each department
  5. Each manager can manage only one department.
  6. 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?

Please log in or register to answer this question.

Related questions

2 votes
2 votes
0 answers
1
2 votes
2 votes
1 answer
2
4 votes
4 votes
1 answer
3
1 votes
1 votes
2 answers
4
Na462 asked Jun 29, 2018
545 views