Chapter 1, Problem 1.11RQ

Explanation of Solution

Number of themes in The Veterinary Office List – Version Two table:

Themes: 

Database tables may deal with the information about one or more things which are called themes.

Two themes in the list:

Note: Refer the table 1-35 in the textbook.

There are three themes. They are:

• Pet details
• Owner details
• Service details

Pet details table:

The pet details table contains the following attributes such as “PetName”, “PetType”, “PetBreed”, and “PetDOB”.

PetName	PetType	PetBreed	PetDOB
King	Dog	Std.Poodle	27-Feb-14
Teddy	Cat	Cashmier	1-Feb-13
Fido	Dog	Std.Poodle	17-Jul-15
AJ	Dog	Collie mix	5-May-15
Cedro	Cat	Unknown	6-Jun-12
Woolley	Cat	Unknown	????
Buster	Dog	Border Collie	11-Dec-11
Jiddah	Cat	Abyssinian	1-Jul-08

Owner details table:

The owner details table contains the following attributes such as “Owner_Lname”, “Owner_Fname”, “OwnerPhone”, and “Owner_mail”...