The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 406 Weeks Ago, 6 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
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, and CS102
Flights for Long Hop: LH67 and LH89
Flights for Tree Top: TT331 and TT809
Smith has reservations on CS205 (seat 12B),
CS37 (seat 18C), and LH 89 (seat 14A).
Baker has reservations on CS37 (seat 18B) and
LH89 (seat 14B).
Clark has reservations on LH67 (seat 5A) and
TT331 (seat 4B).
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll