CREATE DATABASE [SailorsDB]
GO

use [SailorsDB]
GO

CREATE TABLE [dbo].[Sailors] (
	[sid] [int],
	[sname] [char] (100),
	[rating] [int],
	[age] [real],
	PRIMARY KEY (sid) 
) 
GO

CREATE TABLE [dbo].[Boats] (
	[bid] [int],
	[bname] [char] (100),
	[color] [char] (100),
	PRIMARY KEY (bid) 
) 
GO


CREATE TABLE [dbo].[Reserves] (
	[sid] [int],
	[bid] [int],
	[day] [datetime], 
	FOREIGN KEY (sid) REFERENCES Sailors,
	FOREIGN KEY (bid) REFERENCES Boats
) 
GO


--λευκό αλλά όχι γαλάζιο κάτω των 35 
-->2 καράβια
INSERT INTO Sailors
VALUES (10,'John', 7, 17)
GO

--όχι λευκό
-->2 καράβια
INSERT INTO Sailors
VALUES (15,'Bob', 7, 22)
GO


INSERT INTO Sailors
VALUES (11,'George', 8, 25)
GO


INSERT INTO Sailors
VALUES (13,'Andy', 8, 25)
GO

--και λευκό και γαλάζιο άνω των 35 
-->2 καράβια
INSERT INTO Sailors
VALUES (12,'Ken', 9, 32)
GO


INSERT INTO Sailors
VALUES (19,'Paul', 9, 35)
GO



INSERT INTO Sailors
VALUES (14,'Bob', 5, 35)
GO

--άνω των 30 
--1 καράβι
INSERT INTO Sailors
VALUES (16,'Chris', 5, 44)
GO

INSERT INTO Sailors
VALUES (17,'Andy', 5, 16)
GO

INSERT INTO Sailors
VALUES (18,'David', 5, 17)
GO




INSERT INTO Boats
VALUES (1,'Interlake', 'white')
GO

--μία μόνο κράτηση
INSERT INTO Boats
VALUES (6,'Sea_gull', 'white')
GO

INSERT INTO Boats
VALUES (2,'Ocean', 'red')
GO

INSERT INTO Boats
VALUES (3,'Interlake', 'green')
GO

--δύο κρατήσεις
INSERT INTO Boats
VALUES (4,'Marine', 'blue')
GO

--μία μόνο κράτηση
INSERT INTO Boats
VALUES (5,'Sea', 'blue')
GO





INSERT INTO Reserves
VALUES (12, 1, '10/07/2010')
GO

INSERT INTO Reserves
VALUES (12, 4, '07/03/2009')
GO


INSERT INTO Reserves
VALUES (12, 2, '07/13/2006')
GO

INSERT INTO Reserves
VALUES (12, 3, '05/23/2007')
GO



INSERT INTO Reserves
VALUES (10, 1, '10/17/2010')
GO

INSERT INTO Reserves
VALUES (10, 6, '05/28/2006')
GO


INSERT INTO Reserves
VALUES (10, 2, '07/19/2005')
GO

INSERT INTO Reserves
VALUES (10, 3, '05/23/2004')
GO




INSERT INTO Reserves
VALUES (15, 5, '05/21/2008')
GO


INSERT INTO Reserves
VALUES (15, 2, '11/01/2006')
GO

INSERT INTO Reserves
VALUES (15, 3, '03/05/2010')
GO


INSERT INTO Reserves
VALUES (16, 4, '02/15/2008')
GO



INSERT INTO Reserves
VALUES (11, 3, '08/05/2010')
GO

INSERT INTO Reserves
VALUES (11, 4, '02/05/2010')
GO


INSERT INTO Reserves
VALUES (11, 1, '04/01/2009')
GO



INSERT INTO Reserves
VALUES (13, 2, '02/15/2009')
GO

INSERT INTO Reserves
VALUES (13, 1, '12/11/2010')
GO



INSERT INTO Reserves
VALUES (19, 3, '03/01/2010')
GO


INSERT INTO Reserves
VALUES (19, 2, '01/07/2009')
GO


INSERT INTO Reserves
VALUES (19, 4, '03/01/2008')
GO


INSERT INTO Reserves
VALUES (14, 3, '02/15/2006')
GO



INSERT INTO Reserves
VALUES (17, 1, '03/01/2010')
GO


INSERT INTO Reserves
VALUES (17, 3, '12/01/2007')
GO


--INSERT INTO Reserves
--VALUES (18, 3, '11/01/2003')
--GO


--INSERT INTO Reserves
--VALUES (18, 4, '09/15/2004')
--GO