The relation scheme Employee_Bonus(ID, Name, , Department, Increm
|
The relation scheme Employee_Bonus(ID, Name, , Department, Increment) has the following functional dependencies
Name, Department → Increment
ID, name → Increment
ID → Name
Name → ID
The highest normal form of this relation schema is _____.A. 1NF
B. 2NF
C. 3NF
D. BCNF
Please scroll down to see the correct answer and solution guide.
Right Answer is: A
SOLUTION
{Name, Department}+ = {Name, Department, ID, Increment}
{ID, Department}+ = {ID, Department, Name, Increment}
{Name, Department} and {ID, Department} are keys
Since:
{Name}+ = {Name, ID, Increment}
∴ Name → increment
Since Name is a part of a key and increment is a non-key
Therefore, relation Employee_Bonus is not in 2NF
Since relation is not in 2NF, relation cannot be in 3NF and if relation is not in 3NF it cannot be in BCNF
Hence option 1 is correct.