AIncorrect Answer

In general one or more attributes will contibute to the primary - but not necessarily all of them.

close

BIncorrect Answer

It is the other way around. Non-key attributes are determined by key attributes.

close

CCorrect Answer

This is true for any relation in third normal form.

close

DIncorrect Answer

This is true for a relation in BCNF. A relation in 3rd normal form might not have this property.

close

EIncorrect Answer

A relation in 3rd normal form may also be in 4th normal form. However there are exceptional cases where a relation is in third normal form but NOT in 4th normal form.

close

A B C D E TELL ME NEXT INDEX
 
 

A given relation is known to be in third normal form. Select the statement which can be inferred from this:

  1. All attributes contribute to the primary key

  2. Each non-key attribute determines the primary key

  3. Each non-key attribute is determined by the primary key

  4. Every determinant is a candidate key

  5. The relation is not in fourth normal form.