Database Design Quiz

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

• TRUE

• FALSE

By default, the identifier of the entity becomes the foreign key of the corresponding table.

• TRUE

• FALSE

The ideal primary key is short, numeric, and fixed.

• TRUE

• FALSE

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

• TRUE

• FALSE

One of the important properties of an attribute is whether or not it is required.

• TRUE

• FALSE

A surrogate key is a unique, system-supplied identifier used as the primary key of a table.

• TRUE

• FALSE

The values of a surrogate key have no meaning to the users.

• TRUE

• FALSE

A surrogate key should be considered when the key contains a lengthy text field.

• TRUE

• FALSE

Data types are consistent across all DBMS products.

• TRUE

• FALSE

A data constraint is a limitation on data values.

• TRUE

• FALSE