Question
When a new customer comes to the Animal Hospital, the parents of the pets are required to complete an introductory form that includes the following:
When a new customer comes to the Animal Hospital, the parents of the pets are required to complete an introductory form that includes the following:
- Parent name
- Address
- Day phone
- Evening phone
The parents are also required to provide the following information about each pet (Note: some people own many pets!):
- Pet name
- Breed
- Color
- Birth date
The introductory information is to be stored so parents do not have to provide the same information each time a pet has an appointment.
The doctors see only one pet during each appointment. For example, if Dr. Waikato is going to see Emilys two cats, then two appointments are established. For each appointment, the pets weight, the reason for the appointment, and the doctors diagnosis is recorded. Depending on the diagnosis, the doctor may prescribe any number of medicines to cure the pet. Parents are charged for each appointment and must pay additionally for medicines.
During your interviews, the following attributes were also identified as being necessary for the system:
- Number of pets owned by each parent
- Price of each specific medicine prescribed
- Total charge for the appointment
- Quantity of each specific medicine prescribed
- Prescription price
- Medication list price
- Medicine name
- Total cash receipt amount
- Appointment date
- Cash receipt amount applied to a specific appointment
- Appointment length
Can you please draw an REA diagram which contains all of this information
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