Create the fact and dimension tables described in the attached Table Specifications Document. Note that you must make your table names, data types, and foreign key relationships match these specifications exactly. You must save and submit the Data Definition Language (DDL) statements needed to create each table

  

Transcribed Image Text:

Dim_Airlines AirlineId AirlineName Callsign Active Fact Routes AirlineId x poo Source Airportid DestAirportId Codeshare Stops Dim_ Airports AirportId AirportName City Country LatLong Altitude Timezone xox Dim_Airlines AirlineId AirlineName Callsign Active Fact Routes AirlineId x poo Source Airportid DestAirportId Codeshare Stops Dim_ Airports AirportId AirportName City Country LatLong Altitude Timezone xox

Answer rating: 100% (QA)

Tables can be created using CREATE STATEMENT as follows 1 ... View the full answer