Page 1 of 1
Problem 2. Relation Normalization. Primary keys are underlined and foreign keys are in italic. a. [6 points] Create nece
Posted: Thu May 05, 2022 1:35 pm
by 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 45 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)