DataInsertion.sql

insert into place_of_service values (001,'The Fairmount','2448 Fairmount Blvd','bar');
insert into place_of_service values (002,'LAlbatros','11401 Bellflower Rd','bar');
insert into place_of_service values (003,'House Of Blues','308 Euclid Ave','bar');
insert into place_of_service values (004,'Constantinos','11473 Euclid Ave','grocery');
insert into place_of_service values (005,'Daves Market','12438 Cedar Rd','grocery');
insert into place_of_service values (006,'Sunoco','12404 Cedar Rd','gas');
insert into place_of_service values (007,'Marathon','15137 Euclid Ave','gas');
insert into place_of_service values (008,'BP','2701 Chester Ave','gas');
insert into place_of_service values (009,'Shell','13441 Euclid Ave','gas');

insert into bartender values ('Dick Bradsell','Male',8);
insert into bartender values ('Mock Brereton','Male',7);
insert into bartender values ('Rob Cesternino','Male',8);
insert into bartender values ('Cheryl Charming','Female',9);
insert into bartender values ('Dale DeGroff','Male',7);
insert into bartender values ('Marcis Dzelzainis','Male',9);
insert into bartender values ('Jonathan Evison','Male',6);
insert into bartender values ('Colin Peter','Male',7);
insert into bartender values ('Joe Gilmore','Male',8);
insert into bartender values ('Henry Hargreaves','Male',9);
insert into bartender values ('Sarah Ann Henley','Female',9);
insert into bartender values ('Mark Ibold','Male',8);
insert into bartender values ('Atilla Iskifoglu','Male',7);
insert into bartender values ('Kelly Macdonald','Male',9);
insert into bartender values ('Jared Martin','Male',5);
insert into bartender values ('Fernand Petiot','Male',6);
insert into bartender values ('Bill Ray','Male',7);
insert into bartender values ('Tatsuya Tanimoto','Male',9);

insert into drink values('Miller Lite','beer','Anheuser-Busc');
insert into drink values('Great Lakes Dortmunder','beer','Great Lakes Brewing');
insert into drink values('Great Lakes Chillwave','beer','Great Lakes Brewing');
insert into drink values('Coors Lite','beer','Coors Brewing Company');
insert into drink values('Bud Lite','beer','Anheuser-Busc');
insert into drink values('Natural Lite','beer','Anheuser-Busc');
insert into drink values('Heineken','beer','Dutch Brewery');
insert into drink values('Corona Extra','beer','Cervecería Modelo');
insert into drink values('Corona Lite','beer','Cervecería Modelo');
insert into drink values('Founders Porter','beer','Founders Brewing Company');
insert into drink values('Yellow Tail','Shiraz','Casella Family Brands');
insert into drink values('La Crema','red','La Crema Winery');
insert into drink values('Grey Goose Vodka','vodka','Grey Goose');
insert into drink values('Jack Daniels','whiskey','Jack Daniel Distillery');
insert into drink values('Tsingtao','beer','Tsingtao Brewery');

insert into company values('Anheuser-Busc','United States','Missouri','St.Louis');
insert into company values('Great Lakes Brewing', 'United States','Ohio','Cleveland');
insert into company values('Coors Brewing Company','United States','Colorado','Golden');
insert into company values('Dutch Brewery','Netherlands','Limburg','Schinnen');
insert into company values('Cervecería Modelo','Mexico','Mexico City','Mexico City');
insert into company values('Founders Brewing Company','United States','Missouri','Grand Rapids');
insert into company values('Casella Family Brands','Australia','Yenda','Yenda');
insert into company values('Grey Goose','France','Picardy','Picardy');
insert into company values('Jack Daniel Distillery','United States','Tennessee','Lynchburg');
insert into company values('Tsingtao Brewery','China','Shandong','Qingdao');

insert into makes values('Anheuser-Busc','Miller Lite');
insert into makes values('Anheuser-Busc','Bud Lite');
insert into makes values('Anheuser-Busc','Natural Lite');
insert into makes values('Great Lakes Brewing','Great Lakes Dortmunder');
insert into makes values('Great Lakes Brewing','Great Lakes Chillwave');
insert into makes values('Coors Brewing Company','Coors Lite');
insert into makes values('Dutch Brewery','Heineken');
insert into makes values('Cervecería Modelo','Corona Extra');
insert into makes values('Cervecería Modelo','Corona Lite');
insert into makes values('Founders Brewing Company','Founders Porter');
insert into makes values('Casella Family Brands','Yellow Tail');
insert into makes values('Grey Goose','Grey Goose Vodka');
insert into makes values('Jack Daniel Distillery','Jack Daniels');
insert into makes values('Tsingtao Brewery','Tsingtao');

insert into works values (001,'Dick Bradsell','12:00:00','18:00:00');
insert into works values (001,'Mock Brereton','09:00:00','16:00:00');
insert into works values (002,'Rob Cesternino','09:00:00','18:00:00');
insert into works values (002,'Cheryl Charming','15:00:00','18:00:00');
insert into works values (003,'Dale DeGroff','09:00:00','18:00:00');
insert into works values (003,'Marcis Dzelzainis','09:00:00','11:00:00');
insert into works values (004,'Jonathan Evison','11:00:00','14:00:00');
insert into works values (005,'Colin Peter','09:00:00','18:00:00');
insert into works values (005,'Joe Gilmore','09:00:00','18:00:00');
insert into works values (006,'Henry Hargreaves','10:00:00','14:00:00');
insert into works values (006,'Sarah Ann Henley','09:00:00','18:00:00');
insert into works values (007,'Mark Ibold','09:00:00','18:00:00');
insert into works values (007,'Atilla Iskifoglu','13:00:00','12:00:00');
insert into works values (008,'Kelly Macdonald','09:00:00','11:00:00');
insert into works values (008,'Jared Martin','14:00:00','12:00:00');
insert into works values (009,'Fernand Petiot','09:00:00','18:00:00');
insert into works values (009,'Bill Ray','09:00:00','11:00:00');

insert into sells values (001,'Miller Lite', 3);
insert into sells values (002,'Miller Lite', 3.5);
insert into sells values (003,'Miller Lite', 3.5);
insert into sells values (005,'Miller Lite', 4);
insert into sells values (007,'Miller Lite', 3);
insert into sells values (008,'Miller Lite', 4.5);
insert into sells values (002,'Great Lakes Dortmunder',5);
insert into sells values (003,'Great Lakes Dortmunder',6);
insert into sells values (004,'Great Lakes Dortmunder',4);
insert into sells values (007,'Great Lakes Dortmunder',6);
insert into sells values (008,'Great Lakes Dortmunder',4.5);
insert into sells values (001,'Great Lakes Dortmunder',4);
insert into sells values (001,'Great Lakes Chillwave', 5);
insert into sells values (003,'Great Lakes Chillwave', 6);
insert into sells values (005,'Great Lakes Chillwave', 4.5);
insert into sells values (007,'Great Lakes Chillwave', 6);
insert into sells values (001,'Coors Lite',3);
insert into sells values (002,'Coors Lite',3.5);
insert into sells values (003,'Coors Lite',3);
insert into sells values (004,'Coors Lite',3);
insert into sells values (005,'Coors Lite',3.5);
insert into sells values (006,'Coors Lite',3.5);
insert into sells values (007,'Coors Lite',4);
insert into sells values (008,'Coors Lite',4);
insert into sells values (009,'Coors Lite',4);
insert into sells values (001,'Bud Lite',3);
insert into sells values (005,'Bud Lite',3.5);
insert into sells values (006,'Bud Lite',4);
insert into sells values (008,'Bud Lite',3);
insert into sells values (001,'Natural Lite',3);
insert into sells values (005,'Natural Lite',3.5);
insert into sells values (001,'Heineken',4);
insert into sells values (002,'Heineken',4.5);
insert into sells values (003,'Heineken',4);
insert into sells values (004,'Heineken',4.5);
insert into sells values (005,'Heineken',4);
insert into sells values (001,'Corona Extra',4);
insert into sells values (001,'Corona Lite',3.5);
insert into sells values (002,'Corona Extra',4);
insert into sells values (002,'Corona Lite',3.5);
insert into sells values (003,'Corona Extra',4);
insert into sells values (003,'Corona Lite',3.5);
insert into sells values (004,'Corona Extra',4);
insert into sells values (004,'Corona Lite',3.5);
insert into sells values (001,'Founders Porter',5);
insert into sells values (002,'Founders Porter',5.5);
insert into sells values (003,'Founders Porter',6);
insert into sells values (004,'Founders Porter',5.5);
insert into sells values (005,'Founders Porter',5);
insert into sells values (006,'Founders Porter',5);
insert into sells values (001,'Yellow Tail', 19);
insert into sells values (001,'Grey Goose Vodka',30);
insert into sells values (001,'La Crema',25);
insert into sells values (001,'Jack Daniels',30);
insert into sells values (002,'Yellow Tail', 19);
insert into sells values (003,'Grey Goose Vodka',30);
insert into sells values (004,'La Crema',25);
insert into sells values (005,'Jack Daniels',30);
insert into sells values (005,'Yellow Tail', 19);
insert into sells values (006,'Grey Goose Vodka',30);
insert into sells values (007,'La Crema',25);
insert into sells values (008,'Jack Daniels',30);
insert into sells values (001,'Tsingtao',5);


insert into Operational_Times values (01,'Monday','09:00:00','Monday','18:00:00');
insert into Operational_Times values (02,'Tuesday','09:00:00','Tuesday','18:00:00');
insert into Operational_Times values (03,'Wednesday','09:00:00','Wednesday','18:00:00');
insert into Operational_Times values (04,'Thursday','09:00:00','Thursday','18:00:00');
insert into Operational_Times values (05,'Friday','09:00:00','Friday','18:00:00');
insert into Operational_Times values (06,'Saturday','09:00:00','Saturday','18:00:00');
insert into Operational_Times values (07,'Sunday','09:00:00','Sunday','18:00:00');
insert into Operational_Times values (08,'Friday','12:00:00','Saturday','04:00:00');
insert into Operational_Times values (09,'Saturday','12:00:00','Sunday','03:00:00');

insert into is_Open values (001,01);
insert into is_Open values (001,02);
insert into is_Open values (001,03);
insert into is_Open values (001,04);
insert into is_Open values (001,05);
insert into is_Open values (001,06);
insert into is_Open values (001,07);
insert into is_Open values (002,01);
insert into is_Open values (002,02);
insert into is_Open values (002,03);
insert into is_Open values (002,04);
insert into is_Open values (002,05);
insert into is_Open values (002,09);
insert into is_Open values (003,01);
insert into is_Open values (003,02);
insert into is_Open values (003,03);
insert into is_Open values (003,04);
insert into is_Open values (003,05);
insert into is_Open values (003,06);
insert into is_Open values (003,07);
insert into is_Open values (004,02);
insert into is_Open values (004,04);
insert into is_Open values (004,08);
insert into is_Open values (004,09);
insert into is_Open values (005,03);
insert into is_Open values (005,04);
insert into is_Open values (005,05);
insert into is_Open values (005,06);
insert into is_Open values (005,07);
insert into is_Open values (006,04);
insert into is_Open values (006,05);
insert into is_Open values (006,08);
insert into is_Open values (006,09);
insert into is_Open values (007,01);
insert into is_Open values (007,02);
insert into is_Open values (007,03);
insert into is_Open values (007,04);
insert into is_Open values (007,05);
insert into is_Open values (008,02);
insert into is_Open values (008,08);
insert into is_Open values (008,09);
insert into is_Open values (009,01);
insert into is_Open values (009,02);
insert into is_Open values (009,03);
insert into is_Open values (009,04);
insert into is_Open values (009,05);
insert into is_Open values (009,06);
insert into is_Open values (009,07);

insert into student values('S001','Syrena Bracey','2017');
insert into student values('S002','Erin Cohn','2017');
insert into student values('S003','Michaela Cooley','2017');
insert into student values('S004','Anniya Gu','2017');
insert into student values('S005','Ellen Hong','2017');
insert into student values('S006','Olive Jung','2018');
insert into student values('S007','Hannah Kondolf','2018');
insert into student values('S008','Joel Sax','2018');
insert into student values('S009','Jessica Scarborough','2018');
insert into student values('S010','Nicholas Venetos','2018');
insert into student values('S011','Soon Yi','2018');
insert into student values('S012','Muta Abiff','2019');
insert into student values('S013','Michelle Cruz','2019');
insert into student values('S014','Marc Ferrell','2019');
insert into student values('S015','Raza Haider','2020');
insert into student values('S016','Michal Jandzinski','2020');
insert into student values('S017','Dan Jindal','2020');
insert into student values('S018','George Luo','2020');

insert into event values ('06:00:00.00','Lollapalooza','2017-03-11', 4000);
insert into event values ('07:00:00.00','Picnic Pairing','2017-05-12', 500);
insert into event values ('09:00:00.00','Open Mic','2017-02-11', 350);
insert into event values ('06:00:00.00','Brain Gymnasium', '2017-07-11', 450);
insert into event values ('01:00:00.00','Fresh Air','2017-09-11', 1000);
insert into event values ('06:00:00.00','Bonnarro','2017-10-11', 200);
insert into event values ('08:00:00.00','The Questival','2017-11-11', 400);
insert into event values ('10:00:00.00','Holy Smokes','2017-09-09', 100);

insert into hosts values (001,'Lollapalooza','2017-03-11');
insert into hosts values (002,'Picnic Pairing','2017-05-12');
insert into hosts values (003,'Open Mic','2017-02-11');
insert into hosts values (004,'Brain Gymnasium', '2017-07-11');
insert into hosts values (005,'Fresh Air','2017-09-11');
insert into hosts values (006,'Bonnarro','2017-10-11');
insert into hosts values (007,'The Questival','2017-11-11');
insert into hosts values (008,'Holy Smokes','2017-09-09');
insert into hosts values (008,'Lollapalooza','2017-03-11');
insert into hosts values (007,'Picnic Pairing','2017-05-12');
insert into hosts values (006,'Open Mic','2017-02-11');
insert into hosts values (005,'Brain Gymnasium', '2017-07-11');
insert into hosts values (004,'Fresh Air','2017-09-11');
insert into hosts values (003,'Bonnarro','2017-10-11');
insert into hosts values (002,'The Questival','2017-11-11');
insert into hosts values (001,'Holy Smokes','2017-09-09');

insert into attend values ('S001','Lollapalooza','2017-03-11');
insert into attend values ('S002','Lollapalooza','2017-03-11');
insert into attend values ('S003','Lollapalooza','2017-03-11');
insert into attend values ('S004','Lollapalooza','2017-03-11');
insert into attend values ('S005','Lollapalooza','2017-03-11');
insert into attend values ('S002','Picnic Pairing','2017-05-12');
insert into attend values ('S003','Open Mic','2017-02-11');
insert into attend values ('S004','Brain Gymnasium', '2017-07-11');
insert into attend values ('S005','Brain Gymnasium', '2017-07-11');
insert into attend values ('S006','Brain Gymnasium', '2017-07-11');
insert into attend values ('S007','Brain Gymnasium', '2017-07-11');
insert into attend values ('S005','Fresh Air','2017-09-11');
insert into attend values ('S006','Bonnarro','2017-10-11');
insert into attend values ('S007','The Questival','2017-11-11');
insert into attend values ('S008','Holy Smokes','2017-09-09');
insert into attend values ('S008','Lollapalooza','2017-03-11');
insert into attend values ('S007','Picnic Pairing','2017-05-12');
insert into attend values ('S006','Open Mic','2017-02-11');
insert into attend values ('S005','Brain Gymnasium', '2017-07-11');
insert into attend values ('S004','Fresh Air','2017-09-11');
insert into attend values ('S003','Bonnarro','2017-10-11');
insert into attend values ('S002','The Questival','2017-11-11');
insert into attend values ('S001','Holy Smokes','2017-09-09');

insert into buys values ('S001',10,'Miller Lite');
insert into buys values ('S001',8,'Great Lakes Dortmunder');
insert into buys values ('S002',6,'Bud Lite');
insert into buys values ('S002',4,'Coors Lite');
insert into buys values ('S003',12,'Founders Porter');
insert into buys values ('S003',14,'Great Lakes Dortmunder');
insert into buys values ('S004',10,'Jack Daniels');
insert into buys values ('S004',9,'Bud Lite');
insert into buys values ('S005',8,'Jack Daniels');
insert into buys values ('S005',7,'Miller Lite');
insert into buys values ('S006',6,'Jack Daniels');
insert into buys values ('S007',5,'Jack Daniels');
insert into buys values ('S008',7,'Great Lakes Dortmunder');
insert into buys values ('S009',9,'Founders Porter');
insert into buys values ('S010',8,'Coors Lite');
insert into buys values ('S011',6,'Miller Lite');
insert into buys values ('S012',5,'Bud Lite');
insert into buys values ('S013',9,'Jack Daniels');
insert into buys values ('S014',15,'Great Lakes Dortmunder');
insert into buys values ('S015',16,'Jack Daniels');
insert into buys values ('S016',10,'Miller Lite');
insert into buys values ('S017',5,'Jack Daniels');
insert into buys values ('S018',4,'Great Lakes Dortmunder');
insert into buys values ('S018',3,'Founders Porter');
insert into buys values ('S017',2,'Miller Lite');
insert into buys values ('S016',5,'Jack Daniels');
insert into buys values ('S015',10,'Coors Lite');
insert into buys values ('S015',1,'Grey Goose Vodka');

insert into manager values (001, 'Brittney Hibbs', 'Female', 576398);
insert into manager values (002, 'Ashley Rein', 'Female', 568498);
insert into manager values (003, 'Jimmie Bennette', 'Male', 984786);
insert into manager values (004, 'Misty Martinez', 'Female', 583937);
insert into manager values (005, 'Randy Juarez', 'Male', 556567);
insert into manager values (006, 'Ronnie Wheatley', 'Male', 1023443);
	
insert into manages values (001,001);
insert into manages values (002,002);
insert into manages values (003,003);
insert into manages values (004,004);
insert into manages values (005,004);
insert into manages values (006,004);
insert into manages values (007,005);
insert into manages values (008,005);
insert into manages values (009,006);