Consider the following information about a university database: Professors have a National Identity Number $($NIN$),$ a name, an age, a rank,and a research specialty. Projects have a project number, a sponsor name $($e$.$g$.,$ TETFUND$),$ astarting date, an ending date, and a budget. Graduate students have an NIN, a name, an age, and a degree program$($e$.$g$.,$ M$.$S$.$or Ph$.$D$.).$ Each project is managed by one professor $($known as the projectsprincipal investigator$).$ Each project is worked on by one or more professors $($known as theprojects co$-$investigators$).$ Professors can manage and$/$or work on multiple projects. Each project is worked on by one or more graduate students $($known asthe projects research assistants$).$ When graduate students work on a project, a professor must supervisetheir work on the project. Graduate students can work on multipleprojects, in which case they will have a $($potentially different$)$ supervisorfor each one. Departments have a department number, a department name, and a mainoffice. Departments have a professor $($known as the HOD$)$ who runs thedepartment. Professors work in one or more departments, and for each departmentthat they work in$,$ a time percentage is associated with their job. Graduate students have one major department in which they are workingon their degree. Each graduate student has another, more senior graduate student$($known as a student advisor$)$ who advises him or her on what courses totake$\mathrm{.}3.$ Design and draw an ER diagram that captures the information about theuniversity. Use only the basic ER model here; that is$,$ entities,relationships, and attributes. Be sure to indicate any key andparticipation constraints$\mathrm{.}4.$ Reduce the ER$-$diagram to a relational model