Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please prepare a Level 0 DFD Background: The TITAN Veterinary Hospital is led by its CEO, Dr. Sue Grainger, along with her associate veterinarians. She
Please prepare a Level 0 DFD
Background: The TITAN 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 TITAN 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 TITAN 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 TITAN 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, TITAN Trust Bank. Finally, a monthly summary report of pet examinations and payments is generated for each month and forwarded to Dr. Grainger. Background: The TITAN 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 TITAN 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 TITAN 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 TITAN 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, TITAN Trust Bank. Finally, a monthly summary report of pet examinations and payments is generated for each month and forwarded to Dr. GraingerStep 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