Task 1: Due 27 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 Schedule

1. Build your company
  • Company Name
  • Company Logo
  • Mission Statement - Mission statement answers the question "Why does the company exisit"
  • Job Titles - Figure out who is doing what
    • Model Lead - In Charge of ERD
    • Presentation Lead - In Charge of Other Parts of Presentation
    • Communication Lead - In charge of communication with the shelter
2. Prepare for the interview
  • Research
  • Prepare a question list
  • Set goals
3. The Interview
  • Take notes
  • Ask for clarification
4. End Interview
  • Summarize key points
  • Thank You!
  • Follow Up
  • Review notes
  • Look for missing information

Task 2: Due 11/29

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 12/03 - Due 12/05

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

Task 4: Presentations 12/06

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:
•Cover Slide with company logo
•Mission statement & company member names and positions
•Statement of the Problem
•Statement of the Proposed Solution
•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.