Draw the complete Entity Relation Diagram for the following scenario: Consider the following set of requirements for a database that is used to keep track of graduate students and their professors Professors have an SSN, a first name, a last name, an email address and a birthdate Projects have a unique project number, a project description, a starting date, an ending date and a budget Graduate students have a student number , a first name, a last name, a birthdate, an email address and a graduate degree type (MSc or PhD) Departments have a unique department number, a unique department name, a main office number and a building code for the building they are located in Each project is lead by one professor Each project has one or more professors working on it Professors can lead/work on many projects or no projects Each project is worked on by one or more grad students, a grad student works on either 0 or 1 projects. Professors supervise grad students. A grad student will have one or more supervisors. A professor might not supervise any grad students Each department has a professors who chairs the department. A professor would only be chair of one dpeartment but each professors works in one or more departments. You need to keep track of the amount of time they have worked for each department. Every grad student majors in one department and might minor in one other department. Every department has at least three grad students who major in it and at least two students who minors in it. A grad student could have an older more experienced senior grad student who acts as a mentor for that student. Some senior grad students wouldn't have mentors. A grad student could mentor many grad students. Show both the cardinality of the relationships (the 1:M notation on the lines) and the participation (include both the (min, max) constraints AND the double line/single line notation). Do NOT include any extra information than is given above to illustrate the above database. For each entity, underline the key you would pick to be the primary key (if it is a composite key indicate that next to the entity), if there is more than 1 candidate key, underline all the candidate keys (use a squiggly line (or indicate somehow, colour change, anything) for candidate keys but a straight line for the one you would choose to be the primary key). You will be marked on choosing the best solution, some solutions may work but not be the best! Do not use the Crows Foot Notation.