Database Systems Page 1 of 1
NOTE: Attempt all questions.
Question 1 (Normalization) :
The above table shows a relation called GRADE REPORT for a University.
a. Draw a relational schema and diagram the functional dependencies in the relation.
b. In what normal form is this relation?
c. Decompose GRADE REPORT into a set of 3NF relations and show the referential integrity constraints
Solution:
a. Draw a relational schema and diagram the functional dependencies in the relation.
StudentID StudentName CampusAddres
s
Major CourseID CourseTitle
Instructor
Name
Instructor
Location Grade
Functional dependency 1:
StudentID StudentName CampusAddress, Major
CourseID CourseTitle, InstructorName, InstructorLocation
StudentID, CourseID Grade.
instructorLocation InstructorName
b. In what normal form is this relation?
The relation does not contain any repeated attributes.so the relation is in First Normal form (1NF)
c. Decompose GRADE REPORT into a set of 3NF relations and show the referential integrity
constraints
The third normal form shows relation, which is created from the0GRADE REPORT0shown below:
STUDENT:
