Exam 4: Entity Relationship (ER)Modeling

In the Chen model,a multivalued attribute is connected to the owning entity with a double line.

The term "____" is used to label any condition in which one or more optional relationships exist.

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

The ____ type of attribute cannot be created in a DBMS.

____ attributes can have many values.

A ____ attribute can have only one value.

A weak entity must be ____________________-dependent.

The ER model refers to a specific table row as an entity instance.

Storing ____________________ attributes requires constant maintenance.

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

Identifying the attributes of the entities helps you better understand the ____________________ among entities.

All simple attributes are also single-valued.

A relationship ____________________ indicates the number of entities or participants associated with a relationship.

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

The ____ attribute(s)make up the primary key in the table definition: CLASS (CRS_CODE,CLASS_SECTION,CLASS_TIME,CLASS_ROOM,PROF_NUM)

In Crow's Foot notation,an optional relationship between entities is shown by drawing a(n)____________________ on the side of the optional entity.

An ERM is dependent on the database type.

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

A(n)____________________ relationship is also known as an identifying relationship.

Knowing the ____ number of entity occurrences is very helpful at the application software level.