Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 ER data model you created in part A to create a new ER data model since
students, faculty, alumni, and mentors are all a PERSON. Use the IE Crows Foot ER
model for your ER 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started