Draw the ER diagram for below requirements:

Consider the following set of requirements for a UNIVERSITY database.

$1.$ The university keeps track of each student's name, student ID$,$ social security number, current address and

phone, birthdate, Gender, class $($freshman$,$ sophomore, $...,$ graduate$),$ major department, minor

department $($if any$),$ and degree program $($B$.$A$.,$ B$.$S$.,...,$ Ph$.$D$.)$ and an advisor. Some user applications need

to refer to the city, state, and zip of the student's permanent address, and to the student's last name. Both

social security number and student ID have unique values for each student.

$2.$ Each department is described by a name, department code, office number, office phone, and college. Both

name and code have unique values for each department.

$3.$ Each department have employees and university keep track of employee$$s name, employee ID$,$ social

security number, current address and phone, Gender. Employees teach course sections and advise

students. Both social security number and employee ID have unique values for each student.

$4.$ Employees may have dependents and described with name, gender and date of birth. Name can partially

identify the dependents.

$5.$ Departments offers courses and each course has a course name, description, course number, number of

semester hours, and offering department. The value of course number is unique for each course.

$6.$ Each section has an instructor, semester, year, course, and section number. The section number

distinguishes different sections of the same course that are taught during the same semester$/$year; its

values are $1,2,3,...,$ up to the number of sections taught during each semester.

$7.$ A grade report has a student, section, letter grade, and numeric grade $(0,1,2,3,4$ for F$,$ D$,$ C$,$ B$,$ A$,$

respectively$).$ Students enroll in sections and get a grade.

Things to do:

$1.$ Find the Entity types and all of its attributes and relationship between entity types. Draw an ER diagram.

$2.$ Specify key attributes of each entity type.

$3.$ Show structural constraints using $($min$,$ max$)$ representation, single line double line and cardinality ratio.

$4.$ For any unspecified requirements, make appropriate assumptions to make the specification complete. You

need to write your assumptions.

Submission:

You need to submit a pdf file with below contents:

$1.$ ER diagram representing structural constraints: $($min$,$ max$)$ representation, single line double line and

cardinality. For example:

$2.$ List strong entities and weak entities and their key$/$partial attributes. For example:

Entity Type Name Type of Entity Key Attributes