📝 Question
#1251
Which forms are based on the concept of functional dependency:
✓
Correct Answer
A. 1NF
💡
Explanation
The table is in 3NF if every non-prime attribute of R is non-transitively dependent (i.e. directly dependent) on every superkey of R. 10. Empdt1(empcode, name, street, city, state, pincode). a) 1 NF only b) 2 NF and hence also in 1 NF c) 3NF and hence also in 2NF and 1NF d) BCNF and hence also in 3NF, 2NF and 1NF The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.
⌨️ Press
A
B
C
D
to select