Homework 3

generalization

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

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

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.

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

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

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.

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.

Vehicle

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

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?

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.

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

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

Total Specialization

The following figure is an example of: A) partial specialization. B) completeness. C) total specialization. D) disjointness.

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.

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