Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Project 28: Daily Invoice Foothills Animal Hospital is a full-service small animal veterinary hospital located in Morrison, Colorado, specializing in routine medical care, vaccinations, laboratory
Project 28: 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. Page AYK18 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started