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

Test

Concept 9 Practice Quiz

Adam Peterson 6 preguntas

Hacer el test

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. AVerdadero
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

Descripción: CPSI 1203 Test sobre Concept 9 Practice Quiz, creado por Adam Peterson el 12/03/2018.
Autor: Adam Peterson
Idioma: English
Visitas: 69
Etiquetas: cpsi 1203
Valoración: Aún sin valoraciones
Valora este test
Valora este test