AIS Project Fall 2018 The Mesa Veterinary Hospital is run by Dr. Brigitte Roosevelt. She has two employees in the office and has asked you to develop a database to help better track her data. Dr. Roosevelt currently uses her personal computer only for word processing, but she is interested in also using it to maintain pet histories and accounting information. She is excited about the transition and is counting on you to help her through the process. She describes her daily activities as follows: When new customers come to Mesa Veterinary Hospital, the "owners" of the pets are required to complete an introductory form. This form includes the following: Owner name Address Day phone Night phone They are also required to provide the following information about each pet, as some people own many pets: Pet name Breed Color . Birth date Dr. Roosevelt would like to enter this information once and then have the system retrieve it for all subsequent visits When customers call to make appointments, one of the office clerks asks what kind of services they require (e.g., is it a routine exam, a surgery, etc.). Dr. Roosevelt sees only one pet during each appointment. If she is going to see one owner's two pets, then two separate appointments are necessary (but scheduled back-to-back). For each appointment, Dr. Roosevelt records the pet's weight, notes the reason for the appointment, and records her diagnosis. Depending on the diagnosis, the doctor will possibly prescribe any number of medications to cure the pet. Owners are charged $25 for each appointment and must pay additionally for any medications prescribed for their pets. Dr. Roosevelt requires all pets to be brought back for another examination prior to refilling any prescriptions. Customers must pay for services and medication in full at the conclusion of their visits. Dr. Roosevelt concludes the interview by requesting that in addition to the facts mentioned, she wants the system to provide two reports: 1) a report on the customer visits with Total charge for appointments and 2) a report on drugs sold prescription price and total sales by drugs AIS Project Fall 2018 The Mesa Veterinary Hospital is run by Dr. Brigitte Roosevelt. She has two employees in the office and has asked you to develop a database to help better track her data. Dr. Roosevelt currently uses her personal computer only for word processing, but she is interested in also using it to maintain pet histories and accounting information. She is excited about the transition and is counting on you to help her through the process. She describes her daily activities as follows: When new customers come to Mesa Veterinary Hospital, the "owners" of the pets are required to complete an introductory form. This form includes the following: Owner name Address Day phone Night phone They are also required to provide the following information about each pet, as some people own many pets: Pet name Breed Color . Birth date Dr. Roosevelt would like to enter this information once and then have the system retrieve it for all subsequent visits When customers call to make appointments, one of the office clerks asks what kind of services they require (e.g., is it a routine exam, a surgery, etc.). Dr. Roosevelt sees only one pet during each appointment. If she is going to see one owner's two pets, then two separate appointments are necessary (but scheduled back-to-back). For each appointment, Dr. Roosevelt records the pet's weight, notes the reason for the appointment, and records her diagnosis. Depending on the diagnosis, the doctor will possibly prescribe any number of medications to cure the pet. Owners are charged $25 for each appointment and must pay additionally for any medications prescribed for their pets. Dr. Roosevelt requires all pets to be brought back for another examination prior to refilling any prescriptions. Customers must pay for services and medication in full at the conclusion of their visits. Dr. Roosevelt concludes the interview by requesting that in addition to the facts mentioned, she wants the system to provide two reports: 1) a report on the customer visits with Total charge for appointments and 2) a report on drugs sold prescription price and total sales by drugs
