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:
Year of first visit
Date of last visit
Type of animal
Date of birth
Length of animal
Weight of animal
Last visit date
Picture of animal
Comments on animal
Date of visit
Follow-up visit date
Total amount billed for visit
Details on the individual visits:
Type of visit
Medication code and price
Details on all medications and visits:
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?
Tables are divided like this: - 1. Customer ( CustomerID , PetID , Name, Address, City, State, ZIP, Phone, FirstVisitYear,... View the full answer