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.