wiz-icon
MyQuestionIcon
MyQuestionIcon
4
You visited us 4 times! Enjoying our articles? Unlock Full Access!
Question

5 NF is related to ______________.

A
Functional dependency
No worries! We‘ve got your back. Try BYJU‘S free classes today!
B
Multivalued dependency
No worries! We‘ve got your back. Try BYJU‘S free classes today!
C
Join dependency
Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses
D
None of these
No worries! We‘ve got your back. Try BYJU‘S free classes today!
Open in App
Solution

The correct option is C Join dependency

5 NF is related to join dependency.

Fifth normal form (5NF), also known as project-join normal form (PJ/NF) is a level of database normalization designed to reduce redundancy in relational databases recording multi-valued facts by isolating semantically related multiple relationships. A table is said to be in the 5NF if and only if every non-trivial join dependency in that table is implied by the candidate keys.

Join dependency is a constraint on the set of legal relations over a database scheme.


923240_918502_ans_8621d50eea3c471c8affd4dd38194ac8.PNG

flag
Suggest Corrections
thumbs-up
0
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Database Structuring
ACCOUNTANCY
Watch in App
Join BYJU'S Learning Program
CrossIcon