E-R Modeling from the Problem Statements

 

Draw an ER diagram for a School Management System based on the following information.

You have been asked to implement a database for a school management system (SMS). This primarily consists of maintaining students' information like name, address, date of birth, roll number, deparment, and so on. Details about the school to be stored includes school's name, location. Although it is unlikely that there would be two schools at the same place with same name, but our SMS would like to accomodate this possibility.

Faculty members works in the school. They teaches the students. A faculty member normally teaches multiple students at a time. Also, he can teach multiple courses to the students.

Decrease font size Increase font size List of experiments
Top