Technical Discussion :: DBMS
Home > Freshers > Technical Interview Questions > DBMS
64. What is 5NF?
Answer:
A Relation schema R is said to be 5NF if for every join dependency {R1, R2, ..., Rn} that holds R, one the following is true
> Ri = R for some i.
> The join dependency is implied by the set of FD, over R in which the left side is key of R.
Asked In :: iGate Virtusa Syntel Inc. Accenture Sapient Sopra Steria
A Relation schema R is said to be 5NF if for every join dependency {R1, R2, ..., Rn} that holds R, one the following is true
> Ri = R for some i.
> The join dependency is implied by the set of FD, over R in which the left side is key of R.
> Ri = R for some i.
> The join dependency is implied by the set of FD, over R in which the left side is key of R.