Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!