Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

3rd Edition

0128012757, 978-0128012758

More Books

Students also viewed these Databases questions

Question

3. How would this philosophy fit in your organization?

Answered: 1 week ago

Question

How would you assess the value of an approach like this?

Answered: 1 week ago