Which of the following is NOT a step in the database design process?

Question 2 options:

a)

Create tables and columns from entities and attributes

b)

Select primary keys

c)

Represent relationships

d)

Create constraints and triggers

Which of the following is NOT true about a NULL attribute?

Question 7 options:

a)

On insertion, entering the data for that field is optional.

b)

It is an important property of an attribute.

c)

It must have a default value specified.

d)

A primary key can't be NULL.

Which of the following is NOT a common variant of the E-R model?

Question 8 options:

a)

IE Crow's Foot

b)

IDEF1X

c)

UML

d)

Object-oriented

In a minimum cardinality, minimums are generally stated as:

Question 9 options:

a)

0 or 1.

b)

1 or N.

c)

M or N.

d)

one or many.

An occurrence of a particular entity is called an entity:

Question 13 options:

a)

class.

b)

relationship.

c)

instance.

d)

attribute.

Maximum cardinality refers to:

Question 14 options:

a)

the most instances of one entity class that can be involved in a relationship instance with another entity class.

b)

the minimum number of entity classes involved in a relationship.

c)

whether or not an instance of one entity class is required to be related to an instance of another entity class.

d)

whether or not an entity is a weak entity.

A composite attribute is an attribute that:

Question 15 options:

a)

is multivalued.

b)

describes a characteristic of the relationship.

c)

consists of a group of attributes.

d)

is calculated at run-time.

Which of the following is NOT true of MUST constraint?

Question 16 options:

a)

It may be needed in ternary relationships to enforce special business rules.

b)

It can be expressed directly in a relational model.

c)

It must be enforced by program code.

d)

It requires that one entity be combined with another entity.

Which of the following is true about N:M recursive relationships?

Question 17 options:

a)

N:M recursive relationships cannot be used to model directed networks.

b)

Since it is a recursive relationship, an intersection table is not needed.

c)

The foreign keys in the intersection table can't refer to the same attribute in the parent table.

d)

Both foreign keys in the intersection table refer to the same table.