Create a description of the tables mapped from the ER model created in Exercise 9.13 for the Perfect Pets case study described in
Appendix B.
Exercise 9.13
Create an ER model for the Perfect Pets case study described in Appendix B. (If appropriate, use the enhanced ER concepts.)
Appendix B
Data requirements Veterinary clinics Perfect Pets has many veterinary clinics located in the main cities of America. The details of each clinic include the clinic number, clinic address (consisting of the street, city, state, and zip code), and the telephone and fax numbers. Each clinic has a Manager and a number of staff (for example vets, nurses, secretaries, cleaners). The clinic number is unique throughout the practice. Staff The details stored on each member of staff include the staff number, name (first and last), address (street, city, state, and zip code), telephone number, date of birth, sex, social security number (SSN), position, and current annual salary. The staff number is unique throughout the practice. Pet owners When a pet owner first contacts a clinic of Perfect Pets, the details of the pet owner are recorded, which include an owner number, owner name (first name and last name), address (street, city, state, and zip code), and home telephone number. The owner number is unique to a particular clinic. Pets The details of the pet requiring treatment are noted, which include a pet number, pet name, type of pet, description, date of birth (if unknown, an approximate date is recorded), date registered at clinic, current status (alive/deceased), and the details of the pet owner. The pet number is unique to a particular clinic. Examinations When a sick pet is brought to a clinic, it is examined by the vet on duty. The details of each examination are recorded and include an examination number, the date and time of the examination, the name of the vet, the pet number, pet name, type of pet, and a full description of the examination results. The examination number is unique to a particular clinic. As a result of the examination, the vet may propose treatment(s) for the pet.