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.
