NEW
Font size
WorksheetsIMS.
Total questions: 10
Worksheet time: 10mins
_______________ is a database schema design technique in which an existing schema is modified to minimize redundancy and dependency on data.
Database
para-normalization
Database normalization
Database foreign key
None of them
Belongs to advantages of normalization
minimize data redundancy.
Greater overall database organization.
flexible database design
All of them
Normalization splits a large table into smaller tables and defines relationships between them to increase clarity in organizing data.
True
False
Reasons for Normalizing database
Skill Matching
Collaboration and Team Formation
Making relations very large
All of them
Each table cell should contain a single value
3NF
1NF
2NF
4NF
The entity should be considered already in 1NF
1NF
2NF
3NF
None of them
is a drawback of Normalization
Careless decomposition may lead to a bad database design, leading to serious problems.
Greater overall database organization.
It reinforces the concept of relational integrity.
All of them
represented as a ________ Form of normalization.
1NF
2NF
3NF
BCNF
____________ specifically refers to a situation in which an attribute in a relation depends on only a part (or a subset) of the primary key rather than the entire primary key.
Dependency
Partial dependency
BCNF
None of them
To resolve partial dependency, we need ______________ Technique
First Normal Form
Second Normal Form
Third Normal Form
