Draw ER Diagram:

Modern School of higher education has around 2000 students and three departments. The students belong to various departments in the school. Every department has a Head of Department along with teachers. The head of department manages his departmental teachers and the students belonging to his department. The head of department also teaches the students. All the head of departments report to the Principal of the school. The Principal manages the departments and also teaches the students. Handling the administrative staff of the school is also the responsibility of the Principal. Every individual, except the students, are the employees of the school

Problem

• Identify the entity
• Identify the entity’s attribute
• Identify the primary and foreign Keys
• Identify the relationship between Entities
• Identify the Cardinality constraints