Database Systems – Design, Implementation, and Management – Chapter 4 Review Questions – Verified

DatabaseDatabase
Systems_
Database
Systems_
Design,Systems_
Implementation,
Design, Implementation,
Design,and
Implementation,
Management
and Management
and
– Chapter
Management
– 4Chapter
Review
– 4Chapter
Questions
Review4Questions
Review
_ Verified
Questions
_Questions
Verified_Questions
Verified
& Answers
Questions
& Answers.pdf
& Answers.pdf




Database Systems: Design, Implementation, and
Management – Chapter 4 Review Questions |
Verified Questions & Answers




Page 1 ofDatabase
8 Systems_ Design, Implementation, and Management – Chapter 4 Review Questions _ Verified Questions & Answers.pdf
Page 1 of 8

, Database Systems_ Design, Implementation, and Management_
Database Systems_
Chapter 4Design,
ReviewImplementation,
Questions and Management_
Database Systems_
Chapter 4Design,
ReviewImplementation,
Questions.pdf and Management_ Chapter 4 Review Questions.pdf




1. What two conditions must be met before an entity can be classified as a weak entity? Give
an example of a weak entity.


The entity must be existence-dependent on its parent entity and it must inherit at least part
of its primary key from its parent entity.


2. What is a strong (or identifying) relationship, and how is it depicted in a Crow's Foot ERD?


A strong relationship is when an entity is existence-dependent on another entity and inherits
at least part of its primary key from that entity.


4. What is a composite entity, and when is it used?


A composite entity is generally used to transform M:N relationships into 1:M relationships. A
composite entity, also known as a bridge entity, is one that has a primary key composed of
multiple attributes. The PK attributes are inherited from the entities that it relates to one
another.



Page 2 of 8 Database Systems_ Design, Implementation, and Management_ Chapter 4 Review Questions.pdf Page 2 of 8