CS403P Quiz 9

A relation is in third normal form if ________.

A

It has a transitive dependency

B

It has a partial dependency

C

It has multivalued attributes

D

It is already in second normal form

A table is in third normal form if it is in second normal form and there is no __________.

A

Consistency

B · Transitive dependency · C

Full functional dependency

D

Partial dependency

Consider the following relation: STD(stId, stName, stAdr, prName, prCrdts) stId → stName, stAdr, prName, prCrdts prName → prCrdts Which of the following dependency exist in above relation?

A

Terminal dependency

B

Reflexive dependency

C · Transitive dependency · D

Composite dependency If a relation is not in third normal form, then anomalies are due to ________.

A

Reflexive dependency

B

Partial dependency

C

Full functional dependency

D

Transitive dependency

A transitive dependency occurs when __________.

A

Primary key attribute is dependent on non-key attribute

B

Non-key attribute is not dependent on another non-key attribute

C

D

Part of the key is dependent on key attribute The anomalies caused by transitive dependency in a relation are removed by __________.

A

Changing primary key

B

Reducing number of columns

C · Breaking down the relation · D

Reducing number of rows