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 [email protected]. 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 [email protected]. 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 [email protected]. 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 [email protected]. 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.
|
These transactions are summarized as follows
: Liang Company began operations on January 1, 2012. During its first two years, the company completed a number of transactions involving sales on credit, accounts receivable collections, and bad debts
|
|
Determine and explain what type of leader steve jobs was
: Determine and explain what type of leader Steve Jobs was.
|
|
Identify strategy-business in product area of marketing mix
: What is your opinion on what the company should do in order to launch a new product? Please use one outside resource to support your answer. The resource must be professional but does not need to be scholarly. Identify a strategy for your business in..
|
|
How inventory overstatement at the end of year one carries
: Using your own numbers, make up an example to show management the effect of overstating inventory. Show how inventory overstatement at the end of Year 1 carries through to the beginning inventory overstatement in Year 2.
|
|
Create separate entities for student-alumni-faculty advisers
: 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. Create separate entities for stude..
|
|
Write report indicating top management responsible for fraud
: Write a short report indicating whether you think top management of the company is responsible for the fraud and state why (or why not).
|
|
Develop a list of changes for the operations function
: Develop a list of changes for the operations function that should be considered by the bank. Begin by identifying operations management decisions that would be involved in operating a bank, for example, layout of facility, staff, drive-through servic..
|
|
Gravitational pull of the moon-earth and sun
: The Gravitational pull of the moon, earth and sun, the rotation, revolution and tilt of the earth, the Coriolis effect, planetary and local winds, the ocean, evaporation, humidity and aerosols, all effect our weather. How do each of these effect o..
|
|
Important in implementing the strategy of an organization
: Why is the operations function important in implementing the strategy of an organization? Explain why the changes put in place by Victoria Chen and her team could either hurt or help the bank.
|