A. 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 Crow’s Foot E-R model for...


A. 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 Crow’s Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinalities. 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.



May 20, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here