CREATE DATABASE [FLIGHTSDB]
GO

use [FLIGHTSDB]
GO

CREATE TABLE [dbo].[Flights] (
	[flno] [int],
	[fr] [char] (100),
	[dest] [char] (100),
	[distance] [real],
	[departs] [datetime],
	[arrives] [datetime],
	[price] [real],
	PRIMARY KEY (flno) 
) 
GO

CREATE TABLE [dbo].[Aircrafts] (
	[aid] [int],
	[type] [char] (100),
	[cruising_range] [real],
	PRIMARY KEY (aid) 
) 
GO

CREATE TABLE [dbo].[Employees] (
	[eid] [int],
	[name] [char] (100),
	[salary] [real],
	PRIMARY KEY (eid) 
) 
GO


CREATE TABLE [dbo].[Certified] (
	[eid] [int],
	[aid] [int],
	FOREIGN KEY (eid) REFERENCES Employees,
	FOREIGN KEY (aid) REFERENCES Aircrafts
) 
GO


INSERT INTO Flights
VALUES (1,'Thessaloniki', 'Sydney', 15446, '2012-05-08 12:35:29', '2012-05-09 10:35:29', 3000)
GO

INSERT INTO Flights
VALUES (2,'Thessaloniki', 'Madrid', 2500, '2012-05-09 09:35:29', '2012-05-09 13:00:29', 350)
GO

INSERT INTO Flights
VALUES (3,'Thessaloniki', 'London', 2200, '2012-06-08 08:35:29', '2012-06-08 11:35:29', 300)
GO

INSERT INTO Flights
VALUES (4,'Thessaloniki', 'Paris', 1857, '2012-03-02 13:35:29', '2012-03-02 15:30:29', 200)
GO

INSERT INTO Flights
VALUES (5,'Athens', 'Milano', 911, '2012-03-02 13:35:29', '2012-03-02 14:35:29', 100)
GO

INSERT INTO Flights
VALUES (6,'Athens', 'Rome', 1051, '2012-05-06 16:35:29', '2012-05-06 18:00:29', 150)
GO

INSERT INTO Flights
VALUES (7,'Athens', 'Berlin', 1200, '2012-05-06 16:35:29', '2012-05-06 18:20:29', 170)
GO

INSERT INTO Flights
VALUES (8,'Heraklion', 'Amsterdam', 2500, '2012-03-03 10:35:29', '2012-03-03 14:00:29', 350)
GO

INSERT INTO Flights
VALUES (9,'Heraklion', 'Lisbon', 1890, '2012-03-03 10:35:29', '2012-03-03 13:00:29', 210)
GO

INSERT INTO Flights
VALUES (10,'Thessaloniki', 'Sydney', 15446, '2012-03-05 15:35:29', '2012-03-06 18:35:29', 2800)
GO

------------------------------------------------------

INSERT INTO Aircrafts
VALUES (1,'Boeing', 2800)
GO

INSERT INTO Aircrafts
VALUES (2,'ATR', 1500)
GO

INSERT INTO Aircrafts
VALUES (3,'Airbus', 2600)
GO

INSERT INTO Aircrafts
VALUES (4,'BAE', 900)
GO

INSERT INTO Aircrafts
VALUES (5,'Airbus', 1200)
GO

INSERT INTO Aircrafts
VALUES (6,'BAE', 1000)
GO

------------------------------------------------------

INSERT INTO Employees
VALUES (1,'John', 2000)
GO

INSERT INTO Employees
VALUES (2,'Richard', 3500)
GO

INSERT INTO Employees
VALUES (3,'Chris', 1800)
GO

INSERT INTO Employees
VALUES (4,'George', 1500)
GO

INSERT INTO Employees
VALUES (5,'Judy', 2900)
GO



INSERT INTO Employees
VALUES (6,'Casper', 800)
GO

INSERT INTO Employees
VALUES (7,'Jack', 3200)
GO

INSERT INTO Employees
VALUES (8,'Tom', 750)
GO

------------------------------------------------------

INSERT INTO Certified
VALUES (1,1)
GO

INSERT INTO Certified
VALUES (1,2)
GO

INSERT INTO Certified
VALUES (1,3)
GO

INSERT INTO Certified
VALUES (1,4)
GO

INSERT INTO Certified
VALUES (5,1)
GO

INSERT INTO Certified
VALUES (5,3)
GO

INSERT INTO Certified
VALUES (5,6)
GO

INSERT INTO Certified
VALUES (2,1)
GO

INSERT INTO Certified
VALUES (2,4)
GO


INSERT INTO Certified
VALUES (3,1)
GO

INSERT INTO Certified
VALUES (3,2)
GO

INSERT INTO Certified
VALUES (4,5)
GO

INSERT INTO Certified
VALUES (4,6)
GO