Exam 3: The Enhanced E-R Model and Business Rules

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype,it MUST simultaneously be a member of another subtype.

(True/False)

4.7/5

(34)

Question 21

Explain the terms subtype and supertype.Discuss the differences between them.

(Essay)

4.9/5

(38)

Question 22

A ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be a member of at least one subtype.

(Short Answer)

4.8/5

(27)

Question 23

When subtypes are overlapping,an additional field must be added to the supertype to act as a discriminator.

(True/False)

4.8/5

(35)

Question 24

An entity cluster can have a relationship with another entity cluster much the same way that an entity can have a relationship with another entity.

(True/False)

4.9/5

(45)

Question 25

Subtypes should be used when:

(Multiple Choice)

4.8/5

(34)

Question 26

The process of defining one or more subtypes of the supertype and forming supertype/subtype relationships is called ________.

(Short Answer)

4.8/5

(40)

Question 27

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.

(Multiple Choice)

4.9/5

(30)

Question 28

A generic data model is a good starting point for ________.

(Multiple Choice)

4.9/5

(43)

Question 29

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

(Multiple Choice)

4.8/5

(31)

Question 30

How is the data modeling process different when starting with a purchased solution?

(Essay)

4.9/5

(38)

Question 31

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

(Multiple Choice)

4.8/5

(36)

Question 32

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

(Multiple Choice)

4.8/5

(27)

Question 33

Supertype/Subtype relationships should be used when the instances of a subtype participate in no relationships which are unique to that subtype.

(True/False)

4.8/5

(36)

Question 34

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

(Multiple Choice)

4.9/5

(35)

Question 35

Explain what entity clustering is.

(Essay)

4.8/5

(34)

Question 36

The ________ rule specifies that an entity can be a member of only one subtype at a time.

(Multiple Choice)

4.7/5

(38)

Question 37

Packaged data models are as flexible as possible because all supertype/subtype relationships allow the total specialization and overlap rules.

(True/False)

4.9/5

(31)

Question 38

Which of the following is a completeness constraint?

(Multiple Choice)

4.8/5

(34)

Question 39

An entity cluster is:

(Multiple Choice)

4.9/5

(30)

Question 40

Showing 21 - 40 of 74

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype,it MUST simultaneously be a member of another subtype.

Explain the terms subtype and supertype.Discuss the differences between them.

A ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be a member of at least one subtype.

When subtypes are overlapping,an additional field must be added to the supertype to act as a discriminator.

An entity cluster can have a relationship with another entity cluster much the same way that an entity can have a relationship with another entity.

Subtypes should be used when:

The process of defining one or more subtypes of the supertype and forming supertype/subtype relationships is called ________.

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.

A generic data model is a good starting point for ________.

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

How is the data modeling process different when starting with a purchased solution?

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

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

Supertype/Subtype relationships should be used when the instances of a subtype participate in no relationships which are unique to that subtype.

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

Explain what entity clustering is.

The ________ rule specifies that an entity can be a member of only one subtype at a time.

Packaged data models are as flexible as possible because all supertype/subtype relationships allow the total specialization and overlap rules.

Which of the following is a completeness constraint?

An entity cluster is:

The Database Environment and Development Process

Modeling Data in the Organization

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters