Project 28: Daily Invoice Foothills Animal Hospital is afull-service small animal veterinary hospital located in Morrison,Colorado, specializing in routine medical care, vaccinations,laboratory testing, and surgery. The hospital has experiencedtremendous growth over the past six months due to customerreferrals. While Foothills Animal Hospital has typically kept itsdaily service records in a workbook format, it feels the need toexpand its reporting capabilities to develop a relational databaseas a more functional structure. Foothills Animal Hospital needshelp developing a database, specifically: ? Create a customertable—name, address, phone, and date of entrance. ? Create a pettable—pet name, type of animal, breed, gender, color,neutered/spayed, weight, and comments. ? Create a medicationstable—medication code, name of medication, and cost of medication.? Create a visit table—details of treatments performed, medicationsdispensed, and date of the visit. ? Produce a daily invoice report.Figure AYK.2 displays a sample daily invoice report that theFoothills Animal Hospital accountants have requested. FoothillsAnimal Hospital organizes its treatments using the codes displayedin Figure AYK.3 . The entities and primary keys for the databasehave been identified in Figure AYK.4 . The following business ruleshave been identified: Project Focus Your job is to complete thefollowing tasks: 1. Develop and describe the entity-relationshipdiagram.2.create an Access database, populate it, and create anyqueries, forms, and/or reports as per the instructions in AYK28
(All tables are created and populated,All Relationships are setbetween tables,query has been created to pull the specific datafrom the tables to create the report (Customer Name, Pet Name, Typeof Animal, Treatment, and Price),This criterion is linked to aLearning OutcomeCreate a report that is something similar to FigureAYK.2 on page AYK.16 of the textbook)
