SET-1
BCNF?
Boyce-Codd Normal Form
Which of the following violates 1NF?
Multiple values in one cell
What does 2NF eliminate?
Partial dependency
A relation is in 2NF if
It is in 1NF and there is no partial dependency
A ___ is normalized after it has been organized.
Database
What does 3NF aim to eliminate?
Transitive dependencies
Which of the following must be true for a relation to be in BCNF?
Every determinant is a candidate key
Which normal form removes multi-valued dependencies?
4NF
What does 5NF aim to eliminate?
Join dependency
By normalizing relations or sets of relations, one minimizes ___.
Redundancy
What is the main goal of normalization in DBMS?
Organize data to reduce redundancy and anomalies
What is a transitive dependency?
X → Y and Y → Z implies X → Z
Which of the following is a drawback of over-normalization?
Complex queries due to many joins
In addition to removing undesirable characteristics, normalization also eliminates ___ anomalies.
A common approach to normalization is to ___ the larger table into smaller tables and link them together by using relationships
Divide
Redundancy is reduced in a database table by using the ___ form
Normal
In practical applications, how many types of Normal Forms are there?
4
Which of the following is not a type of Normal Form?
2NF relations are those that are in 1NF with all the attribute types dependent on the ___ key.
Primary
When a relation is in 2NF and there is ___, it is in 3NF.
No Transition Dependency
Neither multivalued nor composite attributes, nor their combinations, may be used in the ___ normal form.
First
Non-prime attributes cannot be transitively dependent, so the relation must have the ___ normal form.
What is TRUE about BCNF?
What is TRUE about 5NF?
A relation is in ___ if it is in Boyce Codd normal form and does not have any multivalued dependencies.
4NF