Determinng the er modeling

Assignment Help Business Economics
Reference no: EM131439351

ER Modeling

Scenario:

Cal Lutheran School of Management has hired you to help create conceptual data models (ERDs) for the following requirements below.

Cal Lutheran School of Management needs a database that tracks graduate student and alumni information. As a first step, your data model needs to track information about current students such as name, local address, major (or program) (e.g. IT, MBA, MPPA), gender, GPA and country of origin. Each student is assigned an advisor for the duration of the program who helps the student navigate program requirements. Information about advisors needs to be stored including name, campus address, office number, phone, email. During their program, students register for courses. Because the courses are graduate level (and require a lot of work), students may register in a maximum of 3 courses per term. It is possible a student does not take classes during a term (because s/he can take the term off). Data about courses needs to be stored in the system such as course prefix (e.g. IT509), section number, course name, number of credits, day it is offered and time (e.g. 7-10PM). In addition, the ERD also needs to show instructor data such as name, title (e.g. MS, Ph.D., Ed.D.), campus address, phone and email. Instructors are scheduled to teach various classes thorough the academic year. Any class can be co-taught (which means that it is possible a class is co-taught by a team of generally 2 instructors). The ERD needs to track such data. In addition, the data model needs to track alumni information. Basic information about alumni needs to be maintained such as name, address, CLU email, personal email, phone number, major (or program) (e.g. IT, MBA, MPPA), gender, GPA and graduation date. Cal Lutheran organizes alumni events around the world to better serve their alumni. Data about events such as country of location, specific address in that country, date of the event, brief description. In addition, each event is managed by a dedicated staff. Data about staff needs to be recorded such as position, name and contact info (address, phone and email). Staff members can manage various different events over time. Yet, each event has one staff member in charge who is directly responsible for the event. The ERD needs to track this. Alumni attend such alumni events. It is possible that a student attends various such events while others attend none. Upon attendance, alumni leave comments related to the particular event. Such comments also need to be stored. Please note that the comments vary with the student and the event attended.

Specific requirements:

  • Please submit 2 ER diagrams:

1. First ERD should include all original M:N relationships.

2. Second ERD should resolve all M:N relationships into associative entities.

  • For both ERDs, you need to resolve any composite and multivalued attributes.
  • You need to list ALL assumptions that you have made (that augment but do not violate given requirements).
  • For both ERDs, you need to use M.S.Visio(and the stencil). Please make sure bothERDsare professionally prepared (this includes alignment on the page, lines not crossing, etc). Hand-drawn diagrams are not acceptable.

What you will submit:

  • ONE M.S. Visio file containing BOTH your ERDs.
  • ONE M.S. Word file containing BOTH your ERDs. Please copy & paste both your drawings into Word. Make sure you arrange the image on the page. Print screens are not acceptable.
  • In submitting your work, you need to follow all naming conventions discussed in class for all files you submit.
  • Please use the DROPBOXES tab in Blackboard to submit your work.
  • Note: failure to meet all submission requirements will result in loss of points.

Reference no: EM131439351

Questions Cloud

What are significant elements that ensure successful change : ORG-812: What are the most significant elements that ensure successful change and how do these elements relate to organization change?
Compare a user-entered string with bird : Write code to compare a user-entered string with "bird" and print "Found a bird! Spring has sprung." when the strings match and print "The bird has flown." when they don't. Use If-Else branching statements.
How can an ambidextrous approach be helpful : ORG-812: How can an Ambidextrous Approach be helpful when changing organizational structure? Would another approach be more helpful? If so, how? If not, why not?
Conduct research on a piece of music : Conduct research on a piece of music that was performed at your event, preferably the piece you listened to for the proposal. Here are some questions you should consider answering in this section:What is known about this piece? Why was it written?..
Determinng the er modeling : Cal Lutheran School of Management needs a database that tracks graduate student and alumni information. As a first step, your data model needs to track information about current students such as name, local address, major (or program) (e.g. IT, MB..
Discuss the significance of values-based leadership : ORG-812: Discuss the significance of values-based leadership to the culture of an organization. How is the leader essential in communicating organizational values inside and outside of the organization?
Develop spreadsheet using the simple valuation function : Develop a spreadsheet model for determining value, using the simple valuation function Value = D/(r - g), where r is the discount rate =10% and g is the growth rate = 4% and D is dividend = 1.25. Use a two-way data table to determine value if g va..
Would you recommend that gentiva health services increase : How many more visits will the company generate if it accepts Medicare patients? Would you recommend that Gentiva Health Services increase its number of Medicare patients served? Why or why not?
Produce a count of the number of different minimum paths : Explain how to modify Dijkstra's algorithm to produce a count of the number of different minimum paths from v to w, and if there is more than one path from v to w, find the path from with the fewest number of edges ar chosen

Reviews

Write a Review

Business Economics Questions & Answers

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

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