Exam 2: Modeling Data in the Organization

Which of the following criteria should be considered when selecting an identifier?

A good data definition is always accompanied by diagrams, such as the entity-relationship diagram.

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

In the figure shown below, a person has to be married.

A(n) ________ is the relationship between a weak entity type and its owner.

The following figure shows an example of:

When systems are automatically generated and maintained, quality is diminished.

A business rule is a statement that defines or constrains some aspect of the business.

In the figure below, the name of the relationship follows the guidelines for naming a relationship.

In the following diagram, what type of relationship is depicted?

The degree of a relationship is the number of attributes that are associated with it.

The purpose of data modeling is to document business rules about processes.

Business policies and rules govern all of the following EXCEPT:

In the figure shown below, which of the following is true?

It is not permissible to associate attributes with relationships.

An attribute whose values can be calculated from related attribute values is called a derived attribute.

An attribute of an entity that must have a value for each entity instance is a(n):

What is a derived attribute, and how is it different from a stored attribute?

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

A business rule is a statement of how a policy is enforced or conducted.