II CSE- Data SCIENCE - DBMS

Front

What is the primary goal of normalization in database design?

Back

Minimize data redundancy and avoid anomalies

Front

Which normal form eliminates partial dependency?

Back

2NF

Front

A table is in First Normal Form (1NF) if:

Back

It contains only atomic values

Front

In which normal form are transitive dependencies removed?

Back

3NF

Front

Which normal form ensures that every determinant is a candidate key?

Back

BCNF

Front

If a table is in BCNF, which of the following must be true?
It is also in 2NF and 3NF, It has no partial dependencies, It has no multi-valued dependencies, All of the above

Back

All of the above

Front

Which of the following anomalies does normalization aim to reduce? Insertion anomalies, Update anomalies, Deletion anomalies, All of the above

Back

All of the above

Front

A table with multivalued dependencies, but no partial or transitive dependencies, is in which normal form?

Back

4NF

Front

A relation is in Fifth Normal Form (5NF) if:

Back

It has no join dependencies.

Front

What is the main reason for using normalization in databases?

Back

To reduce redundancy and improve consistency