Create separate entities for student-alumni-faculty advisers

Assignment Help Operation Management
Reference no: EM13902846

A) Draw an E-R data model for the Highline University Mentor Program Information System. Use the IE Crow's Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinality.

Your model should track students, advisers, alumni and 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 e-mail accounts in the format FirstName.LastName@hu.edu. The student entity should track student last name, student first name, student University ID number, student e-mail address, dorm name, dorm room number and door phone number.

-At Highline University, all faculty advisors have on-campas offices and are assigned Highline University ID numbers and e-mail accounts in the format FirstName.LastName@hu.edu. The faculty entity should track faculty last name, faculty first name, faculty University ID number, faculty e-mail 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 e-mail accounts in the format FirstName.LastName@somewhere.com. The alumni entity should track alumnus last name, almunus first name, alumnus former student number, e-mail 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 e-mail address for contact information. They do not have Highline University ID numbers as mentors. E-mail address is in the format FirstName.LastName@companyname.com. The mentor entity should track mentor last name, mentor first name, mentor e-mail address, company name, company address, company city, company state, company ZIP code and company phone number.

Reference no: EM13902846

Overarching conversation about the importance of ethics

With an overarching conversation about the importance of ethics. Why are ethics important? How do they affect our decision making? What are the consequences if we do something

What is the deep logic whereby you organize your list

List main and secondary characters in The Plague in order from preferable to less preferable moral codes according to your group’s judgment. And be ready to expound your argum

Basing your knowledge on the same

Technology has greatly impacted human resources and will continue to do so as new technology is developed. Basing your knowledge on the same, highlight how the technology has

Explain googles business model

Explain Google’s business model. Examine the financial reports in the case to determine the company’s profitability, liquidity, leverage and activity ratios. Based on these ra

We are exposed to good habits involving ethics and fraud

The more we are exposed to good habits involving ethics and fraud, the better the chance that we will share our knowledge with others. How can the government help to instill t

Set of coherent actions for implementation of the strategy

Nvidia went from an IPO in 1999 to being named “company of the year” by Forbes magazine in 2007. Forbes noted Nvidia had gross margins of 46 percent in 2006 and its stock pric

Considering the possibility of operating small business

You are considering the possibility of operating a small business or practice in some activity related to health care, as either a provider of some kind of care or as a servic

Requirements of the federal healthcare legislation

You are an employer with 15 full time employees, paying an average wage of $30,000 a year. You are concerned about how the requirements of the federal healthcare legislation

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd