How do I create separate entities for students, alumni, faculty advisers, and mentors for all the bullet points shown. 
How do I revise the E-R Model I made based on the fact that students, faculty, alumni, and mentors are all one person?

 

Brandon Simanteris9/18/2016Assignment 4Module 4 AssignmentsHIGHLINE UNIVERSITY MENTOR PROGRAM CASE QUESTIONSHighline University is a 4-year undergraduate school located in the Puget Sound regionof Washington State.1Highline University, like many colleges and universities in thePacific Northwest (seehttp://en.wikipedia.org/wiki/Pacific_Northwest) is accredited bythe Northwest Commission on Colleges and Universities (NWCCU—seewww.nwccu.org). Like all the colleges and universities accredited by the NWCCU,Highline University must be reaccredited at approximately 5-year intervals. Additionally,the NWCCU requires annual status-update reports. Highline University is made up offive colleges: The College of Business, The College of Social Sciences and Humanities,the College of Performing Arts, the College of Sciences and Technology, and theCollege of Environmental Sciences. Jan Smathers is the president of HighlandUniversity, and Dennis Endersby is the provost (a provost is a vice president ofacademics; the deans of the colleges report to the provost).A discussion of the design of a college information system for Highline University is usedin Appendix D, “Getting Started with Systems and Analysis and Design,” as an exampleof creating data models (discussed in this chapter) and database designs (discussed inChapter 5). In this set of case questions, we will consider a different information systemfor Highline University, one that will be used by Highline University’s Mentor Program.The Highline University Mentor Program recruits business professionals as mentors forHighline University students. The mentors are unpaid volunteers who work together withthe students’ advisers to ensure that the students in the mentoring program learnneeded and relevant management skills. In this case study, you will develop a datamodel for the Mentor Program Information System.A.Draw an E-R data model for the Highline University Mentor Program Information System(MPIS). Use the IE Crow’s Foot E-R model for your E-R diagrams. Justify the decisionsyou make regarding minimum and maximum cardinality.Your model should track students, advisers and mentors. Additionally, HighlineUniversity needs to track alumni because the program administrators view alumni aspotential mentors.1.Create separate enTTes for students, alumni, faculty advisers, and mentors.At Highline University, all students are required to live on campus and areassigned Highline University ID numbers and email accounts in the formatFirstName.LastName@students.hu.edu.±he student enTty should trackstudent last name, student Frst name, student University ID number, studentAt Highline University, all faculty advisers have on-campus o²ces and areassigned Highline University ID numbers and email accounts in the formatFirstName.LastName@.hu.edu.±he faculty enTty should track faculty lastname, faculty Frst name, faculty University ID number, faculty email address,1

Attachments:

• 1494570495-M4A1.docx