Task 2: Due 11/19

Structural business rules indicate the types of information to be stored and how the information elements are interrelated. Example: Each animal must have a unique identification number.

Process rules are related to workflow or business process. Example: Each animal must undergo a medical examination when it arrives at the shelter.

Using notes taken from the interview with the director of the animal shelter (previous lesson), work in your respective groups to construct the business rules. Document at least two structural rules and two procedural rules.

If you make assumptions, document them as well. You can confirm or clarify them with the director in a follow-up phone call. If there is time, begin to identify entities, attributes, and relationships.

Task 3: Check In 11/21 - Due 11/26

Create your ERD . I will be meeting with your group as a teacher to discuss your progress on 11/21. The final interview with the client will be on 11/26. This is your chance to get things cleaned up and ask your final quesions.

Task 4: Due 12/2

Present your projects to the class. You are expected to dress business casula (no sneakers, no jeans, no t-shirts).

Create a Presentation for the Animal Shelter Director. Organize your presentation. Each presentation must contain 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

Your teacher will decide how much time you have to present to the “client.” Remember: This is a “meeting” between the client and your consulting company. You will present your ERD to the “director.” The ERD should serve as a communication tool, along with the business rules, to show the client that you understand their needs and that these needs are being met by the design. If a time limit is set for the meetings, be careful not to allow additional questioning after it is over.