Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Nielit Scientist-B CS 4-12-2016
| Question 2 |
Process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as:
| normalized of data | |
| denomination of data | |
| isolation of data | |
| denormalized of data |
Question 2 Explanation:
Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly.
Most commonly used normal forms
First normal form(1NF)
Second normal form(2NF)
Third normal form(3NF)
Boyce & Codd normal form (BCNF)
Most commonly used normal forms
First normal form(1NF)
Second normal form(2NF)
Third normal form(3NF)
Boyce & Codd normal form (BCNF)
Correct Answer: A
Question 2 Explanation:
Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly.
Most commonly used normal forms
First normal form(1NF)
Second normal form(2NF)
Third normal form(3NF)
Boyce & Codd normal form (BCNF)
Most commonly used normal forms
First normal form(1NF)
Second normal form(2NF)
Third normal form(3NF)
Boyce & Codd normal form (BCNF)