Problem 2. Relation Normalization. Primary keys are underlined and foreign keys are in italic. a. [6 points] Create nece

[answerhappygod]

Problem 2 Relation Normalization Primary Keys Are Underlined And Foreign Keys Are In Italic A 6 Points Create Nece 1 (101.96 KiB) Viewed 44 times

Problem 2. Relation Normalization. Primary keys are underlined and foreign keys are in italic. a. [6 points] Create necessary relation(s) to bring the following relation to 3NF with primary key and foreign keys clearly specified for each relation. The assumptions are: a students can enroll in multiple programs and a program can have multiple students. StudentEnrollment(StudentID, StudentName, ProgramID, ProgramName, EnrollDate) b. [6 points] Create necessary relation(s) to bring the following relation to 3NF with primary key and foreign keys clearly specified for each relation. The assumptions are: a faculty works in one department, a department can have multiple faculties, and a department has one head. Here DepartmentID is a foreign key referring to primary key FacultyID. Faculty Directory (FacultyID, FacultyName, DepartmentID, DepartmentName, DepartmentHeadID)