This is symbolized by a circle over a single line in an entity relationship diagram. It signifies that the supertype does NOT have to be one of the specified subtypes.

Partial completeness

Total completeness

System completeness

Associative completeness

A supertype entity can contain as many as ____ subtype entities.

10

1

100

no defined limit

When you set up an Entity Relationship Diagram, and have a many-to-many relationship, this entity is created to avoid problems inherent to a many-to-many relationship.

Relational entity

Composite entity

Index entity

Foreign entity

You would this as a primary key when you don't have an attribute that makes sense or is a good choice for a primary key.

Surrogate

Automatic

Candidate

Composite

Also known as bridge entities, these entities are used to implement M:N relationships and are composed of primary keys of each of the entities to be connected.

Distinct

Relationship

Associative

Primary

You are designing an ERD for a local hospital to redo their database. You have identified a number of entities that you think could be subtypes. From these subtypes you need to create a supertype that will connect these subtypes. What is this type of process called?

Disassociation

Association

Generalization

Specialization