Develop an erm and eerm, Develop an ERM and EERM for the

Develop an erm and eerm

Assignment Help Software Engineering

Reference no: EM13753886

Develop an ERM and EERM for the following case study. Include:

Entities (incluing names),
Relationships (including names),
minimum and maximum cardinalities,
intersection entities, and
primary and foreign keys.

CASE

An airline has multiple planes
Each plane goes on multiple flights
Each flight is on a route
Routes connect two (served) cities
Each flight is staffed by 2 pilots
Each flight is staffed by one or no air marshalls
Each flight has one or more members of a cabin crew
Passengers purchase one or more tickets for flights
Tickets are for one flight. (A flight with one stop is two flights)

Reference no: EM13753886

Questions Cloud

Innovation and change and project management : How is Innovation and change and Project Management linked?

Why was st thomas more executed : Why was st. Thomas More executed?

Advising the clambake company on their future is : Write a one-page (250-word) paper advising the Clambake Company on their future IS. Be sure to discuss the advantages and disadvantages and your rationale for the system you recommend

How can renaissance be seen as a continuation of middle ages : How can the Renaissance be seen as a continuation of the Middle Ages?

Develop an erm and eerm : Develop an ERM and EERM for the following case study. Include: Entities (incluing names), Relationships (including names), An airline has multiple planes, Each plane goes on multiple flights

Whole sale cost of a roll : Number of rolls of Supertrex sold = 20 x Dollars spent on advertising + 6.8 x Dollars spent on in-store displays + 12 x Dollars invested in on-hand wallpaper inventory - $65.000 x marke-up taken above whole sale cost of a roll.

How the peer group and culture influence child development : Explain how the peer group and culture influence child development - "selection effect"

What the effectsof electronic health record on health care : What are the effectsof Electronic Health Record on health care

Discussion on an overview of financial management : In your judgment, what were the principal causes of the recent financial crisis and Great Recession? Would you include Government policies that encouraged housing purchases for those who could not afford them

User Account

All Pages