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 are shown where appropriate. a) CLASS(CourseNo, SectionNo) b) CLASS(CourseNo, SectionNo, Room) c) CLASS(CourseNo, SectionNo, Room, Capacity) d) CLASS(CourseNo, SectionNo, CourseName, Room, Capacity)

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 are shown where appropriate. a) CLASS(CourseNo, SectionNo) b) CLASS(CourseNo, SectionNo, Room) c) CLASS(CourseNo, SectionNo, Room, Capacity) d) CLASS(CourseNo, SectionNo, CourseName, Room, Capacity)

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter2: Data Models

Section: Chapter Questions

Problem 11P

See similar textbooks