(20 points) 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 (see the example in Figure 4-27 of the textbook). 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).

CLASS(CourseNo, CourseTitle, SectionNo)

CLASS(CourseNo, SectionNo, RoomNo)

CLASS(CourseNo, SectionNo, RoomNo, RoomCapacity)