Relational database
Not what you're looking for?
Describe how the following information about airlines, flights (for a particular day), and passengers would be represented in a relational database:
Airlines: Clear Sky, Long Hop, and Tree Top
Flights for Clear Sky: CS205, CS37, CS 102
Flights for Long Hop: LH67, LH89
Flights for Tree Top: TT331, TT809
Smith has reservations on CS205 (seat 12b), CS37(seat 18c), and LH(seat 14b)
Baker has reservations on CS37 (seat18b), and LH89 (seat 14b)
Clark has reservations on LH67 (seat 5a), and TT331 (seat 4b)
Purchase this Solution
Solution Summary
The expert describes how information about airlines, flights and passengers would be represented in a relational database.
Solution Preview
We need to build three tables in a relational database.
1. Airline (AID, AName), AID is the primary key of the table
Here is the content of the table.
AID AName
-----------------
CS Clear Sky
LH Long Hop
TT ...
Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
C++ Operators
This quiz tests a student's knowledge about C++ operators.