Question
A Veterinary Hospital is led by its CEO, Dr. Sue Grainger, along with her associate veterinarians. She oversees a team of five employees and has
A Veterinary Hospital is led by its CEO, Dr. Sue Grainger, along with her associate veterinarians. She oversees a team of five employees and has approached you to develop a database to improve data tracking. Dr. Grainger currently uses her personal computer solely for word processing but she is keen to expand its functionality to manage pet histories and accounting information. She is enthusiastic about this transition and is relying on your assistance throughout the process. She outlines her daily activities as follows: When a customer calls to make appointments, one of the office clerks completes an appointment form. The form includes the appointment number, pet parent identification number, pet identification number, appointment date, and the services they require (e.g., routine exam, vaccination, surgery, etc.), along with any special needs for each service. If the customer is a new customer, the parents of the pets (hereafter referred to as pet parents) are required to fill out a customer form. This customer form includes parent identification number, parent name, address, day phone, night phone, and email. They are also required to provide information about each pet, as some people own multiple pets: pet identification number, pet name, breed, color, and birth date. Additionally, after the appointment process is completed, an appointment confirmation is generated and sent to the pet parents. Each pet parent can schedule multiple appointments if they have more than one pet. However, a separate appointment should be made for each pet. Also, an appointment can be made for more than one service. The TITAN Veterinary Hospital allows its veterinarians to examine only one pet during each appointment. Therefore, if the parent has more than one pet, a separate examination is necessary for each pet. When pet parents and their pets visit the Veterinary Hospital on their appointment day, the medical records of the pets (i.e., service history) are provided to an associate veterinarian. The veterinarian then examines each pet and, based on the diagnosis, prescribes any necessary medications for the pet. Additionally, the veterinarian fills out a pet examination form. This form includes the exam number, weight, height, heartbeat, temperature, symptom, actual time spent for each service (in hours), diagnosis results of each service, and the quantity of each medication, if prescribed. At the end of each week, an accounting clerk prepares invoices for pet parents who visited the Veterinary Hospital during the week and sends the invoices to them. Pet parents are charged $30 for each appointment and must also pay for any medications prescribed for their pets. The Veterinary Hospital mandates that all pets must return for another examination before any prescriptions can be refilled. Pet parents have a 30-day window to pay for each examination, but they are required to pay in full for each examination. Moreover, pet parents have the option to combine payment for multiple examinations into a single payment. When a payment is received, an accounting clerk prepares a payment receipt form for the amount received from each pet parent by verifying the appointment form, pet examination form, and invoice. The form includes a receipt number, receipt date, and the amount received. The form is then sent to Dr. Grainger for authorization. Once Dr. Grainger approves the payment receipt form, the accounting clerk deposits the checks into a bank, Trust Bank. Finally, a monthly summary report of pet examinations and payments is generated for each month and forwarded to Dr. Grainger. DRAW the context diagram and the level 0 DFD. Add descriptions to each input/output arrow Hints: There are approximately four sources/destinations (Pet Parent, Associate Veterinarian, Dr. Grainger, and Trust Bank), four processes (Receive Appointment, Examine Pet, Receive Payment, and Generate Report), and five data stores (i.e., Pet Parent, Pet, Appointment, Service, and Cash)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started