what is normlization explain different type of normal forms
Answers
Answer:
By Chaitanya Singh | Filed Under: DBMS. Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly.
thank you
HOPE IT MAY HELP YOU
PLEASE FOLLOW , LIKE AND AT LEAST BRAIN LIST ME
Answer:
Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly.
Different types of normal forms:—
1. First Normal Form (or 1NF)
Columns must have single values. Columns must have unique names. Values of a given attribute must be of the same data type. No two records (or rows) can be identical.
2. Second Normal Form or 2NF
It is in first normal form or 1NF. It doesn’t contain any partial dependencies. (It shouldn’t have any non-prime attribute which is functionally dependent on any proper subset of the candidate key of the relation.).
3. Third Normal Form or 3NF
R should be in 2NF. X should be candidate key or superkey, or Y should be prime attribute. (So basically the relation which is in 2NF already if it doesn’t contain any transitive dependencies then it will be in 3NF).
4. Elementary key normal form or EKNF
It the improve version of the third normal form, thus generally EKNF is itself in 3rd Normal Form. When there is more than one unique compound key and the keys are overlapped then this leads to the redundancy in the overlapping column.
Thus if in the 3NF relation each and every non-trivial functional dependency involves with either a superkey or an elementary key’s subkey then it is in EKNF.