anc Based on Week /- The Mesa Veterinary Hospital is a sole proprietorship run by Brigitte Roosevelt. She has no employees and has asked you to develop a database to help her better track her data. Dr Roosevelt currently has a personal computer but has only used it for word processing. She is interested in also using it to maintain pet histories and accounting information. While she has high hopes, she is counting on you to help her through this change. She describes her daily activities as follows: When new customers come to Mesa veterinary hospital, the parents of the pets are required to complete an introductory form. This form includes the following: Parent name Address Day phone Night phone They are also required to provide information about each pet. (Note: Some people own many pets) Pet name Breed Colour Birth date . . . Dr. Roosevelt would like to enter this information once, and then have the system retrieve it for all subsequent visits. Dr. Roosevelt sees only one per during each appointment, if she is going to see one parent's two pets, two separate appointments are set up (but scheduled back-to- back). For each appointment, the Pet's weight is recorded, the reason for the appointment is noted, and the doctor's diagnosis recorded. Depending on the diagnosis, the doctor will possibly prescribe any number of prescriptions to cure the pet. Parents are charged $25 for each appointment, and must pay additionally for any prescriptions needed. Dr. Roosevelt concludes the interview by requesting that in addition to the aforementioned facts, she wants the system to also store the following attributes: Number of pets owned by each parent Total charge for the appointment . Prescription Price Drug name Length of appointment Diagnosis Date of appointment Required: a. Given this brief overview, draw an Entity Relationship Diagram for the Mesa Veterinary Hospital. (10 marks) b. Assume you are going to implement your ERD diagram using a relational database. Draw the necessary tables normalised to third normal form. Be sure to include all attributes from the text and the additional ones listed. Only create additional attributes if they are absolutely needed. (15 marks) F1 2014