Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Describe how the following information about airlines, flights (for a particular

ID: 3712442 • Letter: D

Question

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 Hop 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)

Explanation / Answer

information about airlines, flights (for a particular day), and passengers would be represented in a relation database: