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 perguntas

Fazer o 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. AVerdadeiro
2. BFalso
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

Descrição: CPSI 1203 Quiz sobre Concept 9 Practice Quiz, criado por Adam Peterson em 12-03-2018.
Autor: Adam Peterson
Idioma: English
Visualizações: 69
Etiquetas: cpsi 1203
Avaliação: Ainda sem avaliações
Avalie este quiz
Avalie este quiz