Skip to content

Instantly share code, notes, and snippets.

@RyanRosario
Last active January 21, 2024 20:06
Show Gist options
  • Save RyanRosario/ecd6468946c42eb89736accc0cd4e30c to your computer and use it in GitHub Desktop.
Save RyanRosario/ecd6468946c42eb89736accc0cd4e30c to your computer and use it in GitHub Desktop.
group: cs143hw2
description[[ the data for this dataset was generated using {'<'}http://www.generatedata.com/>
* the relation _flights_ contains basic information about Southwest flights.
* the relation _aircraft_ contains information about Southwest aircraft, including those acquired from Airtran.
* the relation _airtran_aircraft_ contains information about aircraft that Southwest acquired from Airtran.
]]
flights = {
from to flightnum departure tail
LAX SFO 181 8 N8751R
LAX SJC 185 9 N705SW
SJC LAX 186 10 N404WN
BUR SJC 191 11 N957WN
LAX ATL 993 12 N7851A
MCO CUN 991 13 N7827A
SJC BUR 192 14 N709SW
SFO LAX 182 15 N8751R
SJC DAL 94 16 N705SW
SJC PHX 99 17 N957WN
}
aircraft = {
tail type
N404WN B73G
N705SW B73G
N709SW B73G
N8751R B38M
N7851A B73G
N7827A B73G
N7854B B73G
N7826B B73G
N957WN B738
}
airtran_aircraft = {
tail type
N7851A B73G
N7827A B73G
N7854B B73G
N7826B B73G
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment