CREATE DATABASE [CARSDB]
GO

use [CARSDB]
GO

CREATE TABLE [dbo].[Customers] (
	[cuid] [int],
	[name] [char] (100),
	[age] [real],
	PRIMARY KEY (cuid) 
) 
GO

CREATE TABLE [dbo].[Cars] (
	[cid] [int],
	[color] [char] (100),
	[price] [real],
	PRIMARY KEY (cid) 
) 
GO


CREATE TABLE [dbo].[Reserves] (
	[cuid] [int],
	[cid] [int],
	[day] [datetime], 
	FOREIGN KEY (cuid) REFERENCES Customers,
	FOREIGN KEY (cid) REFERENCES Cars
) 
GO



INSERT INTO Customers
VALUES (10,'John', 18)
GO


INSERT INTO Customers
VALUES (15,'Bob', 22)
GO


INSERT INTO Customers
VALUES (11,'George', 25)
GO


INSERT INTO Customers
VALUES (13,'Andy', 25)
GO


INSERT INTO Customers
VALUES (12,'Ken', 32)
GO


INSERT INTO Customers
VALUES (19,'Paul', 35)
GO



INSERT INTO Customers
VALUES (14,'Bob', 35)
GO


INSERT INTO Customers
VALUES (16,'Chris', 44)
GO

INSERT INTO Customers
VALUES (17,'Andy', 18)
GO

INSERT INTO Customers
VALUES (18,'David', 18)
GO




INSERT INTO Cars
VALUES (1, 'white', 150)
GO


INSERT INTO Cars
VALUES (6, 'white', 200)
GO

INSERT INTO Cars
VALUES (2, 'red', 180)
GO

INSERT INTO Cars
VALUES (3, 'green', 250)
GO


INSERT INTO Cars
VALUES (4, 'blue', 600)
GO


INSERT INTO Cars
VALUES (5, 'blue', 750)
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