Question: Please mention how you do it with SQL. Thank you B. Revise the E-R data model you created in part A to create a new
B. 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 Crow's 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. (SQL or code needed) 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. (SQL or code needed) - Each mentor may be an alumnus, but mentors are not required to be alumni. Alumni cannot, of course, be required to become mentors
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
