Description:

Horizon School wants to create a student management database to keep track of its students and their academic details. By implementing this student management database, Horizon School aims to streamline its operations and enhance the student experience.

The school records essential information about each student, including student ID$,$ name, address, phone number, and email address. Each student can be enrolled in one or more courses, and each course is associated with one or more students. The school also records information about each course, such as the course code, title, and instructor. Each course can have one or more assignments, and each assignment is associated with one course. The school also records information about each assignment, including the assignment ID$,$ due date, and grade.

The school employs several staff members to manage student records. For each staff member, the school records the staff ID$,$ name, position, and contact details. Each staff member can be assigned to one or more departments, and each department has multiple staff members. Each staff member has a supervisor who is also a staff member. A supervisor can supervise many staff members. For each department, the school records the department ID$,$ name, location, phone number, and email address. Each department has multiple courses associated with it$,$ and each course is linked to a specific department. Each department must have a supervisor who is also a staff member. Each supervisor can oversee many departments.

With reference to the above scenario, answer the following questions:

Create an Entity$-$Relationship Diagram $($ERD$)$ showing the relevant entities, attributes, and relationships, including appropriate labels.

Generate the relational model of the corresponding ERD.