in the normalization steps for this pet and owner table in a database class :

Started with Candidate keys, followed by functional dependency break the tables up into tables , then the referential integrity and the end .

PET (Petname,PetType,PetBreed,PetDOB,OwnerLastnameOwnerFirstName,

OwnerPhone,OwnerEmail,Service,Date,Charge)

Step 1: Candidate Keys

The last functional dependency assumes a pet is seen at most on one day and that there is no standard charge for a service.

(PetName,Date)

Step 2 : Functional Dependecies

PetName (PetType, PetBreed, PetDOB, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)

OwnerPhone (OwnerLastName, OwnerFirstName, OwnerEmail)

(PetName, Date) (Service, Charge)

Step 3:

Dividing the relation if determinant is not a candidate key

Is every determinant a candidate key ?

PetName and OwnerPhone are determinants but not candidate keys

OWNER (OwnerPhone, OwnerLastName, OwnerFirstName, OwnerEmail)

PET (PetName, PetType, PetBreed, PetDOB, OwnerPhone)

SERVICE (PetName, Date, Service, Charge)

referential integrity

OwnerPhone in PET must exist in OwnerPhone in OWNER

PetName in SERVICE must exist in PetName in PET

In the Same steps I need help with two relations :

Apply the normalization process to the following relations. Show the following steps for each relation:

Show the candidate keys from the original relation.

Show the functional dependencies from the original relation.

Is any determinant not a candidate key? If so, show the following:

The new normalized relations.

The primary key in each new relation.

The foreign keys in the new relations.

The referential integrity constraints for the foreign keys.

Relation 1:

BASEBALL (Player, Number, Position, Coach, Team, Manager)

Assumptions:

Each player has a unique (different from all the others) name.

Each player belongs to a specific team.

Each player plays only one position, such as pitcher, infield, or outfield.

Each position has only one coach, such as pitching coach or infield coach.

Each team has only one manager.

State any other assumptions you make.

Relation 2:

GRADE (StudentID, StudentName, Class, ClassRoom, Instructor, InstructorOffice, Grade)

Assumptions:

Each class meets in a certain room.

Each class has only one instructor.

Each student gets one grade from each class they take.

State any other assumptions you make.