CIS178: Chapter 5 Quiz

An entity cluster is formed by combining multiple interrelated entities into _____.

a single abstract entity object

A primary key's main function is to uniquely identify a(n) _____ within a table.

entity instance or row

The default comparison condition for the subtype discriminator attribute is the _____ comparison.

equality

A _____ key is a real-world, generally accepted identifier used to uniquely identify real-world objects.

natural

In the context of total completeness, in a(n) _____, every supertype occurrence is a member of at least one subtype.

overlapping constraint

The preferred placement for a foreign key when working with a 1:1 relationship is to _____.

place the foreign key in one of the entities

One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their supertype.

primary

The "_____" characteristic of a primary key states that the selected primary key must not be composed of any attribute(s) that might be considered a violation.

security-compliant

A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.

subtype discriminator

A _____ is a primary key created by a database designer to simplify the identification of entity instances.

surrogate key