E$/$R diagram example:

A Graduation Project Management database contains information about Supervisors, Students,

and Projects.

Supervisors are the faculty members and they are identified by SSN$,$ and have a name, an

address, a title, and a department.

Students are identified by student$\_$id$\_$number, have a name, year, department, and gpa

attributes. Students are members of project teams. Each project team has team id as the key,

team name, and semester attributes. Some of the students are team leaders and each team leader

manages exactly one project team, and each project team must have exactly one leader.

Projects have id $($as key$),$ title, description and supervisor attributes. Each project must have

exactly one supervisor who is a faculty member. A supervisor can manage any number of

projects.

Projects are assigned to project teams. A project team is assigned to exactly one project, but

any number of project teams can be assigned to the same project.

Project teams submit a project report to the supervisor about their assigned project. And project

reports should have id $($key$),$ title, full document, and date of submission attributes.