Quiz on Normalization
Quiz by LUCY FELIX
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
A relation is in 1NF if it doesn't contain any_______________
Functional Dependencies
Partial Dependencies
Determinants
Repeating groups
30s - Q2
A table is in 2NF if it is 1NF and what other condition is met?
There are no repeating groups
There are no null values in the primary key field
There are no functional dependencies
There are no attributes that are not functionally dependent on the relation's primary key.
30s - Q3
When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?
Create a primary key for the new relation
Assign both relations the same primary key fields
Link the relations by a common field
Remove any functional dependencies from both relations
30s - Q4
If every non-key attribute is functionally dependent on the primary key, then the relation is in
1NF
2NF
BCNF
3NF
30s - Q5
Which of the following set of dependencies is suitable for making a relation R(A,B,C,D) to be in 3NF?
A->B,C,D B->C,D C->D
A,B->C,D C->D,A
A,B->C,D, A->C, D->B
A,B->C,D A->C B->D
30s - Q6
Choose the incorrect statement
A relation in 2NF must also be in 1NF
A relation in 3NF must also be BCNF
A relation in BCNF must also be 3NF
A relation in 3NF must also be in 2NF
30s - Q7
In databases, de-normalization is used for
Performance Tuning
Deleting tables in normal forms
Database backup
Eliminating Redundancy
30s - Q8
The atomicity of domains of attributes is related to
2NF
3NF
BCNF
1NF
30s - Q9
Which of the following statements is correct?
Data redundancy can be handled by inconsistency
Inconsistency in data may lead to data redundancy
Redundancy in data may lead to data inconsistency
Data inconsistency can be handled by data redundancy
30s - Q10
Occurs when an attribute is functionally dependent on a non-key attribute.
Multi-valued dependency
Full Dependency
Transitive Dependency
Partial Dependency
30s - Q11
Relation R has eight attributes a,b,c,d,e,f,g,h. The following functional dependencies apply,
i,) b,e,h->g
ii.) b->c,f,d
iii.) e->a
iv.) f->d
Which of the following dependencies are partial dependencies
i, ii
ii,iv
ii,iii
i
i, ii, and iii
iv
30s - Q12
Relation R has eight attributes a,b,c,d,e,f,g,h. The following functional dependencies apply,
i,) b,e,h->g
ii.) b->c,f,d
iii.) e->a
iv.) f->d
Which of the following dependencies are full dependencies
i
ii,iv
ii,iii
i, ii
i, ii, and iii
iv
30s - Q13
Relation R has eight attributes a,b,c,d,e,f,g,h. The following functional dependencies apply,
i,) b,e,h->g
ii.) b->c,f,d
iii.) e->a
iv.) f->d
Which of the following dependencies are transitive dependencies
ii,iii
i, ii, and iii
i
i, ii
iv
ii,iv
30s - Q14
The given table shows a relation called GRADE REPORT for a university. What is the primary key of the relation?
StudentId and CourseId
StudentId
StudentId, CourseId, Major, and InstructorName
StudentId, CourseId and InstructorName
30s - Q15
The given table shows a relation called GRADE REPORT for a university. In what normal form is this relation?
3NF
2NF
1NF
BCNF
30s
