Design a Database (ERD) for that sample data.

Des base to kcep track of the room assignments and instructors for courses scheduled at a university. A college course (like IS201) could be ctors and an instructor could teach many courses. A section of a course, however, is taught by one instructor. A course may have one or taught by many and value for a taught by will be taught for a particular semester and year tions, or may not have a scheduled section. Attributes of COURSE include courseID, coursename, and credits. A courselD is a unique given course. Attributes of a SECTION of a course include courselD, sectionID, semester, and year. A given section of a course is only one instructor. An INSTRUCTOR is identified by an instructorID. Additional information we want to store about an instructor des the lastname, firstname, and officenumber of the instructor. The goal of this database is to relate the roomID where a section of a course Sample data for this application system is provided below CourselD Course Name CreditsSectionID Semester Year InstructorLast First Instructor RoomID ID Name NameOffice IS201 IS201Computer Applications IS201 IS201 4902 Smith James AB222C 4902 Smith James AB2220 6531 Ng AB109 AB205 WRB2033 Computer Applications 1Spring 2 Spring 3 Spring 1 Summer 1 2018 4902 Smith James AB22CAB212 2018 2018 2018 Computer Applications Ngyuen A8231 WR82033 Computer Applications Computer Applications Computer Applications 4902 Smith James AB222C 6531 Ng AB109 AB201 AB109 SEM234 IS201 Computer Applications Summer 1 | 2018 2018 2018 2018 7811 Edberg DanaAB314D Ngyuen AB231 IS201 IS475Database Design IS201 7811 Edberg DanaAB314D Fall 4 Spring 1 Spring 2 Fall CFA14 7899 Barfar Arash AB314A 7811 Edberg Dana AB314D 2018 IS482Data Resource Mgmt IS475 Database Design Fall 2018 7811 Edberg Dana834 A8110