Section 9 Lesson 3

Activity: Creating the Animal Shelter ERD and Presentations

 

Go through your interview notes and business rules. Look for words and phrases that suggest CRUD (we want to track data…, we need to enter data…, etc.). Is there an entity or attribute or relationship that allows them to do this?

 

Go through each entity. Look for notes or a business rule that points to a create, retrieve, or update business function.

 

Hint: All entities need to have a create and retrieve function. This means that you need to have interview notes or a business rule that points to entering data in the entity and viewing the data once it’s in the database.

 

Use the worksheet below. An example has already been created for you.

 

 

 

Entity	Interview Notes or Business Rules	CRUD Function?
Animal	When an animal comes into the shelter, we assign it an id and collect information   We need to track animals in our shelters	Create       Retrieve
Entity Name	Interview notes – business rule

 

Preparing for the Presentationto the Animal Shelter Director

Organize your presentation. Each group must prepare the following:

- Statement of the Problem

- Statement of the Proposed Solution

- The information requirements of the business/organization clearly stated (you should have this from your interview notes)

- The business rules as they apply to the information requirements of the company/organization stated as single sentences (you should have this from the previous lesson)

- The assumptions and constraints that had to be considered clearly stated (you should have this from the previous lesson)

- Entity relationship model