DatabaseDatabase
Systems_
Database
Systems_
Design,Systems_
Implementation,
Design, Implementation,
Design,and
Implementation,
Management
and Management
and
– Chapter
Management
– 5Chapter
Review
– 5Chapter
Questions
Review5Questions
Review
_ Verified
Questions
_Questions
Verified_Questions
Verified
& Answers
Questions
& Answers.pdf
& Answers.pdf
Database Systems: Design, Implementation, and
Management – Chapter 5 Review Questions |
Verified Questions & Answers
Page 1 ofDatabase
8 Systems_ Design, Implementation, and Management – Chapter 5 Review Questions _ Verified Questions & Answers.pdf
Page 1 of 8
, Database Systems_ Design, Implementation, and Management_
Database Systems_
Chapter 5Design,
ReviewImplementation,
Questions and Management_
Database Systems_
Chapter 5Design,
ReviewImplementation,
Questions.pdf and Management_ Chapter 5 Review Questions.pdf
1. What is an entity supertype, and why is it used?
An entity supertype is a generic entity type that is related to one or more entity subtypes,
where the entity supertype contains the common characteristics and the entity subtypes
contain the unique characteristics of each entity subtype. The reason for using supertypes is
to minimize the number of nulls and to minimize the likelihood of redundant relationships.
2. What kinds of data would you store in an entity subtype?
An entity subtype is a more specific entity type that is related to an entity supertype, where
the entity supertype contains the common characteristics and the entity subtypes contain
the unique characteristics of each entity subtype. The entity subtype will store the data that
is specific to the entity; that is, attributes that are unique the subtype.
3. What is a specialization hierarchy?
A specialization hierarchy depicts the arrangement of higher-level entity supertypes (parent
entities) and lower-level entity subtypes (child entities)
Page 2 of 8 Database Systems_ Design, Implementation, and Management_ Chapter 5 Review Questions.pdf Page 2 of 8
Systems_
Database
Systems_
Design,Systems_
Implementation,
Design, Implementation,
Design,and
Implementation,
Management
and Management
and
– Chapter
Management
– 5Chapter
Review
– 5Chapter
Questions
Review5Questions
Review
_ Verified
Questions
_Questions
Verified_Questions
Verified
& Answers
Questions
& Answers.pdf
& Answers.pdf
Database Systems: Design, Implementation, and
Management – Chapter 5 Review Questions |
Verified Questions & Answers
Page 1 ofDatabase
8 Systems_ Design, Implementation, and Management – Chapter 5 Review Questions _ Verified Questions & Answers.pdf
Page 1 of 8
, Database Systems_ Design, Implementation, and Management_
Database Systems_
Chapter 5Design,
ReviewImplementation,
Questions and Management_
Database Systems_
Chapter 5Design,
ReviewImplementation,
Questions.pdf and Management_ Chapter 5 Review Questions.pdf
1. What is an entity supertype, and why is it used?
An entity supertype is a generic entity type that is related to one or more entity subtypes,
where the entity supertype contains the common characteristics and the entity subtypes
contain the unique characteristics of each entity subtype. The reason for using supertypes is
to minimize the number of nulls and to minimize the likelihood of redundant relationships.
2. What kinds of data would you store in an entity subtype?
An entity subtype is a more specific entity type that is related to an entity supertype, where
the entity supertype contains the common characteristics and the entity subtypes contain
the unique characteristics of each entity subtype. The entity subtype will store the data that
is specific to the entity; that is, attributes that are unique the subtype.
3. What is a specialization hierarchy?
A specialization hierarchy depicts the arrangement of higher-level entity supertypes (parent
entities) and lower-level entity subtypes (child entities)
Page 2 of 8 Database Systems_ Design, Implementation, and Management_ Chapter 5 Review Questions.pdf Page 2 of 8
