Database Management Extra 8

Question 1

One or more attributes that uniquely identify each entity instance.

Answer 1

Identifiers

Question 2

A relationship in which the primary key of the related entity does not contain a primary key component of the parent entity.

Answer 2

Non-Identifying Relationship

Question 3

In ER modeling, a condition in which one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

Answer 3

Optional Participation

Question 4

An ER term for entities that participate in a relationship. For example, in the relationship “PROFESSOR teaches CLASS,” the teaches relationship is based on the participants PROFESSOR and CLASS.

Answer 4

Participants

Question 5

A relationship found within a single entity type. For example, an EMPLOYEE is married to an EMPLOYEE or a PART is a component of another PART.

Answer 5

Recursive Relationship

Question 6

The organization of a relational database as described by the database administrator.

Answer 6

Relational Schema

Question 7

The number of entities or participants associated with a relationship. A ??? ??? can be unary, binary, ternary, or higher.

Answer 7

Relationship Degree

Question 8

An attribute that cannot be subdivided into meaningful components.

Answer 8

Simple Attribute

Question 9

A relationship that occurs when two entities are existence-dependent; from a database design perspective, this relationship exists whenever the primary key of the related entity contains the primary key of the parent entity.

Answer 9

Strong (Identifying) Relationship

Question 10

An entity that is existence-independent, that is, it can exist apart from all of its related entities. Also called a regular entity.

Answer 10

Strong Entity