Fifth normal form (5NF) Fifth normal form (5NF)A relation is in 5NF if it is in 4NF and not contains any join dependency and joining should be lossless.5NF is satisfied…Read More
Fourth normal form (4NF) Fourth normal form (4NF)A relation will be in 4NF if it is in Boyce Codd normal form and has no multi-valued dependency.For a dependency A → B, …Read More
Third Normal Form (3NF) Third Normal Form (3NF)A relation will be in 3NF if it is in 2NF and not contain any transitive partial dependency.3NF is used to reduce the dat…Read More
Boyce Codd normal formBoyce Codd normal form (BCNF)BCNF is the advance version of 3NF. It is stricter than 3NF.A table is in BCNF if every functional dependency X → Y, X is…Read More
Relational Decomposition Relational DecompositionWhen a relation in the relational model is not relationship normal form then the decomposition of a relation is required…Read More
0 comments:
Post a Comment
Thanks