Exam 2: Modeling Data in the Organization

While business rules are not redundant, a business rule can refer to another business rule.

A cardinality constraint tells what kinds of properties are associated with an entity.

The following figure shows an example of:

Some examples of attributes are: eye_color, weight, student_id, STUDENT.

A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.

Which of the following is NOT a good characteristic of a data name?

An attribute that can be broken down into smaller parts is called a(n) ________ attribute.

A fact is an association between two or more terms.

A fact is an association between two or more:

Data names should always relate to business characteristics.

What is the difference between an entity type and an entity instance?

An entity type on which a strong entity is dependent is called a covariant entity.

When choosing an identifier, choose one that will not change its value often.

One of the roles of a database analyst is to identify and understand rules that govern data.

An attribute that can be calculated from related attribute values is called a ________ attribute.

A property or characteristic of an entity type that is of interest to the organization is called a(n):

The relationship between a weak entity type and its owner is an identifying relationship.

The logical representation of an organization's data is called a(n):

In an E-R diagram, an associative entity is represented by a rounded rectangle.

An example of a term would be the following sentence: "A student registers for a course."