Design a database for an airline. The database must keep track of customers and their reservations, flights

Question:

Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights.

Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database System Concepts

ISBN: 9780078022159

7th Edition

Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan

See More Books

Question Posted: Jun 13, 2022 07:42 AM

See More Questions

Design a database for an automobile company to provide to its dealers to assist The minmaintaining customer records and dealer inventory and to assist sales staff in ordering CMS. Each vehicle is...
Design a database for a world-wide package delivery company (e.g., DHL or FedEX). The database must be able to keep track of customers (who ship items) and customers (who receive items): some...
Design a database for your model. Your design should include a specification of tables and attributes as well as primary, candidate, and foreign keys. Also specify how you will enforce minimum...
In Exercises evaluate the second derivative of the function at the given point. Use a computer algebra system to verify your result. (x) = cos x, (0, 1)
Suppose you know that the distribution of sample proportions of women employees is normal with a mean of 0.42 and a standard deviation of 0.21. Suppose you select a random sample of employees and...
Describe evidence from the rock record that supports continental drift.
Estimate the energy that a runner expends to overcome aerodynamic drag while running a complete marathon race. This expenditure of energy is equivalent to climbing a hill of what height? List all...
For the past several years, Derrick Epstein has operated a part-time consulting business from his home. As of June 1, 2008, Derrick decided to move to rented quarters and to operate the business,...
What critical assumptions has TESLA made to value inventory? Does TESLA use FIFO or LIFO? Explain what is LCM (the lower of cost or market) and how this may impact inventory every year. Cost of...
Thirty percent of all people who are inoculated with the current vaccine that is used to prevent a disease contract the disease within a year. The developer of a new vaccine that is intended to...
Using the functional dependencies of Exercise 7.6, compute the canonical cover Fc. Exercise 7.6 Compute the closure of the following set F of functional dependencies for relation schema R = (A, B, C,...
Consider two entity sets A and B that both have the attribute X a. If the two Xs are completely unrelated, how should the design be improved? b. If the two Xs represent the same property and it is...
For each of the following sequences: (i) Describe the term-to-term rule. (ii) Write down the next two terms of the sequence. (iii) Calculate the tenth term. a. 2 4 6 8 10 b. 1 3 5 7 9 c. 4 7 10 13 16...
Identity three ways in which the systems approach to diversity and cultural competence in an individual health care organization contributes to improved outcomes. Notes: System approach to culture...
Waterway Company's Assembly Department has materials cost of $3 per unit and conversion cost of $3 per unit. There are 19000 units in ending work in process inventory which are 80% complete as to...
Using Solidworks, make a 3D solid model of the part shown below. 2x 8mm- 45 13 -80- 2x 09- METRIC -27- 30 R$4 -$32 15 CRS I REQD
Come up with a list of questions that you can ask your customers to understand their preferences in financial products. Be specific in your questions. Make sure to create both open and closed-ended...
Please read the instructions carefully. The following questions are related to the following risky securities issued by: Sainsbury: J Sainsbury PLC (Reg. no: 00185647). The holding company whose...
Let C3 have the Euclidean inner product. Show that for all values of the variable Î¸, the vector has norm 1 and is orthogonal to both (1, i, 0) and (0, i, - i). -,-() 3
Consider a closed, rigid tank with a volume of 0.8L, filled with cold water initially at 27C. The tank is filled such that there are no voids (air pockets) within. The initial pressure within the...
Is our array-based implementation of merge-sort given in Section 12.1.2 stable? Explain why or why not.
Give a complete justification of Proposition 12.1.
Show that the nodes of any AVL tree T can be colored red and black so that T becomes a red-black tree.
BRAND SELF COLLATERAL What is your brand name? What is your logo (YOU MUST DESIGN IT What is your brand slogan (the phrase that defines your brand and yourself) What are celebrity spokesperson is...
Amidst the burgeoning complexity of contemporary business landscapes, how do advanced organizations employ sophisticated design principles and ergonomic considerations to optimize physical workspaces...
JavaScript Assignment 1: Personal Web site This assignment is linked to your final project. Thus far, you have completed a total of 4 sections as part of the Final Project. You have created a basic...

Design a database for an airline. The database must keep track of customers and their reservations, flights

Question:

Step by Step Answer:

Here is an example of database design for an airline ER Diagram Relational Schema The database will ...View the full answer

Database System Concepts

Students also viewed these Computer science questions