SQL Database Question:

Design an ER diagram for the following situation. Make sure cardinalities and primary keys are clear.

Every semester, students may register in one or more courses or may not register any courses at all. A course will be offered if at least one student registers for the course. Several lecturers may teach the same course but in different sections. A lecturer may teach more than one course or one section at one time or may not teach any courses at all. However, for every section being offered, only one lecturer will be teaching the subject. At the end of the semester, each student will be assigned to one specific seat number in the test hall before taking the final test. Each seat belongs to exactly one student.

The above information needs to be stored in a database within several tables. Table STUDENTS store information on last name, first name, student ID and PhoneNo. The student ID is the identifier of this table. In addition, each course is identified using a Course ID. Other information required for table COURSES include CourseName and CreditHour. SECTIONS store information about each section such as Section ID, Section Name and Venue. Information on lecturers which are Lecturer ID, lecturer name and office number are stored in table LECTURERS. Finally, table SEATS store information on Seat ID, Location and Student ID.