RDBMS

The different classes of relations created by the technique for preventing modification anomalies are called

• Normal forms

• Referential intergrity constraints

• Functional dependencies

• None of the above

A functional dependency is a relationship between or among attributes

• True

• False

A relation in this form is free of all modification anomalies

• First normal form

• Second normal form

• Third normal form

• Domain/key normal form

A BCNF is

• loss less join and dependency preserving

• loss less join but dependency preserving

• not loss less join but dependency preserving

• None of these

A primary key can point to more than one object

• True

• False

In the __________ normal form, a composite attribute is converted to individual attributes.

• Third

• Second

• First

• Fourth

A functional dependency is a relationship between or among:

• Tables.

• Rows.

• Relations.

• Attributes.

ER diagram Can be used by data base designers as a __________

A realation will be 1NF if it contains an________

• Atomic value

• Relation value

• Single value

• None of the above

Functional dependencies are a generalization of ?

• Relation dependencies

• Data base dependencies

• Key dependencies

• None of these