Question 1

Entity supertypes and subtypes are organized in a specialization hierarchy.

Accepted Answer

A) True 
 B)False  True

Question 2

____ keys work with primary keys to properly implement relationships in the relational model.

Accepted Answer

A)  Foreign 
B)  Composite 
C)  Natural 
D)  Surrogate 
A)  Foreign 
B)  Composite 
C)  Natural 
D)  Surrogate A

Question 3

Describe specialization and generalization.

Accepted Answer

Specialization is the top-down process of identifying lower-level,more specific entity subtypes from a higher-level entity supertype.Specialization is based on grouping the unique characteristics and relationships of the subtypes.In the aviation example,you used specialization to identify multiple entity subtypes from the original employee supertype.Generalization is the bottom-up process of identifying a higher-level,more generic entity supertype from lower-level entity subtypes.Generalization is based on grouping the common characteristics and relationships of the subtypes.For example,you might identify multiple types of musical instruments: piano,violin,and guitar.Using the generalization approach,you could identify a "string instrument" entity supertype to hold the common characteristics of the multiple subtypes.

Question 4

Explain the "no change over time" characteristic of a good primary key.

Accepted Answer

If an attribute has semantic meaning,it

Question 5

At the implementation level,the supertype and its subtype(s)depicted in the specialization hierarchy maintain a ____ 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 6

The _________________________ is the result of adding more semantic constructs to the original entity relationship (ER)model.

Accepted Answer

extended entity rela

Question 7

Generalization is based on grouping unique characteristics and relationships of the subtypes.

Accepted Answer

A) True 
 B)False

Question 8

Composite keys are useful as identifiers of weak entities,where the weak entity has a strong ____________________ relationship with the parent entity.

Accepted Answer

The answer of Composite keys are useful as identifiers of...

Question 9

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 10

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 11

An entity supertype can have disjoint or overlapping entity subtypes.

Accepted Answer

A) True 
 B)False

Question 12

A specialization hierarchy can have ____ level(s)of supertype/subtype relationships.

Accepted Answer

A)  zero 
B)  only one 
C)  one or many 
D)  many 
A)  zero 
B)  only one 
C)  one or many 
D)  many

Question 13

Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.

Accepted Answer

A) True 
 B)False

Question 14

Some designs use redundant relationships as a way to simplify the design.

Accepted Answer

A) True 
 B)False

Question 15

A design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.

Accepted Answer

A) True 
 B)False

Question 16

The extended entity relationship model (EERM)is sometimes referred to as the ____.

Accepted Answer

A)  entity relationship model 
B)  enhanced entity relationship model 
C)  entity clustering relationship model 
D)  extended entity relationship diagram 
A)  entity relationship model 
B)  enhanced entity relationship model 
C)  entity clustering relationship model 
D)  extended entity relationship diagram

Question 17

One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.

Accepted Answer

A)  primary 
B)  natural 
C)  foreign 
D)  surrogate 
A)  primary 
B)  natural 
C)  foreign 
D)  surrogate

Question 18

What is an entity cluster?

Accepted Answer

An entity cluster is a "virtual" entity

Question 19

What do specialization hierarchies do?

Accepted Answer

Entity supertypes and subtypes are organ

Question 20

In specialization hierarchies with multiple levels of supertype/subtypes,a lower-level supertype inherits all of the attributes and relationships from all of its upper-level subtypes.

Accepted Answer

A) True 
 B)False

Entity supertypes and subtypes are organized in a specialization hierarchy.

____ keys work with primary keys to properly implement relationships in the relational model.

Describe specialization and generalization.

Explain the "no change over time" characteristic of a good primary key.

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

The _________________________ is the result of adding more semantic constructs to the original entity relationship (ER)model.

Generalization is based on grouping unique characteristics and relationships of the subtypes.

Composite keys are useful as identifiers of weak entities,where the weak entity has a strong ____________________ relationship with the parent entity.

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

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

An entity supertype can have disjoint or overlapping entity subtypes.

A specialization hierarchy can have ____ level(s)of supertype/subtype relationships.

Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.

Some designs use redundant relationships as a way to simplify the design.

A design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.

The extended entity relationship model (EERM)is sometimes referred to as the ____.

One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.

What is an entity cluster?

What do specialization hierarchies do?

In specialization hierarchies with multiple levels of supertype/subtypes,a lower-level supertype inherits all of the attributes and relationships from all of its upper-level subtypes.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 5: Advanced Data Modeling

Entity supertypes and subtypes are organized in a specialization hierarchy.

____ keys work with primary keys to properly implement relationships in the relational model.

Describe specialization and generalization.

Explain the "no change over time" characteristic of a good primary key.

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

The _________________________ is the result of adding more semantic constructs to the original entity relationship (ER)model.

Generalization is based on grouping unique characteristics and relationships of the subtypes.

Composite keys are useful as identifiers of weak entities,where the weak entity has a strong ____________________ relationship with the parent entity.

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

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

An entity supertype can have disjoint or overlapping entity subtypes.

A specialization hierarchy can have ____ level(s)of supertype/subtype relationships.

Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.

Some designs use redundant relationships as a way to simplify the design.

A design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.

The extended entity relationship model (EERM)is sometimes referred to as the ____.

One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.

What is an entity cluster?

What do specialization hierarchies do?

In specialization hierarchies with multiple levels of supertype/subtypes,a lower-level supertype inherits all of the attributes and relationships from all of its upper-level subtypes.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters