B.Revise the E-R data model you created in part A to create a new E-R data model based on the fact that students, faculty, alumni, and mentors are all a PERSON. Use the IE Crows Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinality.

Note that: A person may be a current student, an alumnus, or both because Highline University does have alumni return for further study.

A person may be a faculty member or a mentor, but not both.

A person may be a faculty member and an alumnus.

A person may be a mentor and an alumnus.

A current student cannot be a mentor.

Each mentor may be an alumnus, but mentors are not required to be alumni. Alumni cannot, of course, be required to become mentors.

C.Extend and modify the E-R data model you created in part B to allow more data to be recorded in the MPIS system. Use the IE Crows Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinality. The MPIS needs to record: The date a student enrolled at Highline University, the date the student graduated, and the degree the student received

The date an adviser was assigned to a student and the date the assignment ended

The date an adviser was assigned to work with a mentor and the date the assignment ended

The date a mentor was assigned to a student and the date the assignment ended

Please, nothing handwritten. I can't see handwritten items well. Also if possible show tables instead of diagrams