Exam 5: Understanding Entity Relations

A(n)______________ relationship is indicated by a minimum cardinality of zero.

In a multiple level generalization hierarchy,the attributes of the supertype are inherited by all levels of the subtypes,either directly or indirectly.

-Which of the following entities does not inherit the primary key SS#?

When an entity cannot exist unless another related entity exists,this is known as __________________.

In a business situation where an employee can occupy only a single office and an office can only be occupied by one employee,this is an example of a(n)____________________ relationship.

By way of comparison to natural language,relationships can be said to correspond to nouns,and entity types can be said to correspond to verbs or prepositional phrases.

-The following qualifies as existence dependent:

Since a room does not have a separate identity from the building it is physically located in,in terms of an ERD it can be said that there is a(n)___________________ between the room and the building.

A relationship with a maximum cardinality of one in one direction and a maximum cardinality of more than one in the other direction is a(n)_____________ relationship.

-Any author in the database has written:

-If we want to add the relationship "First-published-in" between Book and Country,it would be:

A relationship that involves more than two entity types is called a(n)__________________ relationship.

A 1-M relationship cannot have any attributes.

One of the attributes an entity type should always have is a primary key.

In an identifying relationship,both of the participating entity types must be weak.

-Any book in the database has been written by: