Exam 7: Data Modeling With Entity Relationship Diagrams

In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line.

The ERM forms the basis of a(n) ___________________________________.

The Crow's Foot model is more ____________________-oriented than the Chen model.

Attributes have a domain that specifies the data type of the attribute.

The associative entity is also known as a ____ entity.

All attributes are either simple or composite.

Although the conceptual model can handle ____ relationhips and multivalued attribues, you should not implement them in the RDBMS.

The Crow's foot symbol with two parallel lines indicates ____ cardinality.

When the PK of one entity does not contain the PK of a related entity, the relationship is ____.

If an entity can exist apart from one or more related entities, it is said to be ____-independent.

Explain the difference between simple and composite attributes. Provide at least one example of each.

You should always load data from the 1 side of a 1:M relationship.

A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

____ relationships are most common.

What is a ternary relationship? Provide some example business rules that specify the need for a ternary or higher-order relationship.

Failure to understand the distinction between mandatory and optional ____________________ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.

The ER diagram represents the conceptual database as viewed by the end user.

A recursive relationship is one in which a relationship can exist between occurrences of the same entity set

The M:N relationship between STUDENT and CLASS must be divided into two 1:M relationships through the use of the ENROLL entity; the ENROLL entity is ____.

The DBMS can easily handle multivalued attributes.