Define 1NF 2NF 3NF BCNF
Answers
Answered by
7
1NF is the most basic of normal forms - each cell in a table must
As per First Normal Form, no two Rows of data must contain repeating group of information i.e each set of column must have a unique value, such that multiple columns cannot be used to fetch the same row
2NF
As per the Second Normal Form there must not be any partial dependency of any column on primary key.
3NF
Third Normal form applies that every non-prime attribute of table must be dependent on primary key, or we can say that, there should not be the case that a non-prime attribute is determined by another non-prime attribute
BCNF
Boyce and Codd Normal Form is a higher version of the Third Normal form
As per First Normal Form, no two Rows of data must contain repeating group of information i.e each set of column must have a unique value, such that multiple columns cannot be used to fetch the same row
2NF
As per the Second Normal Form there must not be any partial dependency of any column on primary key.
3NF
Third Normal form applies that every non-prime attribute of table must be dependent on primary key, or we can say that, there should not be the case that a non-prime attribute is determined by another non-prime attribute
BCNF
Boyce and Codd Normal Form is a higher version of the Third Normal form
Answered by
2
Explanation:
⚡⚡ Hope this'll help U ✌ ✌
Attachments:
Similar questions