CIS 336 All Assignments CIS 336 All Assignments | Page 14

secondary
redundant
4. (TCO 2) A field that consists of integer values is a _________ type field. (Points : 4)
Date/Time
Yes/No
Memo
Numeric
5. (TCO 3) The PK must uniquely identify each entity instance. A primary key must be able to
guarantee unique values. It cannot contain nulls. This rationale belongs to ____. (Points : 4)
Unique values
Nonintelligent
Preferably single-attribute
Security complaint
6. (TCO 3) A table that is in 1NF and includes no partial dependencies only is said to be
in_____________. (Points : 4)
1NF.
2NF.
3NF.
4NF.
BCNF.
7. (TCO 3) A table that has all key attributes defined, has no repeating groups, and all its
attributes are dependent on the primary key, is said to be in_____________.(Points : 4)
1NF.
2NF.
3NF.