Question: Revise the E - R data model you created in part A to create a new E - R data model since students, faculty, alumni,

Revise the E-R data model you created in part A to create a new E-R data model since
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 cardinalities. The relevant business rules are:
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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!