View the step-by-step solution to:

You work in a Veterinarian's office and need to organize the data on pets that you treat. In your database, you want to keep track of the following...

You work in a Veterinarian's office and need to organize the data on pets that you treat. In your database, you want to keep track of the following information:


Customer information:

Name

Address

City

State

ZIP

Phone #

Year of first visit

Date of last visit

Discount

Outstanding balance


Pet information:

Name

Type of animal

Breed

Date of birth

Gender

Neutered/Spayed?

Length of animal

Weight of animal

Last visit date

Current vaccinations

Picture of animal

Comments on animal

Date of visit

Follow-up visit date

Total amount billed for visit

Payment type

Date paid

Amount paid

Taxable?

Tax Rate

Invoiced?


Details on the individual visits:

Type of visit

Treatment code

Medication code and price


Details on all medications and visits:

Medication name

Medication price

Treatment name

Treatment price


1. How would you divide the data? Again, lay out the different tables that you would propose creating, with the fields that would be in each of the tables. Be sure to use the Leszynski Naming Convention for all object names.

2. Which fields would be defined as the Primary and Foreign key fields in each table?

3. What type of relationship would you create between the tables? Which fields would be joined to which other fields?

Top Answer

Tables are divided like this: - 1. Customer ( CustomerID , PetID , Name, Address, City, State, ZIP, Phone, FirstVisitYear,... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online