For each of the following relations, indicate the normal form for that relation.

Question

For each of the following relations, indicate the normal form for that relation. If the relation is not in third nor-mal form, decompose it into 3NF relations. Functional dependencies (other than those implied by the primary key) are shown where appropriate.

a. CLASS(CourseNo, SectionN.o) b. CLASS(CourseNo, SectionNo, Room) c. CLASS(CourseNo, SectionNo, Room, Capacity) fED: Room --> Capacity] d. CLASS(CourseNo, SectionNo, CourseName, Room, Capacity) [FD: CourseNo --> CourseName; FD: Room Capacity 1

Explanation / Answer

a. CLASS(CourseNo, SectionN.o)-- 3nf

b. CLASS(CourseNo, SectionNo, Room) --3nf

c.CLASS(CourseNo, SectionNo, Room, Capacity) -- 2nf

given there is FD Room --> Capacity --its a transitive dependency so its in 2nf

now

CLASS(CourseNo, SectionNo, Room) its in 3nf

and

RMCPTY(Room, Capacity)its in 3nf

Room, Capacity

d.CLASS(CourseNo, SectionNo, CourseName, Room, Capacity) --2nf

given there is FD Room --> Capacity and CourseNo --> CourseName --its a transitive dependency so its in 2nf

CLASS(CourseNo, SectionNo, Room) in 3nf

and

RMCPTY(Room, Capacity)its in 3nf

and

CNAME(CourseNo,CourseName ) in 3nf

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.