You your company has been chosen by Lollipop Farm to bid for the Date Model for their new animal shelter database. This animal shelter has been in existence since 1977. You will have the opportunity to meet with the director, and present your final solution. Here is the animal shelter's logo if you would like to include it

Lollipop Farm Logo

Task 1: Due 10 Nov

Your group will play the role of the consulting company. Your teacher will act as the director of a city animal shelter who needs a database.

Interview Letter

1. Build your company
  • a.Company Name
  • b.Company Logo
  • c.Mission Statement & Description
  • d.create positions for each of you
2. Prepare for the interview
  • a. Prepare a question list
  • b. Set goals
  • c. Determine and gather materials needed
3. The Interview
  • a. Take notes
  • b. Ask for clarification
4. End Interview
  • a. Summarize key points
  • b. Thank You!
  • 4. Follow Up
  • a. Review notes
  • b. Look for missing information

Check out the following links for examples of real animal shelter websites. - PetsLifeLine Sonoma Valley, CA Animal Care and Control of New York City Godmanchester, Cambs in the UK

Task 2: Due Nov 14

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/19 - Due 11/21

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

Task 4: Due 11/25

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.