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
Get step-by-step solutions from verified subject matter experts
