Question: For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into
For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into 3NF relations. Functional dependencies (other than those implied by the primary key) are shown where appropriate.
a. CLASS(CourseNo, SectionNo)
b. CLASS(CourseNo, SectionNo, Room)
c. CLASS(CourseNo, SectionNo, Room, Capacity) [FD: Room → Capacity]
d. CLASS(CourseNo, SectionNo, CourseName, Room, Capacity) [FD: CourseNo → CourseName; FD: Room → Capacity]
Step by Step Solution
3.55 Rating (159 Votes )
There are 3 Steps involved in it
a 3NF b 3NF c 2NF CLASS CourseNo ... View full answer
Get step-by-step solutions from verified subject matter experts
