Question 1

At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a(n) ____ relationship.

Accepted Answer

A)  self-referencing 
B)  1:1 
C)  1:M 
D)  M:N 
A)  self-referencing 
B)  1:1 
C)  1:M 
D)  M:N

Question 2

____ data refer to data whose values change over time and for which you must keep a history of the data changes.

Accepted Answer

A)  Time-sensitive 
B)  Time-variant 
C)  Historical 
D)  Change-based 
A)  Time-sensitive 
B)  Time-variant 
C)  Historical 
D)  Change-based

Question 3

Entity subtypes do not inherit the relationships in which the supertype entity participates.

Accepted Answer

A) True 
 B)False

Question 4

The default comparison condition for the subtype discriminator attribute is the ____ comparison.

Accepted Answer

A)  not equality 
B)  less than 
C)  greater than 
D)  equality 
A)  not equality 
B)  less than 
C)  greater than 
D)  equality

Question 5

An entity cluster is considered "virtual" or "____________________" in the sense that it is not actually an entity in the final ERD.

Accepted Answer

The answer of An entity cluster is considered "virtual" or...

Question 6

Implementing non-overlapping subtypes requires the use of one discriminator attribute for each subtype.

Accepted Answer

A) True 
 B)False

Question 7

Disjoint subtypes are also known as ____________________ subtypes.

Accepted Answer

non-overla

Question 8

A(n) ____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.

Accepted Answer

A)  subtype discriminator 
B)  inheritance discriminator 
C)  specialization hierarchy 
D)  entity supertype 
A)  subtype discriminator 
B)  inheritance discriminator 
C)  specialization hierarchy 
D)  entity supertype

Question 9

Within a specialization hierarchy, a supertype can exist only within the context of a subtype.

Accepted Answer

A) True 
 B)False

Question 10

Describe specialization and generalization.

Accepted Answer

Specialization is the top-down process o

At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a(n) ____ relationship.

____ data refer to data whose values change over time and for which you must keep a history of the data changes.

Entity subtypes do not inherit the relationships in which the supertype entity participates.

The default comparison condition for the subtype discriminator attribute is the ____ comparison.

An entity cluster is considered "virtual" or "____________________" in the sense that it is not actually an entity in the final ERD.

Implementing non-overlapping subtypes requires the use of one discriminator attribute for each subtype.

Disjoint subtypes are also known as ____________________ subtypes.

A(n) ____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.

Within a specialization hierarchy, a supertype can exist only within the context of a subtype.

Describe specialization and generalization.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 8: Data Modeling Advanced Concepts

At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a(n) ____ relationship.

____ data refer to data whose values change over time and for which you must keep a history of the data changes.

Entity subtypes do not inherit the relationships in which the supertype entity participates.

The default comparison condition for the subtype discriminator attribute is the ____ comparison.

An entity cluster is considered "virtual" or "____________________" in the sense that it is not actually an entity in the final ERD.

Implementing non-overlapping subtypes requires the use of one discriminator attribute for each subtype.

Disjoint subtypes are also known as ____________________ subtypes.

A(n) ____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.

Within a specialization hierarchy, a supertype can exist only within the context of a subtype.

Describe specialization and generalization.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters