Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

could you plase help me doing an ER diagram for the HU mentor program on VISIO coul you please show me the actual diagram please

could you plase help me doing an ER diagram for the HU mentor program
on VISIO
coul you please show me the actual diagram please and thank you
if possible show me how to do it
thanks image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
coukd you please see ghe pictures that i reupload please
1. Creste seporate entaties tor studerts, alumni (asthey con volunterer to be mestorth, frovily advisers, and menton anderib te mentar not required weok wath mention. asiered Hetline Univesthy 10 nimber and emnt accounts in the farrat last name, itudeet firt na Tu, itidert Uriveniby o wamber, studert emal? adtres, doem name, dorm rocm rumbe, and dorm phone number. b. At Hetbine Unizenity, al thaily abvers heve oncurpus offices and are a asuened Hichine Univesity 0 nambers and emal soounb in the format fender finst nane, tacalty unverity o mmber, focily enal addest. expartmert, effer buldine nare, otfice tuldire toom numbet, and eftice. thene nutlee. bast name, dumuin trit neme, alunuas former itudent number, emal address, hame addren, bome ofy, home stite, home ap code, and phore fuetier phens, and emal addinu for condect information. they do met have blictire cormary addies, company cty, comsary state, cameary ar code and comeary plene muribier. 2. Ceate relsoiombips test wenm antities tased so the following facts: aovser, One faculy wearder mer advise severai students, bat tooulty menters ere cot reouined to advise itudesta. Highline University is a 4-year undergraduate school located in the Puget Sound region of Washington State. The Highline University has a very unique mentor program. Their Mentor Program recruits business professionals as mentors for Highline University students. The mentors are unpaid volunteers who work together with the students "advisers to enswre that the students in the mentoring program learn needed and relevant management skills. In this case study. you will develop an ER Diagram for the HU Mentor Program. Make sare you have the Primary Keys and Foreign Keys appropriately mentioned for each entity. 1. Create separate entities for students, alumni (as they can volunteer to be mentors), faculty advisers, and mentors. a. 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(astudents. 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. b. At Highline University, all faculty advisers have oncampus offices and are assigned Highline University ID numbers and email accounts in the format FirstName.Last Name(a. 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. c. Highline University alumni live off campus and were previously assigned Highline University ID numbers. Alumni have private email accounts in the format FirstName.Last Namea somewhere.con. 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. d. 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 last name, mentor first name, mentor email address, company name, company address, company city, company state, company ZIP code, and company phone number. 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. - 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 actually assigned students to mentor. - 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. - Each mentor may be an alumnus, but mentors are not required to be alumni. Alumni cannot, of course, be required to become mentors. Highline University is a 4-year undergraduate school located in the Puget Sound region of Washington State. The Highline University has a very unique mentor program. Their Mentor Program recruits business professionals as mentors for Highline University students. The mentors are unpaid volunteers who work together with the students "advisers to enswre that the students in the mentoring program learn needed and relevant management skills. In this case study. you will develop an ER Diagram for the HU Mentor Program. Make sare you have the Primary Keys and Foreign Keys appropriately mentioned for each entity. 1. Create separate entities for students, alumni (as they can volunteer to be mentors), faculty advisers, and mentors. a. 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(astudents. 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. b. At Highline University, all faculty advisers have oncampus offices and are assigned Highline University ID numbers and email accounts in the format FirstName.Last Name(a. 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. c. Highline University alumni live off campus and were previously assigned Highline University ID numbers. Alumni have private email accounts in the format FirstName.Last Namea somewhere.con. 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. d. 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 last name, mentor first name, mentor email address, company name, company address, company city, company state, company ZIP code, and company phone number. 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. - 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 actually assigned students to mentor. - 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. - 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

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

Implementing Ai And Machine Learning For Business Optimization

Authors: Robert K Wiley

1st Edition

B0CPQJW72N, 979-8870675855

More Books

Students also viewed these Databases questions

Question

Why do women have such low self-esteem?

Answered: 1 week ago

Question

You have

Answered: 1 week ago