Stuck on a problem I need to identify and Apply the normalization process to the following 2 relations , Show the following steps for each relation: here is a preview of what it should look like primary keys underlined foreign keys Italicized. Step 1 list the candidate keys , 2 list the fictional dependencies, and 3 break into tables with its referential integrity. Needs

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.

Example:

The relation :PET (Petname,PetType,PetBreed,PetDOB,OwnerLastnameOwnerFirstName,OwnerPhone,OwnerEmail,Service,Date,Charge)

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)

2 : Functional Dependecies. PetName ->(PetType, PetBreed, PetDOB, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)

OwnerPhone -> (OwnerLastName, OwnerFirstName, OwnerEmail)

(PetName, Date) -> (Service, Charge)

3: Dividing the relation if determinant is not a candidate keyIs 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

Here is the two relations I am stuck on :

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.