Exam 2: Modeling Data in the Organization

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

In the figure below, Name would be an ideal identifier.

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

Business policies and rules govern all of the following EXCEPT:

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

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

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

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

A value that indicates the date or time of a data value is called a:

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

A time stamp is a time value that is associated with a data value.

A mutually exclusive relationship is one in which:

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

An entity type whose existence depends on another entity type is called a ________ entity.

The most common types of entities are:

In an E-R diagram, there are/is ________ business rule(s) for every relationship.

What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

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

A ternary relationship is equivalent to three binary relationships.

A multivalued attribute may take on more than one value for a particular entity instance.