Teaching HPSC Lecturer (Technical) Mock Test 2024 DBMS Integrity Constraints and Normal Form Normal Form
A relational database which is in 3NF may still have undesirable data redundancy because there may exist
1
Transitive functional dependencies.
2
Non-trivial functional dependencies involving prime attributes and the right side.
3
Non-trivial functional dependencies involving prime attributes only on the left side.
4
Trivial functional dependencies involving number of attributes.
5
Question Not Attempted