//
// Ret-A-Car Data
//
// Matthew W. Coan (7:22 PM 12/8/2002)
//

INSERT INTO Employee VALUES (1, 'James', 'Patrick', 'Romer', '470 N. Lime Ct.', 'Frederick', 'MD', '21552', '357234792', 'Manager', 16.25, 1.99, '998', '21-FEB-70', 'Single', NULL);
INSERT INTO Employee VALUES (2, 'Jonas', 'Kurt', 'Brown', '18 Valley St.', 'Mt. Savege', 'MD', '21522', '352432721', 'Sales Person', 8.25, 0.99, '997', '12-MAR-65', 'Single', NULL);
INSERT INTO Employee VALUES (3, 'Sally', 'Jane', 'Jones', '1212 Oak St.', 'Frostburg', 'MD', '21532', '293492752', 'Sales Person', 8.25, 0.99, '994', '10-JAN-73', 'Single', NULL);
INSERT INTO Employee VALUES (4, 'Mary', 'Ann', 'Noble', '19 Peartree Ct.', 'Frostburg', 'MD', '21532', '217392989', 'Mechanic', 32.50, 0.99, '992', '28-DEC-59', 'Single', NULL);
INSERT INTO Employee VALUES (5, 'Robert', 'Lee', 'Nolan', '13 Asbury Ct.', 'LaVale', 'MD', '21533', '274539222', 'Secretary', 12.25, 0.99, '994', '22-NOV-88', 'Single', NULL);

INSERT INTO Branch VALUES (1, 'Cumberland Car Rental', '22 Riverview Ct.', 'Cumberland', 'MD', '21527', '301-599-7476', NULL, 1);
INSERT INTO Branch VALUES (2, 'Annapolis Car Rental', '17 West St.', 'Annapolis', 'MD', '21030', '401-991-7876', 1, 1);
INSERT INTO Branch VALUES (3, 'Frederick Car Rental', '3710 Patrick St.', 'Frederick', 'MD', '21411', '301-722-6910', 1, 1);
INSERT INTO Branch VALUES (4, 'Oakland Car Rental', '871 Sprue St.', 'Oakland', 'MD', '21744', '301-921-7641', 1, 1);
INSERT INTO Branch VALUES (5, 'Baltimore Car Rental', '22 Pratt St.', 'Baltimore', 'MD', '27110', '401-977-4210', 1, 1);

INSERT INTO BranchPhoneNumber VALUES (1, '123-212-3223');
INSERT INTO BranchPhoneNumber VALUES (2, '432-278-9870');
INSERT INTO BranchPhoneNumber VALUES (3, '401-443-3211');
INSERT INTO BranchPhoneNumber VALUES (4, '453-213-1464');
INSERT INTO BranchPhoneNumber VALUES (5, '543-211-4332');

INSERT INTO B_bpn VALUES (1, 1);
INSERT INTO B_bpn VALUES (1, 2);
INSERT INTO B_bpn VALUES (3, 3);
INSERT INTO B_bpn VALUES (4, 4);
INSERT INTO B_bpn VALUES (5, 5);

INSERT INTO OpenDay VALUES (1, 2);
INSERT INTO OpenDay VALUES (2, 4);
INSERT INTO OpenDay VALUES (3, 6);
INSERT INTO OpenDay VALUES (4, 3);
INSERT INTO OpenDay VALUES (5, 5);

INSERT INTO OpenHours VALUES (1, 8, 0, 18, 0);
INSERT INTO OpenHours VALUES (2, 8, 0, 18, 0);
INSERT INTO OpenHours VALUES (3, 8, 0, 18, 0);
INSERT INTO OpenHours VALUES (4, 8, 0, 20, 0);
INSERT INTO OpenHours VALUES (5, 8, 0, 20, 0);

INSERT INTO B_od VALUES (1, 1);
INSERT INTO B_od VALUES (1, 2);
INSERT INTO B_od VALUES (1, 3);
INSERT INTO B_od VALUES (1, 4);
INSERT INTO B_od VALUES (1, 5);

INSERT INTO Od_oh VALUES (1, 1);
INSERT INTO Od_oh VALUES (2, 2);
INSERT INTO Od_oh VALUES (3, 3);
INSERT INTO Od_oh VALUES (4, 4);
INSERT INTO Od_oh VALUES (5, 5);

INSERT INTO Certificate VALUES (1, 'AAA Mechanic', '22-MAR-99');
INSERT INTO Certificate VALUES (2, 'IEE Mechanic', '01-JAN-00');
INSERT INTO Certificate VALUES (3, 'ISO Mechanic', '03-JUN-01');
INSERT INTO Certificate VALUES (4, 'Sales Training', '15-DEC-02');
INSERT INTO Certificate VALUES (5, 'Retail Sales Training', '24-APR-00');

INSERT INTO Degree VALUES (1, 'BS in Math from JHU', '03-SEP-97');
INSERT INTO Degree VALUES (2, 'BS in Business from FSU', '24-JAN-99');
INSERT INTO Degree VALUES (3, 'MS in Math from JHU', '09-DEC-99');
INSERT INTO Degree VALUES (4, 'BA in English from LSU', '03-SEP-97');
INSERT INTO Degree VALUES (5, 'BA in Art from NYU', '03-SEP-97');

INSERT INTO Customer VALUES ('521429183', 'John', 'Rogers', 'S', '24-MAR-69',  '301-562-8033', '301-271-5231', '97 Circle Dr.', 'Oakland', 'MD', '27151', 'jrogers@aol.com', 'Y', 'R00988-8899-888899', '24-MAR-04', 'MD');
INSERT INTO Customer VALUES ('372925037', 'Albert', 'Franklin', 'S', '01-FEB-52',  '305-972-8311', '505-828-3541', '18 Fairwood Dr.', 'Frostburg', 'MD', '37122', 'afranklin@hotmail.com', 'Y', 'F598735-8235-090978', '21-SEP-04', 'MD');
INSERT INTO Customer VALUES ('239527154', 'Jacob', 'Swan', 'C', '09-MAY-66',  '301-527-9177', '301-822-1023', '4082 Cumberland St.', 'Bedford', 'PA', '35122', 'jswan@hotmail.com', 'Y', 'S598546-9833-123456', '22-MAY-03', 'PA');
INSERT INTO Customer VALUES ('353284327', 'Ellen', 'Curtain', 'M', '03-JUL-40', '301-972-9111', '301-729-6749', '499 N. Euclid St.', 'Cumberland', 'MD', '21542', 'ecurtain@bigfoot.com', 'N', 'C000987-3222-129999', '03-JAN-06', 'MD');
INSERT INTO Customer VALUES ('322285723', 'Joan', 'Winter', 'K', '09-DEC-76', '410-972-4853', '410-879-5025', '23 Ann Dr.', 'Frederick', 'MD', '21392', 'jwinter@hotmail.com', 'N', 'W030935-3237-089909', '05-JAN-06', 'MD');

INSERT INTO Account VALUES (1, 'John', 'Rogers', '97 Circle Dr.', 'Oakland', 'MD', '27151', '11-JUN-02', 126.89, 1200.00, 100.00, 0.33, 1.99);
INSERT INTO Account VALUES (2, 'Albert', 'Franklin', '18 Fairwood Dr.', 'Frostburg', 'MD', '37122', '14-MAY-01', 26.89, 1200.00, 100.00, 0.33, 1.99);
INSERT INTO Account VALUES (3, 'Jacob', 'Swan', '4082 Cumberland St.', 'Bedford', 'PA', '35122', '01-MAR-21', 34.99, 1200.00, 100.00, 0.33, 1.99);
INSERT INTO Account VALUES (4, 'Ellen', 'Curtain', '499 N. Euclid St.', 'Cumberland', 'MD', '21542', '30-APR-01', 411.89, 1200.00, 100.00, 0.33, 1.99);
INSERT INTO Account VALUES (5, 'Joan', 'Winter', '23 Ann Dr.', 'Frederick', 'MD', '21392', '05-SEP-00', 90.89, 500.00, 100.00, 0.33, 1.99);

INSERT INTO FrequentMileage VALUES (1, 162);
INSERT INTO FrequentMileage VALUES (2, 98);
INSERT INTO FrequentMileage VALUES (3, 1200);
INSERT INTO FrequentMileage VALUES (4, 1908);
INSERT INTO FrequentMileage VALUES (5, 400);

INSERT INTO Acc_fm VALUES (1, 1);
INSERT INTO Acc_fm VALUES (1, 2);
INSERT INTO Acc_fm VALUES (1, 3);
INSERT INTO Acc_fm VALUES (2, 4);
INSERT INTO Acc_fm VALUES (3, 5);

INSERT INTO CreditCard VALUES (1, '5105105105105100', '01-JAN-06', '44 Stoyer St.', 'Frostburg', 'MD', '21532');
INSERT INTO CreditCard VALUES (2, '7897845105123206', '01-APR-05', '88 Apple St.', 'New York', 'NY', '22012');
INSERT INTO CreditCard VALUES (3, '5105166323405530', '01-FEB-07', '99 Orage St.', 'Frederick', 'MD', '21587');
INSERT INTO CreditCard VALUES (4, '5105105105105100', '01-DEC-03', '904 Garlic Av.', 'Cumberland', 'MD', '21542');
INSERT INTO CreditCard VALUES (5, '5111235353532810', '01-MAR-05', '311 Veno Dr.', 'Bedford', 'PA', '35122');

INSERT INTO Acc_cc VALUES (1, 1);
INSERT INTO Acc_cc VALUES (2, 2);
INSERT INTO Acc_cc VALUES (3, 3);
INSERT INTO Acc_cc VALUES (4, 4);
INSERT INTO Acc_cc VALUES (5, 5);

INSERT INTO Mech_problems VALUES (1, 'Transmission failure');
INSERT INTO Mech_problems VALUES (2, 'Fuel pump failure');
INSERT INTO Mech_problems VALUES (3, 'Starter failure');
INSERT INTO Mech_problems VALUES (4, 'Radiator failure');
INSERT INTO Mech_problems VALUES (5, 'Faulty Carburator');

INSERT INTO Oil_change VALUES (1, '22 Riverview Ct.', 'Cumberland', 'MD', '21527', '01-NOV-02', 22000);
INSERT INTO Oil_change VALUES (2, '22 Riverview Ct.', 'Cumberland', 'MD', '21527', '11-OCT-02', 22087);
INSERT INTO Oil_change VALUES (3, '22 Riverview Ct.', 'Cumberland', 'MD', '21527', '01-OCT-02', 28003);
INSERT INTO Oil_change VALUES (4, '22 Riverview Ct.', 'Cumberland', 'MD', '21527', '27-JAN-02', 36307);
INSERT INTO Oil_change VALUES (5, '22 Riverview Ct.', 'Cumberland', 'MD', '21527', '26-FEB-02', 24740);

INSERT INTO Insurance VALUES (1, 25000, '02-MAR-03', 'Eastwood');
INSERT INTO Insurance VALUES (2, 35000, '03-JAN-03', 'All State');
INSERT INTO Insurance VALUES (3, 45000, '12-DEC-03', 'All State');
INSERT INTO Insurance VALUES (4, 75000, '01-FEB-04', 'Eastwood');
INSERT INTO Insurance VALUES (5, 15000, '02-MAR-03', 'State Farm');

INSERT INTO Vehicle VALUES (1, '515-N2J', 'MD', 1999, 30656, 'Compact', '2 dors', 'NISSAN Sentra', 'Beige', 22650.00, 1, 1800.00, 2500.00, 35000.00, 1);
INSERT INTO Vehicle VALUES (2, '3P0431', 'MD', 2000, 22758, 'Luxury', '4 dors', 'Infiniti', 'White', 46720.00, 2, 1200.00, 6500.00, 45000.00, 2);
INSERT INTO Vehicle VALUES (3, '68-MT5', 'MD', 2000, 23408, 'Economy', '4 dors', 'Honda Accord', 'White', 28400.00, 3, 1400.00, 2200.00, 35000.00, 3);
INSERT INTO Vehicle VALUES (4, '2MK94', 'MD', 1999, 36726, 'Pickup', '2 dors', 'Jeep Comanche', 'Dark Green', 39725.00, 4, 2800.00, 3500.00, 45000.00, 4);
INSERT INTO Vehicle VALUES (5, '2PJ97', 'MD', 2000, 24940, 'Van', '4 dors', 'Chevrolet Astrovan', 'White', 35620.00, 5, 1500.00, 5500.00, 45000.00, 5);

INSERT INTO Transaction VALUES (1, '30-OCT-02', NULL, 'Business traveler.', 30656, 112.00, 0.00, 1.99, 25000, NULL, NULL, 1, NULL);
INSERT INTO Transaction VALUES (2, '28-OCT-02', '01-NOV-02', 'Business traveler.', 21758, 312.00, 0.00, 1.99, 45000, 1249.99, 1, 1, 22758);
INSERT INTO Transaction VALUES (3, '29-OCT-02', NULL, 'Business traveler.', 23408, 99.00, 0.00, 1.99, 25000, NULL, NULL, 1, NULL);
INSERT INTO Transaction VALUES (4, '27-OCT-02', NULL, 'Business traveler.', 36726, 132.00, 0.00, 1.99, 25000, NULL, NULL, 1, NULL);
INSERT INTO Transaction VALUES (5, '26-OCT-02', NULL, 'Business traveler.', 24940, 212.00, 0.00, 1.99, 25000, NULL, NULL, 1, NULL);

INSERT INTO Accidents VALUES (1, '04-JAN-02', 0.000, 0.000, 'Minor damage to bumper', 289.99);
INSERT INTO Accidents VALUES (2, '12-MAR-01', 0.000, 0.000, 'Broken head light', 49.99);
INSERT INTO Accidents VALUES (3, '05-FEB-00', 0.000, 0.000, 'Busted wind sheald', 300.99);
INSERT INTO Accidents VALUES (4, '25-JUN-01', 0.000, 0.000, 'Dented frame', 1289.99);
INSERT INTO Accidents VALUES (5, '12-JUN-02', 0.000, 0.000, 'Cracked engine block', 2289.99);

INSERT INTO B_e VALUES (1, 1);
INSERT INTO B_e VALUES (1, 2);
INSERT INTO B_e VALUES (1, 3);
INSERT INTO B_e VALUES (1, 4);
INSERT INTO B_e VALUES (1, 5);

INSERT INTO B_v VALUES (1, 1);
INSERT INTO B_v VALUES (1, 2);
INSERT INTO B_v VALUES (1, 3);
INSERT INTO B_v VALUES (1, 4);
INSERT INTO B_v VALUES (1, 5);

INSERT INTO E_c VALUES (4, 1);
INSERT INTO E_c VALUES (4, 2);
INSERT INTO E_c VALUES (4, 3);
INSERT INTO E_c VALUES (2, 4);
INSERT INTO E_c VALUES (3, 5);

INSERT INTO E_d VALUES (1, 1);
INSERT INTO E_d VALUES (1, 3);
INSERT INTO E_d VALUES (2, 2);
INSERT INTO E_d VALUES (3, 4);
INSERT INTO E_d VALUES (4, 5);

INSERT INTO E_a VALUES (2, 1);
INSERT INTO E_a VALUES (2, 2);
INSERT INTO E_a VALUES (2, 3);
INSERT INTO E_a VALUES (3, 4);
INSERT INTO E_a VALUES (3, 5);

INSERT INTO C_a VALUES ('521429183', 1);
INSERT INTO C_a VALUES ('372925037', 2);
INSERT INTO C_a VALUES ('239527154', 3);
INSERT INTO C_a VALUES ('353284327', 4);
INSERT INTO C_a VALUES ('322285723', 5);

INSERT INTO C_i VALUES ('521429183', 1);
INSERT INTO C_i VALUES ('372925037', 2);
INSERT INTO C_i VALUES ('239527154', 3);
INSERT INTO C_i VALUES ('353284327', 4);
INSERT INTO C_i VALUES ('322285723', 5);

INSERT INTO V_m VALUES (1, 1);
INSERT INTO V_m VALUES (1, 2);
INSERT INTO V_m VALUES (1, 3);
INSERT INTO V_m VALUES (1, 4);
INSERT INTO V_m VALUES (1, 5);

INSERT INTO V_o VALUES (1, 1);
INSERT INTO V_o VALUES (2, 2);
INSERT INTO V_o VALUES (3, 3);
INSERT INTO V_o VALUES (4, 4);
INSERT INTO V_o VALUES (5, 5);

INSERT INTO T_b VALUES (1, 1);
INSERT INTO T_b VALUES (2, 1);
INSERT INTO T_b VALUES (3, 1);
INSERT INTO T_b VALUES (4, 1);
INSERT INTO T_b VALUES (5, 1);

INSERT INTO T_c VALUES (1, '521429183');
INSERT INTO T_c VALUES (2, '372925037');
INSERT INTO T_c VALUES (3, '239527154');
INSERT INTO T_c VALUES (4, '353284327');
INSERT INTO T_c VALUES (5, '322285723');

INSERT INTO T_v VALUES (1, 1);
INSERT INTO T_v VALUES (2, 2);
INSERT INTO T_v VALUES (3, 3);
INSERT INTO T_v VALUES (4, 4);
INSERT INTO T_v VALUES (5, 5);

INSERT INTO Ac_c VALUES (1, '521429183');
INSERT INTO Ac_c VALUES (2, '521429183');
INSERT INTO Ac_c VALUES (3, '521429183');
INSERT INTO Ac_c VALUES (4, '521429183');
INSERT INTO Ac_c VALUES (5, '521429183');

INSERT INTO Ac_v VALUES (1, 1);
INSERT INTO Ac_v VALUES (2, 1);
INSERT INTO Ac_v VALUES (3, 1);
INSERT INTO Ac_v VALUES (4, 1);
INSERT INTO Ac_v VALUES (5, 1);
