Advantage of Normalization is:
-It reduce the redundancy of the data from the table.
-It remove the anomaly problem
What is Normalization in Database?
What is Anomaly problem?
What is Insertion anomaly?
What is deletion anomaly?
What we do to solve the Anomaly problem?
How many type of Normalization is possible?
What is first normal form?
What is second normal form?
What is third normal form?
What is the full form of BCNF?
What do you understand by BCNF?
What is prime attribute?
What is Non prime attribute?
What is partial dependency in database table?
What is Transitive dependency?
Difference between prime and non prime attribute?
What is prime and non attribute in table attribute?
What we called the attribute which is part of the candidate key?
What we called the attribute which is not part of the candidate key?
What do you understand by the key in database?
What is the super key?
What is candidate Key?
Difference between Superkey and candidate key?
What is primary key?
Difference between candidate key and primary key?
What is Alternate key?
What is Sub-ordinate Key?
What is Foreign Key?
What is Unique Key?
What is the Difference between Primary key and Unique key?
What is the Difference between Primary key and foreign Key?
What is the purpose of the Normalization in database?
In which Normal Form, the chance of data lose is their?
In there is no partial dependency in the table then table is in which Normal Form?
If there is no transitive dependency in the table then table is in which normal form?
What is De-normalization?
If there is only two column or 2 attribute in the table then table is in which Normal form?
Advantage of the Normalization?
We any Non prime attribute defines the Another non prime attribute of the same table then this dependency is called as?
If we delete the primary of one table then what about the foreign key which refer to that primary key?