in a Database Assignment

Here is the data Table :

Pet Name	Pet Type	PetBreed	PetDOB	Owner Last Name	Owner First Name	Owner Phone	Owner Email	Service	Date	Charge
King	Dog	Std. Poodle	27-Feb-11	Downs	Marsha	201- 823-5467	marsha @sw.com	Ear Infection	17-Aug-12	$65.00
Teddy	Cat	Cashmier	01-Feb-12	James	Richard	201- 735-9812	richard @sw.com	Nail Clip	5-Sep-12	$27.50
Fido	Dog	Std. Poodle	17-Jul-10	Downs	Marsha	201- 823-5467	marsha @sw.com
AJ	Dog	Collie Mix	05-May-11	Frier	Liz	201- 823-6578	liz @sw.com	One year shots	5-May-12	$42.50
Cedro	Cat	Unknown	6-Jun-09	James	Richard	201- 735-9812	richard @sw.com	Nail Clip	5-Sep-12	$27.50
Woolley	Cat	Unknown	???	James	Richard	201- 735-9812	richard @sw.com	Skin Infection	3-Oct-12	$35.00
Buster	Dog	Border Collie	11-Dec-08	Trent	Miles	201- 634-2345	miles @sw.com	Laceration Repair	5-Oct-12	$127.00

VET_2 (PetName, PetType, PetBreed, PetDOB, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail, Service, Date, Charge)Question

Here are 4 Questions i am Stumped on For this table .

1: Another version of the list used by the veterinary office is shown above. How many themes does this list have? What are they?

Question 2: Break this list into tables, each with a single theme. Create ID columns as you think necessary. Use the table representation shown in the Study Guide and in class (not in textbook), like this:

STUDENT (StudentLastName, StudentFirstName, StudentEmail, Phone, Residence, AdviserLastName) ADVISER (AdviserLastName, AdviserFirstName, AdviserEmail)

Question 3: Show how the tables you created solve the three problems of lists identified in this chapter.

Question 4: Describe in your own words and illustrate with tables how relationships are represented in a relational database. Refer to the tables you created above.