User Account

All Pages

Draw the er diagram above scenario by illustrating the

Assignment Help Database Management System
Reference no: EM13529979

Consider the following requirements for an airline ticketsbooking system. The system is composed of manyairlines. Each airline is identified by a code, name and headquarter’s address. An airline has different mileprograms, identified by a type- code, description, andstarting date. The different types of flights offered by anairline have a unique number, day of theweek, departure time, arrivaltime, origin, destination, andstops (if applicable). Passengers are allocated intoflights and are identified by a number, name, address, sex and age.A passenger can subscribe for one mile program of a certainairline. The system records information about the passengers bookedin a flight, together with the date, seat, pilot-name, andcrewmembers of that flight. The system also maintains informationabout the miles accumulated by each passenger in a certain flight.This information is kept as a mile-order identified by a number,quantity and date. The booking can be done through a travel agency,identified by a code, name, address, contact person, and phonenumber. For each passenger in a flight a menu is served. Thedifferent menu options have a code and a respective description.The menu can be of type vegetarian, low fat, and kosher. For eachvegetarian and low fat menu, information about the protein leveland Kcal, respectively, of the meal is recorded. Each kosher mealhas to be approved by the kosher community.

a.Draw the ER diagram above scenario by illustrating the attributesof the entities andrelationships.     

b.Draw a star schema for the above ER diagram scenario and mentionall facts necessary to calculate for the analysis of the company.      

Reference no: EM13529979

Questions Cloud

Describe with the aid of diagrams explaining why and when : Describe with the aid of diagrams explaining why and when boundary layer separation occurs. c)Describe some methods to prevent boundary layer separation
Convert a stress of 4500 newtons per square millimeter : Convert a stress of 4500 Newtons per square millimeter to kipsper square foot. Use complete and utterly perfect unit analysismethods. Do one one calculation line.
Why fine pearlite is harder and stronger than coarse : Briefly describe the simplest heat treatment procedure thatwould be used in converting a 0.76 wt% C steel from onemicrostructure to the other, as follows:
How wouldyou accomplish this task : Suppose you arethe operations manager of a manufacturingconcern. You are directedto expand the capacity of your plant owing to increasing demand. How wouldyou accomplish this task?
Draw the er diagram above scenario by illustrating the : Consider the following requirements for an airline ticketsbooking system. The system is composed of manyairlines. Each airline is identified by a code, name and headquarter’s address. An airline has different mileprograms, identified by a type- code,..
The secondpicture is the exact same thing but horizontal : The system shown consists of a member which is built in to rigidfoundations at both ends. It is unstrained in the horizontalposition. But then it is put in an upright position, and hence issubject to gravity. Find the stress and strain as a function ..
Suppose the bar is built in at the bottom and a mass of : A vertical bar is known to have dimensions 100" by 1" by 4" priorto application of a load, to have elastic modulus equal to107 psi, and to have a Poisson's ratio equal to 0.3.Suppose the bar is built in at the bottom and a mass of unknownweight is mo..
Compute the distance r as measured up the incline : A projectile is launched with an initial speed of 200m/s at anangle of 60degree with respect to the horizontal. compute thedistance "R" as measured up the incline.
What is the distribution reinforcement percentage of area : What is the Distribution reinforcement percentage of area ? Hot to take it for the calculation of distribution reinforcement in dog-legged stair case.

Reviews

Write a Review

Database Management System Questions & Answers

  Describe what the role of the database administrator is and

discuss what the role of the database administrator is and why it is such an important role in the company. do we

  Draw the er diagram for the database described above

Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game

  Suppose that you are the database developer for a local

suppose that you are the database developer for a local college. the chief information officer cio has asked you to

  Explain techniques for distributed data placement

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length.

  1 create a new database named membership2 write the create

1 . create a new database named membership.2. write the create table statements needed to implement the following

  What are the candidate keys of r

Compute the closure sets of R - find all non-trivial dependencies and what are the candidate keys of R?

  Number of leaf-level blocks needed if blocks are full

What is the order P of the B+-tree if B+-tree access structure on the key is constructed? What is the number of leaf-level blocks needed if blocks are approximately 69% full (round up for convenience)?

  Write the sql code that will save the changes

Write the SQL code to delete the row for William Smithfield and write the SQL code that will save the changes

  Give an example of a view on emp that would be impossible to

Give an example of a view on Emp that would be impossible to update (auto- atically) and explain why your example presents theupdate problem that it does.

  Describe the structures and indexes that you

You subsequently realize that updates to these relations are frequent. Because indexes incur a high overhead, can you think of a way to improve performance on these queries without using indexes?

  Physical design and implementation it requires the use of a

physical design and implementation it requires the use of a relational database management system. strayer university

  Create a struct data structure for each file contained

Write a password protected console-based application, which enables you to create user accounts and specify the name of the file or directory to be shared with other users.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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