Which of the following is a generic entity type that has a relationship with one or more subtypes quizlet?

Attribute inheritance

The property by which subtype entities possess the values of all attributes of a supertype is called
A)

class management.

B)

generalization.

C)

hierarchy reception.

D)

attribute inheritance.

Supertype

Which of the following is a generic entity type that has a relationship with one or more subtypes
A.
Megatype

B.
Supertype

C.
Subgroup

D.
Class

there are attributes that apply to some but not all instances of an entity type.

Subtypes should be used when:
A)

the instances of a subtype do not participate in a relationship that is unique to that subtype.

B)

supertypes relate to objects outside the business.

C)

there are attributes that apply to some but not all instances of an entity type.

D)

a recursive relationship is needed.

Patient_Name

In the figure below, which of the following apply to both OUTPATIENTs and RESIDENT_PATIENTs?
A)

Checkback_Date

B)

XML

C)

Date_Discharged

D)

Patient_Name

Outpatient

In the figure below, which of the following is a subtype of patient?

specialization

The process of defining one or more subtypes of a supertype and forming relationships is called:
A)

generalization.

B)

specialization.

C)

selecting classes.

D)

creating discord.

Vehicle

In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized?

generalization

The process of defining a more general entity type from a set of more specialized entity types is called:

Total Specialization

The following figure is an example of:

A)

partial specialization.

B)

completeness.

C)

total specialization.

D)

disjointness.

Partial Specialization

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.

A)

disjointedness

B)

total specialization

C)

partial specialization

D)

semi-specialization

B)

must be a graduate student, an undergraduate, a special student or some other type of student.

In the figure below, a student:

A)

must be a doctoral student.

B)

must be a graduate student, an undergraduate, a special student or some other type of student.

C)

must be at least a special student.

D)

must be a graduate student or an undergraduate student.

overlap

The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.
Question options:

A)

partial specialization

B)

disjoint

C)

total specialization

D)

overlap

An entity cluster is:
Question options:

A)

a way of developing more granular views of the data model.

B)

a useful way to present data for a small and fairly simple organization.

C)

a set of one or more entity types and associated relationships grouped into a single abstract entity type.

D)

a formal method for specifying attributes of related entities.

C)

a set of one or more entity types and associated relationships grouped into a single abstract entity type.

Packaged data models:
Question options:

A)

are ready to use right out of the box.

B)

cannot be used for most applications.

C)

require customization.

D)

allow partial specialization.

C)

require customization.

A generic or template data model that can be reused as a starting point for a data modeling project is called a(n):
Question options:

A)

enterprise data model.

B)

collection data model.

C)

universal data model.

D)

packaged data model.

C)

universal data model.

In packaged data models, all subtype/supertype relationships follow the ________ and ________ rules.
Question options:

A)

partial specialization; disjoint

B)

total specialization; overlap

C)

partial specialization; overlap

D)

total specialization; disjoint

B)

total specialization; overlap

In packaged data models, strong entities always have ________ between them.
Question options:

A)

1:1 relationships

B)

M:N relationships

C)

weak entities

D)

1:M relationships

B)

M:N relationships

B)

subtype discriminator.

An attribute of the supertype that determines the target subtype(s) is called the:
Question options:

A)

subtype decision.

B)

subtype discriminator.

C)

determinant.

D)

disjoint indicator.

The following figure shows a:

A)

spindle constraint.

B)

supertype/subtype hierarchy.

C)

completeness constraint.

D)

disjoint constraint.

https://learn.uco.edu/content/enforced/206675-10134.201910/chapter%203%20quiz%2012e/f1q15g1.jpg?_&d2lSessionVal=344FsgBXaounzQMlTPnyW1Kig

Which of the following is a generic entity type that has a relationship with one or more subtypes?

A supertype is a generic entity type that has a relationship with one or more subtypes. A subtype is a sub-grouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroups.

What rule specifies that an entity can be a member of only one subtype at a time?

Disjoint rule. Specifies that if an entity instance (of the supertype) is a member of one subtype, it cannot simultaneously be a member of two (or more) subtypes. Overlap rule. Specifies that an entity instance can simultaneously be a member of two (or more) subtypes.

Is the process of defining a more general entity type from a set of more specialized entity types?

Generalization is the process of defining more general entity types from a set of more specialized entity types.

Is a relationship involving the same entity type?

A relationship involving the same entity type. Self referencing relationships represent associations among members of the same set. A weak entity that depends on two or more entity types for its primary key. An associative entity type with more than two identifying relationships is known as an M-way associative type.