Section 1 Database Schema and ER Diagram The database schema is shown in Figure 1. The ER diagram is shown in Figure 2. Course CourseNo CourseName Department Section CourseNo SectionNo Instructor waits SSN SectionNo CourseNo Student SSN | FirstName | LastName | Street | City | State | Zip Takes SSN CourseNo SectionNo |ExamNo Result Exam CourseNo SectionNo ExamNo E Date ETime Couductedln RoomNo Building CourseNoSectionNo ExamNo ClassRoom RoomNo Building Capacity Figure 1 Database Schema Section 1 Database Schema and ER Diagram The database schema is shown in Figure 1. The ER diagram is shown in Figure 2. Course CourseNo CourseName Department Section CourseNo SectionNo Instructor waits SSN SectionNo CourseNo Student SSN | FirstName | LastName | Street | City | State | Zip Takes SSN CourseNo SectionNo |ExamNo Result Exam CourseNo SectionNo ExamNo E Date ETime Couductedln RoomNo Building CourseNoSectionNo ExamNo ClassRoom RoomNo Building Capacity Figure 1 Database Schema