CREATE TABLE cars
        (Registration CHAR(7) primary key ,
        Model_name CHAR(8),
        Car_group_name CHAR(2),
        Date_bought DATE,
        Cost NUMBER,
        Miles_to_date NUMBER,
        Miles_last_service NUMBER,
        Status CHAR(1));

CREATE TABLE cargroups
        (car_group_name CHAR(2) primary key,
        Rate_per_mile NUMBER,
        Rate_per_day NUMBER);

CREATE TABLE models
        (Model_name CHAR(8) primary key,
        Car_group_name CHAR(2),
        Description CHAR(30),
        Maint_int NUMBER);

CREATE TABLE customers
        (Cust_no NUMBER primary key,
        Cust_name CHAR(20),
        Address CHAR(20),
        Town CHAR(20),
        County CHAR(20),
        Post_code CHAR(10),
        Contact CHAR(20),
        Pay_method CHAR(1));

CREATE TABLE bookings
        (Booking_no NUMBER primary key,
        Cust_no NUMBER,
        Date_reserved DATE,
        Reserved_by CHAR(12),
        Date_rent_start DATE,
        Rental_period NUMBER,
        Registration CHAR(7),
        Model_name CHAR(8),
        Miles_out NUMBER,
        Miles_in NUMBER,
        Amount_due NUMBER,
        Paid CHAR(1));


INSERT INTO cars VALUES
        ('H266MHU','ASTON V8','A1','01-APR-91',63000,2597,1000,'A');
INSERT INTO cars VALUES
        ('G899VDU','BMW 635','B2','23-OCT-89',45500.3,18675,12667,'A');
INSERT INTO cars VALUES
        ('G123RMR','BMW 750','B3','16-NOV-89',56829,42400,25366,'A');
INSERT INTO cars VALUES
        ('E246WFC','RR SSPIR','B4','06-JAN-88',84500,52861,48253,'H');
INSERT INTO cars VALUES
        ('G994PBR','FERR TR','A4','31-MAR-90',102450,10662,6004,'A');
INSERT INTO cars VALUES
        ('H626RPG','JAG XJS','A2','26-SEP-90',32650.3,14533,12769,'A');
INSERT INTO cars VALUES
        ('G551JBA','JAG XJ6','A3','02-SEP-89',45500,13788,11950,'A');
INSERT INTO cars VALUES
        ('H203PBR','LAMB COU','A4','10-NOV-90',130250,7025,903,'H');
INSERT INTO cars VALUES
        ('F651DEK','RR SSPIR','B4','10-JAN-89',92500,29610,24460,'A');
INSERT INTO cars VALUES
        ('H311MHG','MERC 560','B3','09-NOV-90',60800,12450,11832,'A');
INSERT INTO cars VALUES
        ('F111ENT','P911 TC','A3','03-SEP-88',75200,30286,24502,'A');
INSERT INTO cars VALUES
        ('G202XRP','P944 T','A3','14-FEB-89',48350,28604,23666,'A');
INSERT INTO cars VALUES
        ('J516BTA','P944 T','A3','02-SEP-91',50301,1502,NULL,'A');
INSERT INTO cars VALUES
        ('H935CSA','FERR TR','A4','23-JUN-91',105600,3005,998,'H');
INSERT INTO cars VALUES
        ('J706BEG','JAG XJ6','A3','16-SEP-91',39250.5,2110,1132,'H');
INSERT INTO cars VALUES
        ('H875DES','BMW 750','B3','08-APR-91',58321,8354,973,'A');
INSERT INTO cars VALUES
        ('H235BMA','LAMB COU','A4','10-NOV-90',130250,9611,1156,'H');
INSERT INTO cars VALUES
        ('J185NED','P911 TC','A3','15-OCT-91',78350,875,NULL,'A');
INSERT INTO cars VALUES
        ('J644TNR','MERC 560','B3','10-OCT-91',65800,1821,1201,'H');
INSERT INTO cars VALUES
        ('J933RCE','FERR TR','A4','30-OCT-91',111200,957,NULL,'A');

INSERT INTO cargroups VALUES
        ('A1',110,25);
INSERT INTO cargroups VALUES
        ('A2',115,24.5);
INSERT INTO cargroups VALUES
        ('A3',155,36.75);
INSERT INTO cargroups VALUES
        ('A4',125,33.5);
INSERT INTO cargroups VALUES
        ('B1',110,25.9);
INSERT INTO cargroups VALUES
        ('B2',125,33);
INSERT INTO cargroups VALUES
        ('B3',135,37.75);
INSERT INTO cargroups VALUES
        ('B4',135,38.5);

INSERT INTO models VALUES
        ('ASTON V8','A1','ASTON MARTIN V8 VANTAGE',10000);
INSERT INTO models VALUES
        ('BMW 635','B2','BMW 635 csi',12000);
INSERT INTO models VALUES
        ('BMW 750','B3','BMW 750',12000);
INSERT INTO models VALUES
        ('FERR TR','A4','Ferrari Testarossa',10000);
INSERT INTO models VALUES
        ('JAG XJS','A2','Jaguar XJS V12 5.2l',15000);
INSERT INTO models VALUES
        ('JAG XJ6','A3','Jaguar XJ6 V12 Sovereign',15000);
INSERT INTO models VALUES
        ('LAMB COU','A4','Lamborghini Countach',6000);
INSERT INTO models VALUES
        ('MERC 560','B3','Mercedes 560 SEL',24000);
INSERT INTO models VALUES
        ('P911 TC','A3','Porsche 911 TC Cabriolet',12000);
INSERT INTO models VALUES
        ('P944 T','A3','Porsche 944 Turbo',12000);
INSERT INTO models VALUES
        ('RR SSPIR','B4','Rolls Royce Silver Spirit',6000);

INSERT INTO customers VALUES
        (2338,'PETER BOGDANOVICH','52 LONG DEAN','WINDSOR','BERKS',
        'SL14 6TQ','Peter Bogdanovich','A');
INSERT INTO customers VALUES
        (8979,'J PARSONS LTD','PARSONS PLAZA','WEYBRIDGE','SURREY',
        'KT12 8PP','Paul Bentley','A');
INSERT INTO customers VALUES
        (2804,'FOCUST MARKETING LTD','555 SLOUGH ROAD','WOKINGHAM','BERKS',
        'RG23 1JK','Jeanna Polly','C');
INSERT INTO customers VALUES
        (2267,'WORTHINGTON  CO','16 LENANT ST','LONDON',NULL,
        'SE1 5SF','David Worthington','A');
INSERT INTO customers VALUES
        (1086,'ADT LTD','BUMPERS IND EST','CHIPPENHAM','WILTS',
        'SN14 6LH','James Nugent','C');
INSERT INTO customers VALUES
        (1553,'EYRIE BOOKS LTD','2 ST JOHNS AVE','LONDON',NULL,
        'NW3 6TQ','Alisdair Aird','A');
INSERT INTO customers VALUES
        (1452,'STEVEN BEARE','NETTLETON HOUSE','CASTLE COMBE','WILTSHIRE',
        'SN13 7NJ','Steven Beare','C');
INSERT INTO customers VALUES
        (2029,'SQL STARS LTD','10 PENN LEA ROAD','BATH','AVON',
        'BA2 5MX','Stan Blethyn','A');
INSERT INTO customers VALUES
        (667,'G G WHITTAKER  CO','WHEATLEY ROAD','DONCASTER','YORKSHIRE',
        'DN5 8AA','Chris Whittaker','A');
INSERT INTO customers VALUES
        (701,'MCGHIE ENTERPRISES','CAMPFIELD ROAD','BASINGSTOKE','HANTS',
        'BK10 1BC','Bob McGhie','C');
INSERT INTO customers VALUES
        (734,'CARL PETROV LTD','62 CADOGAN AVE','BRISTOL','AVON',
        'BS1 6TQ','Jim Slattery','A');
INSERT INTO customers VALUES
        (668,'THRINGS AND CO','MOUNTEBANK HOUSE','BASINGSTOKE','HANTS',
        'RG22 1EL','Brian Jones','A');
INSERT INTO customers VALUES
        (8981,'CARDINAL CARDS LTD','56 LOWER REGENT ST','LONDON',NULL,
        'W1A 8TW','Linden Boyne','A');


INSERT INTO bookings VALUES
        (502,1553,'29-NOV-90','JANE B','20-DEC-90',15,
        'G123RMR','BMW 750',500,3045,4002,'N');
INSERT INTO bookings VALUES
        (118,8979,'23-JAN-91','JANE B','23-JAN-91',4,
        'H626RPG','JAG XJS',800,1692,1123.8,'N');
INSERT INTO bookings VALUES
        (265,2029,'09-APR-91','ERIC','04-MAY-91',16,
        'E246WFC','RR SSPIR',35262,35818,1366.6,'N');
INSERT INTO bookings VALUES
        (503,2267,'12-APR-91','ERIC','26-APR-91',5,
        'H203PBR','LAMB COU',3521,3862,593.75,'Y');
INSERT INTO bookings VALUES
        (504,1553,'12-APR-91','JANE H','12-APR-91',1,
        'G551JBA','JAG XJ6',9527,9811,476.95,'N');
INSERT INTO bookings VALUES
        (586,667,'13-APR-91','JANE B','26-APR-91',21,
        'F111ENT','P911 TC',25967,26818,2090.8,'Y');
INSERT INTO bookings VALUES
        (810,1452,'03-SEP-91','ERIC','10-SEP-91',3,
        'J516BTA','P944 T',103,767,1139.45,'Y');
INSERT INTO bookings VALUES
        (811,701,'04-SEP-91','JANE H','05-SEP-91',8,
        'G202XRP','P944 T',26197,26833,1279.8,'N');
INSERT INTO bookings VALUES
        (812,2338,'04-SEP-91','ERIC','15-OCT-91',15,
        'J644TNR','MERC 560',119,1535,2477.85,'N');
INSERT INTO bookings VALUES
        (813,2804,'04-SEP-91','JANE H','08-SEP-91',1,
        'H235BMA','LAMB COU',7899,8054,227.25,'Y');
INSERT INTO bookings VALUES
        (999,123,'13-JUN-91',NULL,'13-JUN-91',7,
        'H286MHU','ASTON V8',NULL,NULL,NULL,NULL);
INSERT INTO bookings VALUES
        (2122,734,'21-SEP-91',NULL,'21-SEP-91',1,
        'G994PBR','FERR TR',NULL,NULL,NULL,NULL);
INSERT INTO bookings VALUES
        (599,667,'21-DEC-91',NULL,'01-JAN-92',3,
        'H311MHG','MERC 560',NULL,NULL,NULL,NULL);
INSERT INTO bookings VALUES
        (2123,667,'8-SEP-91',NULL,'19-SEP-91',5,
        'H935CSA','FERR TR',23774,25865,501.8,'N');
INSERT INTO bookings VALUES
        (2124,667,'18-SEP-91',NULL,'19-SEP-91',5,
        'G123RMR','BMW 750',61554,72334,1023,'N');
INSERT INTO bookings VALUES
        (2125,668,'02-OCT-91',NULL,'02-OCT-91',2,
        'G551JBA','JAG XJ6',1098,882,100,'Y');
INSERT INTO bookings VALUES
        (2126,667,'02-OCT-91',NULL,'02-OCT-91',10,
        'H266MHU','ASTON V8',5583,6254,873.6,'N');
INSERT INTO bookings VALUES
        (2127,668,'01-OCT-91',NULL,'01-OCT-91',1,
        'J644TNR','MERC 560',8891,9024,106,'N');
INSERT INTO bookings VALUES
        (2128,701,'13-APR-91',NULL,'14-APR-91',10,
        'H235BMA','LAMB COU',44512,45277,512,'N');