Exam 5: Advanced Data Modeling

Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed in the M:N relationship.

Overlapping subtypes are subtypes that contain subsets of the supertype entity set.

Subtypes that contain nonunique subsets of the supertype entity set are known as subtypes.

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

Overlapping subtypes are subtypes that contain a unique subset of the supertype entity set.