A table is in 4NF if it is in 3NF, and _____.

it has no multivalued dependencies

all attributes must be dependent on the primary key and must be dependent on each other

no column contains the same values

Quiz

Concept 9 Practice Quiz

Adam Peterson 6 questions

Take the quiz

1A table that displays data redundancies yields _____.
1. Aconsistencies
2. Banomalies
3. Cfewer attributes
4. Dmore entities
2An attribute that is part of a key is known as a(n) _____ attribute.
1. Aimportant
2. Bnonprime
3. Cprime
4. Dentity
3Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.
1. Adetermines
2. Bderives from
3. Ccontrols
4. Downs
4A table is in 4NF if it is in 3NF, and _____.
1. Aall attributes must be dependent on the primary key and must be dependent on each other
2. Ball attributes are unrelated
3. Cit has no multivalued dependencies
4. Dno column contains the same values
5All relational tables satisfy the 1NF requirements.
1. ATrue
2. BFalse
6A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.
1. Apartial dependency
2. Brepeating group
3. Catomic attribute
4. Dtransitive dependency

Description: CPSI 1203 Quiz on Concept 9 Practice Quiz, created by Adam Peterson on 12/03/2018.
Author: Adam Peterson
Language: English
Views: 69
Tags: cpsi 1203
Rating: No ratings yet
Rate this quiz
Rate this quiz