Exam 4: Entity Relationship (ER)Modeling

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

The Crow's Foot notation depicts the strong relationship with a(n)____________________ line between the entities.

Participation is ____________________ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

A ____ should be a derived attribute.

Ideally,a primary key is composed of several attributes.

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

All simple attributes are also single-valued.

A derived attribute ____.

The word "entity" in the ER model corresponds to a table.

The existence of a(n)____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.

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

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

An attribute representing one or more college degrees belonging to a person would be a(n)____________________ attribute.

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

A ____ relationship exists when an association is maintained within a single entity.

Attributes do not have a domain.

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

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

Explain multivalued attributes,and provide an example.How are multivalued attributes indicated in the Chen model? How are they indicated in the Crow's Foot model?

The DBMS can easily handle multivalued attributes.