Question: You are given a task to develop a relational schema for a set of classes at UI. Each class has a CourseNo, CourseTitle, and multiple

You are given a task to develop a relational schema for a set of classes at UI. Each class has a CourseNo, CourseTitle, and multiple sections. Different courses use the same set of section numbers (SectionNo). Given a CourseNo and a SectionNo, the corresponding class room number (RoomNo) is determined. Each room has a fixed capacity. For each of the following relations, convert the short text statement to a graphical representation, underline the primary key attribute(s), diagram the functional dependencies, and indicate whether each functional dependency is a partial, transitive, or full dependency. Then, indicate in what normal form each relation is. If the relation is not in 3NF, decompose it into a set of 3NF relations using graphical representation, and indicate the PK/FK and referential integrity constraints of the resulting tables (but no need to show functional dependencies). a. CLASS(CourseNo, CourseTitle, SectionNo) b. CLASS(CourseNo, SectionNo, RoomNo) c. CLASS(CourseNo, SectionNo, RoomNo, RoomCapacity)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!