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.