QUIZ NORMALIZATION
Authored by MARY GRACE VENTURA
Other
University
Used 61+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
21 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If there is more than one key for relation schema in DBMS then each key in relation schema is classified as
primary key
candidate key
composite key
foreign key
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The form of dependency in which the set of attributes that are neither a subset of any of the keys nor the candidate key is classified as
partial dependency
transitive dependency
full functional dependency
functional dependency
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If every non-key attribute is functionally dependent on the primary key, then the relation will be in
First Normal Form
Second Normal Form
Third Normal Form
Fourth Normal Form
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Atomicity of domains of attributes is related to
First Normal Form
Second Normal Form
Third Normal Form
Fourth Normal Form
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following statement is INCORRECT?
Data Redundancy can be handled by inconsistency
Redundancy in date may lead to its inconsistency
Inconsistency in data may lead to redundancy
Data inconsistency can be handled by Redundancy
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The table attached is an example of First Normal Form.
TRUE
FALSE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the case of Database normalization the order of the rows and columns is immaterial;
TRUE
FALSE
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
