CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 16

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 .

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 .