Database Fundamentals 4

Question 1

Weak (non-identifying) relationship

Answer 1

Exists if the PK of the related entity does not contain a PK component of the parent entity.

Question 2

ERD Development process

Answer 2

1. Create a detailed narrative of the organization’s description of operations.
2. Identify the business rules based on the description of operations.
3. Identify the main entities and relationships from the business rules.
4. Develop the initial ERD.
5. Identify the attributes and primary keys that adequately describe the entities.
6. Revise and review the ERD.