Reference no: EM132256237

Daily Invoice Foothills Animal Hospital is a full-service small animal veterinary hospital located in Morrison, Colorado, specializing in routine medical care, vaccinations, laboratory testing, and surgery. The hospital has experienced tremendous growth over the past six months due to customer referrals. While Foothills Animal Hospital has typically kept its daily service records in a workbook format, it feels the need to expand its reporting capabilities to develop a relational database as a more functional structure. Foothills Animal Hospital needs help developing a database, specifically: ? Create a customer table—name, address, phone, and date of entrance. ? Create a pet table—pet name, type of animal, breed, gender, color, neutered/spayed, weight, and comments. ? Create a medications table—medication code, name of medication, and cost of medication. ? Create a visit table—details of treatments performed, medications dispensed, and date of the visit. ? Produce a daily invoice report. Figure AYK.2 displays a sample daily invoice report that the Foothills Animal Hospital accountants have requested. Foothills Animal Hospital organizes its treatments using the codes displayed in Figure AYK.3 . The entities and primary keys for the database have been identified in Figure AYK.4 . The following business rules have been identified: Project Focus Your job is to complete the following tasks: 1. Develop and describe the entity-relationship diagram.2.create an Access database, populate it, and create any queries, forms, and/or reports as per the instructions in AYK 28

(All tables are created and populated,All Relationships are set between tables,query has been created to pull the specific data from the tables to create the report (Customer Name, Pet Name, Type of Animal, Treatment, and Price),This criterion is linked to a Learning OutcomeCreate a report that is something similar to Figure AYK.2 on page AYK.16 of the textbook)