Question: You are asked to design the Relational Database Model for a simple college course management software with the below requirements The software manages information of

You are asked to design the Relational Database Model for a simple college course management software with the below requirements The software manages 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 o The faculties department information is also stored - Each section also offers 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 Student-Student-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.

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!