Reference no: EM132134123

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?