an E-R data model for the Highline University Mentor Program Information
Plese answer for Part B and use the ER diagrm with the circles
A. Draw an E-R data model for the Highline University Mentor Program
(MPIS). Use the IE Crow’s Foot E-R model for your E-R diagrams. Justify the decisions
you make regarding minimum and maximum cardinalities.
Your model should track students, advisers, and mentors. Additionally, Highline
University needs to track alumni because the program administrators view alumni as
potential mentors.
1. Create separate entities for students, alumni, faculty advisers, and mentors.
• At Highline University, all students are required to live on campus and are assigned
Highline University ID numbers and email accounts in the format
FirstName.LastName@students.hu.edu. The student entity should track student last
name, student first name, student University ID number, student email address,
dorm name, dorm room number, and dorm phone number.
• At Highline University, all faculty advisers have on-campus offices and are assigned
Highline University ID numbers and email accounts in the format
FirstName.LastName@hu.edu. The faculty entity should track faculty last name,
faculty first name, faculty University ID number, faculty email address, department,
office building name, office building room number, and office phone number.
• Highline University alumni live off campus and were previously assigned Highline
University ID numbers. Alumni have private email accounts in the format
FirstName.LastName@somewhere.com. The alumni entity should track alumnus last
name, alumnus first name, alumnus former-student number, email address, home
address, home city, home state, home ZIP code, and phone number.
• Highline University mentors work for companies and use their company address,
phone, and email address for contact information. They do not have Highline
University ID numbers as mentors. Email addresses are in the format
FirstName.LastName@companyname.edu. The mentor entity should track mentor’s
last name, mentor first name, mentor email address, company name, company
address, company city, company state, company ZIP code, and company phone
number.
2. Create relationships between entities based on the following facts:
• Each student is assigned one and only one faculty adviser and must have an
adviser. One faculty member may advise several students, but faculty
members are not required to advise students. Only the fact of this
assignment is to be recorded in the data model—not possible related data
(such as the date the adviser was assigned to the student).
• Each student may be assigned one and only one mentor, but students are
not required to have a mentor. One mentor may mentor several students,
and a person may be listed as a mentor before he or she is assigned students
to mentor. Only the fact of this assignment is to be recorded in the data
model—not possible related data (such as the date the mentor was assigned
to the student).
• Each mentor is assigned to work and coordinate with one and only one
faculty member, and each mentor must work with a faculty member. One
faculty member may work with several mentors, but faculty members are
not required to work with mentors. Only the fact of this assignment is to be
recorded in the data model—not possible related data (such as the date the
faculty member was assigned to the mentor).
• Each mentor may be an alumnus, but mentors are not required to be alumni.
Alumni cannot, of course, be required to become mentors.
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.
• 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
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
