Relational schema
Problem 1: Relational Schema (7 pts)
Use the ERD and EERD for the Soccer League Database to build its Relational Schema (RS).
Problem 2: Normalization (3 pts)
Convert the following table to the 3rd normal form:
STUDENT (StudentID, StudentName, NumCredits, AdvisorID, AdvisorName, Course
(CourseID, Description, Grade)).
Consider the following functional dependencies:
StudentID → StudentName, NumCredits, AdvisorID, AdvisorName
CourseID → Description
StudentID, CourseID → Grade
AdvisorID → AdvisorName
Note: StudentID and CourseID are the CPK for the STUDENT table’s 1st normal form.
Use the ERD and EERD for the Soccer League Database to build its Relational Schema (RS).
