Exam 5: Data Modeling With the Entity-Relationship Model

One example of a database design using a strong relationship is the multivalued attribute pattern.

Attributes may be ________.

Relationships of degree two are referred to as binary relationships.

In a 1:N relationship,the term parent refers to the N side of the relationship.

A compound identifier is an identifier consisting of two or more attributes.

An entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity is a(n)________.

An attribute that determines which subtype is appropriate is called a discriminator.

Data modelers agree that weak,non-ID-dependent entities exist and are important.

In an E-R model,the three types of maximum cardinality are 1:1,1:N,and N:M.

When an entity has a relationship to itself,we have a(n)________.

One example of a database design using an ID-dependent relationship is the association pattern.

All weak entities must have a minimum cardinality of 1 on the entity on which it depends.

An ID-dependent entity is an entity whose identifier includes the identifier of another entity.

Entities can be associated with one another in relationships.

Subtypes can be exclusive or inclusive.

Supertype/subtype entities are said to have a(n)________ relationship.

An entity whose identifier includes the identifier of another entity is a(n)________.

You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above,and are asked to draw the relationship between them.If a given customer can place many orders and a given order can be placed by one or more customers,which of the following should be indicated in the relationship symbol between the two entities?

Which of the following is considered to be a weak entity?

An occurrence of a particular entity is called an ________.