Quiz
Concept 10 Practice Quiz
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (9)
1A table is in BCNF if every determinant in the table is a foreign key.
- ATrue
- BFalse
2Most designers consider the BCNF as a special case of the _____.
- A1NF
- B2NF
- C3NF
- D4NF
3Normalization should be part of the design process.
- ATrue
- BFalse
4A table is in 4NF if it is in 3NF, and _____.
- Aall attributes must be dependent on the primary key and must be dependent on each other
- Ball attributes are unrelated
- Cit has no multivalued dependencies
- Dno column contains the same values
5A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.
- ATrue
- BFalse
6Normalization is a process that is used for changing attributes to entities.
- ATrue
- BFalse
7When designing a database, you should _____.
- Amake sure that entities are in normal form before table structures are created
- Bcreate table structures then normalize the database
- Conly normalize the database when performance problems occur
- Dconsider more important issues such as performance before normalizing
8When a table contains only one candidate key, _____ are considered to be equivalent.
- Athe 1NF and the 2NF
- Bthe 3NF and the BCNF
- Cthe 4NF and the 3NF
- Dthe BCNF and the DKNF
9Normalization produces a lower normal form.
- ATrue
- BFalse
Information
- Description
- CPSI 1203 Quiz on Concept 10 Practice Quiz, created by Adam Peterson on 12/03/2018.
- Author
- Adam Peterson
- Language
- English
- Views
- 77
- Tags
- Rating
- No ratings yet Rate this quiz