CS360: Lab 5

---

Due: See Moodle for the due date.

Goals:

• Practice creating data models using the Entity Relationship Diagramming technique

Requirements:

1. Answer the following questions from the text.  Use the Pete’s foot notation described in ..\notes\ERDIntro.html. For each problem:

1. Write a Pete's foot diagram describing all relationships.

2. Underneath each relationship in the diagram, write a sentence explaining your rationale for choosing the min and max cardinalities for that relationship.

3. Below the relationships diagram, show the attributes for each entity that has attributes and the PK and FK constraints. For example:

PROPERTY

· PropertyID, PK

· PropertyName

· Street

· City

· State

· Zip

· OwnerID, FK to OWNER.OwnerID

Notes:

· In problem A, consider each relation shown in the Garden Glory schema from chapter 3 to represent an entity and its attributes, e.g., one entity is OWNER with attributes: OwnerID, OwnerName, OwnerEmail, OwnerType. The relationships are then prescribed by the relation definitions. So, in part A, there are no choices for the cardinalities. Use what you know about primary and foreign keys to figure out what the cardinalities are.

· In part B you have some choices.

· Many to many relationships form new weak entities, which you can give names, and these new entities may have attributes.

· Do NOT build tables in mysql workbench then generate the ERD from your tables until you have first written Pete’s foot

P. 251, Garden Glory Project Questions A and B.  Here is the text for these questions:

Here is the Garden Glory schema from chapter 3:

· BUG FIX: In problem A below, the Service relation should read:

SERVICE(PropertyID, EmployeeID, ServiceDate, HoursWorked)

2. Submit your assignment on moodle by clicking on the Lab 5 assignment.