|
|
88-271 Homework #4 Sample Solution
Problem #1: 4 Tables and their corresponding SQL
SQL: CREATE TABLE Flight (ID INTEGER(8) PRIMARY KEY(ID))
| Flight Table |
| ID |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
SQL: CREATE TABLE FlightReservation (ID
INTEGER(8), fareCode VARCHAR(50) PRIMARY KEY(ID))
| FlightReservation Table |
| ID | fareCode |
| 1 | Coach |
| 2 | First |
| 3 | First |
| 4 | Business |
| 5 | Coach |
| 6 | Coach |
| 7 | Coach |
| 8 | Business |
SQL: CREATE TABLE TripReservation (ID INTEGER(8),
recordLocator DECIMAL(8) PRIMARY KEY(ID))
| TripReservation Table |
| ID | recordLocator |
| 1 | what |
| 2 | is |
| 3 | this? |
SQL: CREATE TABLE Ticket (ID
INTEGER(8), fare DECIMAL(8) PRIMARY KEY(ID))
| Ticket Table |
| ID | fare |
| 1 | 109.26 |
| 2 | 388.14 |
| 3 | 899.99 |
| 4 | 89.12 |
| 5 | 576.54 |
Problem #2: The Reserves Table
| Reserves Table |
| FlightID | FlightReservationID |
| 1 | 1 |
| 2 | 2 |
| 2 | 3 |
| 1 | 4 |
| 1 | 5 |
| 3 | 6 |
| 4 | 7 |
| 4 | 8 |
Problem #3: The TripReservation Table
This question is answered by the text of question #1.
|