The following table shows a list of pets and their owners that is used by a vete

Question

The following table shows a list of pets and their owners that is used by a veterinarian service.

Kino

a. Describe four problems that are liekly to occur when using this table.

b. Break the table into two tables in a way that fixes the four problems.

P_Name Type Breed DOB Owner O_Phone O_Email

Kino

Dog Std. Poodle 3/27/97 M. Downs 5551236 md@abc.com Teddy Cat Chartreaux 4/2/98 M. Downs 1232343 md@abc.com Filo Dog Std. Poodle 2/24/02 R. James 2343454 rj@abc.com AJ Dog Collie Mix 11/12/95 Liz Frier 3456567 liz@abc.com Cedro Cat Unknown 12/10/96 R. James 7865432 rj@abc.com Woolley Cat Unknown 10/2/00 M. Trent 9870678 mt@abc.com Buster Dog Collie 4/4/01 Ronny 4565433 ron@abc.com

Explanation / Answer

1)
Major problems with this table:

1)Redundant data
because whenever a new P_Name is to be added Information about Dog and its owner
is repeated unnecesarily which should not be happen because attributes of Owner and Dog
are dependant on them respectively not on P_Name.

2)Updating the record:
If supoose you want to change the information for owners name or phone or email than
you have to do it at all the places where it has been used
but if you had one single dedicated table for owner than no problem you will be changing at one place.
Same with the dog information

3)No Primary Key
Primary key must be defined on the table for making retrieval fast .

2)

Pet Details Table(Primary Key(P_Id) Foreign Key(OwnerId) )

P_Id     P_Name   DOB     Owner ID   Dog      Breed

Owner Details (Primary Key(OwnerId) )

OwnerId    Owner    O_Phone    O_Email

If you want further normailsation:

Pet Details Table(Primary Key(P_Id) Foreign Key(OwnerId) Foreign Key(DogId))

P_Id     P_Name   DOB     OwnerID   DogId

Dog Details Table(Primary Key(DogId))

DogId    Dog   Breed

Owner Details Table(Primary Key(OwnerId) )

OwnerId    Owner    O_Phone    O_Email

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.