Can you help me with this worksheet?
Based on the following business description, prepare a REA in the ER diagram format. Be sure to include all relevant entities, relationships, minimum and maximum cardinalities. Note: this problem involves the revenue cycle. For simplicity, you don't need to model taking appointment process. (9 point Super Cy Veterinary Hospital The Super Cy Veterinary Hospital is run by Dr. Brigitte Roosevelt and her associate veterinarian Dr. Cy Clone. 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 Super Cy Veterinary Hospital, the "parents" of the pets are required to complete an introductory form. This form includes the followin Parent 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 (i.e., is it a routine exam, a surgery, etc.). Each veterinarian sees only one pet during each appointment. If the veterinarian is going to see one parent's two pets, then two separate appointments are necessary (but scheduled back-to-back). Also, only one veterinarian is scheduled for each appointment. For each appointment, the veterinarian 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. Parents are charged $35 for each appointment, and must pay additionally for any medications prescribed for their pets. The clinic's policy is to require all Based on the following business description, prepare a REA in the ER diagram format. Be sure to include all relevant entities, relationships, minimum and maximum cardinalities. Note: this problem involves the revenue cycle. For simplicity, you don't need to model taking appointment process. (9 point Super Cy Veterinary Hospital The Super Cy Veterinary Hospital is run by Dr. Brigitte Roosevelt and her associate veterinarian Dr. Cy Clone. 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 Super Cy Veterinary Hospital, the "parents" of the pets are required to complete an introductory form. This form includes the followin Parent 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 (i.e., is it a routine exam, a surgery, etc.). Each veterinarian sees only one pet during each appointment. If the veterinarian is going to see one parent's two pets, then two separate appointments are necessary (but scheduled back-to-back). Also, only one veterinarian is scheduled for each appointment. For each appointment, the veterinarian 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. Parents are charged $35 for each appointment, and must pay additionally for any medications prescribed for their pets. The clinic's policy is to require all
