SQL

SQL - Structured query language.

Creating and Using a Database

CREATE DATABASE database_name;
USE travel;

• CREATE DATABASE: Creates a new database.
• USE: Selects the database to work with.

Creating Tabels

CREATE TABLE planes (

num INTEGER PRIMARY KEY,

country_start VARCHAR(25), 

country_arrival VARCHAR(25)

);

• planes table stores flight routes.
• num is the unique identifier (Primary Key).
• country_start and country_arrival represent the departure and arrival countries.

CREATE TABLE ftypes (

num INTEGER PRIMARY KEY,

flight_type CHAR(25),

food_on_plane CHAR(25),

plane_num INTEGER,

FOREIGN KEY (plane_num) REFERENCES planes(num)

);

• ftypes table stores flight types (e.g. Direct, 1 stop).
• plane_num is a foreign key linking to planes.num.