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 Fragen

Quiz starten

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. ARichtig
2. BFalsch
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

Beschreibung: CPSI 1203 Quiz am Concept 9 Practice Quiz, erstellt von Adam Peterson am 12/03/2018.
Autor: Adam Peterson
Sprache: English
Aufrufe: 69
Schlagwörter: cpsi 1203
Bewertung: Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz