You are asked to design the Relational Database Model for a simple college course management software with the below requirements

The software manage information of students, faculties, departments, and courses that are offered.

• The courses are offered in different sections
• A course may have prerequisites which are other courses
• The students can register for a section of a course. A student can take multiple sections throughout their program
• Each section is assigned a faculty to teach. A faculty can teach many sections
  • The faculties department information is also stored
• Each section also offer tutoring sessions where a student helps another student

Please derive the RDM diagram for this database with the requirements

• Student and Faculty should have basic information like name (first and last), email, phone number
• Courses have name and description
• Departments have name and address
• Course sections should have their schedule information including year, semester, lecture time
• The student grade from a course section should be recorded
• All tutoring sessions should have their meeting time recorded

Some hints to help you:

• The tutoring relationship is a ternary one StudentStudent-CourseSection with an attribute (meeting time). It is resolved similarly to a M:N relationship (there are examples in the slides). Remember to add the required attribute.
• Student grade is an attribute of the Take relationship. Remember to add the required attribute when resolving this relationship.