/* Group 6 */

insert into organization values(100, 10, 'PIC');
insert into organization values(101, 2, 'Pytel Inc.');
insert into organization values(102, 5, 'MIPS');
insert into organization values(103, 1, 'QRTV');
insert into organization values(104, 15, 'UITR');
insert into organization values(105, 11, 'SIM');
insert into organization values(106, 13, 'CSA');
insert into organization values(107, 99, 'BPP INC');
insert into organization values(108, 12 'G4TV');
insert into organization values(109, 50, 'Pomp Co.');
insert into organization values(110, 10, 'Middleton and Peeps');
insert into organization values(111, 1, 'Mr. Potato Head Inc');
insert into organization values(112, 4, 'Flash');
insert into organization values(113, 52, 'P double O Pee');
insert into organization values(114, 50, 'Mullet Cutters');

insert into office values(56, 100, 'PIC Main Office', '200 Broadway St.', 5);
insert into office values(92, 101, 'Lexington Ave Office', '1214 Lexington Ave.', 1);
insert into office values(106, 102, 'Bross St. Office', '1567 Bross St.', 7);
insert into office values(9, 103, 'Main St. Office', '7841 Main St.', 25);
insert into office values(54, 104, 'UITR Headquaters', '1 Headquaters St.', 200);
insert into office values(57, 105, 'SIM HQ', '10 NoRoad Street', 6);
insert into office values(98, 106, 'CSA Main Branch', '3 George Wash. Blvd.', 1);
insert into office values(1, 107, 'BPP Inc Main Office', 'Oswego Rd', 50);
insert into office values(45, 107, 'BPP Inc Wash. Office', '1600 Pennslvania Ave', 45);
insert into office values(76, 108, 'G4TV Office A', '123 Fake Street', 11);
insert into office values(14, 109, 'Pomp Co Div. 1', '40 Tom Lane', 3);
insert into office values(110, 110, 'Middleton and Peeps Main', '50 East Lane', 106);
insert into office values(111, 111, 'Mr. P - Bucket of Parts', '105 Spud Ave', 100);
insert into office values(112, 112, 'Flash Office Two', '30 Northway Way', 40);
insert into office values(113, 113, 'P Dboule O Pee - #2', '1 Southway Street', 1);
insert into office values(114, 114, 'Mullet Cutters Oswego', ;37 John Street', 10);

insert into day values(56, 'Monday', 8:00AM, 5:00PM, 60);
insert into day values(92, 'Tuesday', 8:00AM, 5:00PM, 20);
insert into day values(106, 'Wednesday', 8:00AM, 12:00PM, 30);
insert into day values(9, 'Thursday', 8:00AM, 4:00PM, 10);
insert into day values(54, 'Friday', 8:00AM, 12:00PM, 30);
insert into day values(57, 'Monday', 8:00AM, 5:00PM, 60);
insert into day values(98, 'Tuesday', 8:00AM, 5:00PM, 30);
insert into day values(1, 'Wednesday', 8:00AM, 3:00PM, 20);
insert into day values(45, 'Wednesday', 8:00AM, 3:00PM, 20);
insert into day values(76, 'Thursday', 8:00AM, 4:00PM, 15);
insert into day values(14, 'Friday', 8:00AM, 12:00PM, 30);
insert into day values(110, 'Monday', 8:00AM, 2:00PM, 40);
insert into day values(110, 'Wednesday', 9:00AM, 3:00PM, 30); 
insert into day values(110, 'Friday', 10:00AM, 1:00PM, 20);
insert into day values(111, 'Monday', 8:00AM, 2:00PM, 20);
insert into day values(111, 'Tuesday', 9:00AM, 5:00PM, 60);

insert into person values(58, 'Kevin', 'Pytel', 123456789, 51885698741, 'blah@csc.com', '705 Csc Dr.', 'cairo', 'NY' 12413);
insert into person values(45, 'Joe', 'Who', 123456780, 51885698745, 'csc459@csc.com', '710 Csc Dr.', 'Oswego', 'NY' 13126);
insert into person values(85, 'Mike', 'Smith', 123456781, 51885698742, 'csc365@csc.com', '725 Csc Dr.', 'Albany', 'NY' 12203);
insert into person values(96, 'Nick', 'Reese', 123456788, 51885698744, 'csc241@csc.com', '8801 Csc Dr.', 'cairo', 'NY' 12413);
insert into person values(74, 'Chris', 'Roundtop', 123456714, 51885698785, 'csc212@csc.com', '7739 Csc Dr.', 'Oswego', 'NY' 13126);
insert into person values(08, 'Brian', 'Pelc', 113548794, 3155555436, 'something@something.com', '13 Mularky Dr', 'Minetto', 'NY' 13115);
insert into person values(14, 'Tom', 'Jones', 987654321, 7168959080, 'more@less.com', '34 Bogus Street', 'Oswego', 'NY', 13126);
insert into person values(25, 'Nicholas', 'Vlaksky', 675849301, 6077533352, 'your@mom.com', '01 That Street', 'Fulton', 'NY', 13069);
insert into person values(11, 'Peter', 'Crouse', 454565789, 9174563215, 'bored@mylife.com', '04 My House Rd', 'Minetto', 'NY', 13115);
insert into person values(79, 'Master', 'Shake', 124356879, 2023677684, 'laughin@yourmom.com', '135 Something St', 'Oswego', 'NY', 13126);
insert into person values(100, 'Mike', 'Middleton', 125314589, 9149149914, 'mike@oswego.edu', '12 Stinkbug St', 'Oswego', 'NY', '13126');
insert into person values(101, 'John', 'Cruse', 154986413. 1265478961, 'john.cruse@cs.oswego.edu', '11 Boring Rd', 'Oswego', 'NY', '13126');
insert into person values(102, 'Max', 'Slick', 547896521, 1257896543, 'slickwilly@yahoo.com', '47 West Rd', 'Oswego', 'NY', '13126');
insert into person values(103, 'Johnny', 'Lefty', 587412369, 2544785123, 'leftyace@msn.com', '11 Suicide Ave', 'Oswego', 'NY', '13126');
insert into person values(104, 'Derek', 'Jeter', 054787896, 7182546698, 'notwo@yahoo.com, '10 Yankees Rule Lane', 'New York', 'NY', '10001');

insert into professional values(58, 56, true);
insert into professional values(45, 92, true);
insert into professional values(85, 106, false);
insert into professional values(96, 9, true);
insert into professional values(74, 54, true);
insert into professional values(34, 57, true);
insert into professional values(56, 98, true);
insert into professional values(67, 1, true);
insert into professional values(78, 45, true);
insert into professional values(89, 76, true);
insert into professional values(90, 14, true);
insert into professional values(100, 114, true);
insert into professional values(101, 114, true);
insert into professional values(104, 111, false);

insert into appointment values(100, 56, 58, 45, 02/05/06, 8:20, 8:40);
insert into appointment values(101, 92, 45, 58, 02/06/06, 8:00, 9:00);
insert into appointment values(102, 106, 85, 96, 02/07/06, 8:10, 8:20);
insert into appointment values(103, 9, 96, 45, 03/05/06, 4:00, 5:00);
insert into appointment values(104, 54, 74, 58, 12/05/08, 1:40, 1:50);
insert into appointment values(105, 57, 34, 08, 03/06/06, 9:20, 10:40);
insert into appointment values(106, 98, 56, 14, 11/06/07, 8:00, 11:00);
insert into appointment values(107, 1, 67, 25, 06/17/06, 8:30, 8:50);
insert into appointment values(108, 45, 78, 45, 05/06/06, 2:00, 5:00);
insert into appointment values(109, 14, 90, 11, 11/15/08, 3:50, 4:50);
insert into appointment values(110, 114, 100, 102, 11/10/09, 10:00, 11:00);
insert into appointment values(111, 114, 100, 103, 10/09/07, 10:00, 12:00);
insert into appointment values(112, 114, 100, 101, 01/01/07, 10:00, 11:00);
insert into appointment values(113, 114, 101, 103, 05/03/06, 1:00, 3:00);
insert into appointment values(114, 114, 101, 102, 06/04/07, 2:00, 4:00);

insert into occurs values(1,hourly);
insert into occurs values(10,yearly);
insert into occurs values(11,monthly);
intser into occurs values(12, daily);
insert into occurs values(2,weekly);
insert into occurs values(13,semi-annualy);
insert into occurs values(18,quarterly);

insert into personal_time values(100, 58, 1, 1, 01/27/06, 12:00PM, 5:00PM);
insert into personal_time values(101, 45, 1, 1, 12/14/06, 8:00AM, 5:00PM);
insert into personal_time values(102, 85, 1, 1, 05/08/06, 8:00AM, 9:00PM);
insert into personal_time values(103, 96, 11, 1, 05/07/06, 8:00AM, 5:00PM);
insert into personal_time values(104, 58, 12, 1, 01/27/07, 8:00AM, 5:00PM);
insert into personal_time values(105, 34, 1, 1, 01/27/06, 12:00PM, 5:00PM);
insert into personal_time values(106, 56, 1, 1, 12/27/06, 8:00AM, 6:00PM);
insert into personal_time values(107, 867, 1, 2, 05/15/06, 8:00AM, 8:00PM);
insert into personal_time values(108, 78, 18, 4, 05/14/06, 8:00AM, 5:00PM);
insert into personal_time values(109, 89, 13, 3, 02/04/07, 7:00AM, 1:00PM);
insert into personal_time values(110, 90, 2, 1, 02/14/07, 10:00AM, 1:00PM);
insert into personal_time values(111, 100, 12, 1, 01/21/09, 10:00AM, 5:00PM);  
insert into personal_time values(112, 100, 1, 1,  04/2/05, 10:00AM, 5:00PM);
insert into personal_time values(113, 100, 18, 2,  03/20/06,  10:00AM, 5:00PM);
insert into personal_time values(114, 100, 2, 2,  02/30/08,  10:00AM, 5:00PM);
insert into personal_time values(115, 100, 10, 2,  09/23/07,  10:00AM, 5:00PM);

insert into closed_day values(56, 10/12/2011, 'Just Because');
insert into closed_day values(92, 11/08/2006, 'Conferences');
insert into closed_day values(106, 12/25/2006, 'Christmas');
insert into closed_day values(9, 01/01/2007, 'New Years');
insert into closed_day values(54, 12/14/2006, 'Christmas');
insert into closed_day values(57, 01/31/2007, 'Luncheon');
insert into closed_day values(1, 10/03/2004, 'Conferences');
insert into closed_day values(45, 12/27/2006, 'Birthday');
insert into closed_day values(76, 12/27/2006, 'Birthday');
insert into closed_day values(14, 04/01/2006, 'April Fools Day');
insert into closed_day values(100, 11/10/06, 'Mike's Bday');
insert into closed_day values(101, 11/1/11, 'Smells Day');
insert into closed_day values(102, 10/1/06, 'Good Job Day');
insert into closed_day values(103, 09/10/07, 'Tired of making fake data up day');
insert into closed_day values(104, 04/30/09, 'Arg');
/* Group 2 */
insert into Organization values('057392019375','2','Bern and Bern');
insert into Organization values('058720395850','1','Mary Walker Health Care');
instert into Organization values('846739394858','4','March of Dimes');

insert into Office values('75648','057392019375','Bern and Bern Main Branch','Fulton, NY','3');
insert into Office values('75997','057392019375','Bern and Bern North Branch','Watertown, NY','2');
insert into Office values('58493','058720395850','Mary Walker Health Center','Oswego, NY','5');
insert into Office values('12405','846739394858','March of Dimes NY','Albany, NY','3');
insert into Office values('59301','846739394858','March of Dimes CT','Danbury CT','2');
insert into Office values('30495','846739394858','March of Dimes NC','Raleigh, NC','4');
insert into Office values('94832','846739394858','Mary Walker Health Center','Oswego, NY','3');

insert into Professional values('8573837','75648','True');
insert into Professional values('8573902','75648','True');
insert into Professional values('9684728','75648','True');
insert into Professional values('9574839','75997','True');
insert into Professional values('9684932','75997','True');
insert into Professional values('9604830','58493','True');
insert into Professional values('1526462','58493','True');
insert into Professional values('5739129','58493','True');
insert into Professional values('7563728','58493','True');
insert into Professional values('6472746','58493','True');
insert into Professional values('7563837','12405','True');
insert into Professional values('4352625','12405','True');
insert into Professional values('6574626','12405','True');
insert into Professional values('7685737','59301','True');
insert into Professional values('0191837','59301','True');
insert into Professional values('7684732','30495','True');
insert into Professional values('9849272','30495','True');
insert into Professional values('1583476','30495','True');
insert into Professional values('2957593','30495','True');
insert into Professional values('0857372','94832','True');
insert into Professional values('1917573','94832','True');
insert into Professional values('5939372','94832','True');

insert into Day values('75648','Monday','8:00','5:00','1');
insert into Day values('30495','Tuesday','9:00','7:00','2');
insert into Day values('94832','Thrusday','6:00','3:00','2');
insert into Day values('58493','Saturday','9:00','1:00','1');
insert into Day values('75997','Sunday','12:00','3:00','1');
insert into Day values('58493','Monday','7:00','8:00','2');

insert into occurs values('94803','Lunch');
insert into occurs values('20305','Meeting');
insert into occurs values('30593','LUnch');
insert into occurs values('20395','Lunch');
insert into occurs values('86940','Meeting');
insert into occurs values('68839','Lunch');
insert into occurs values('71912','Lunch');

insert into Closed_Day values('94832','12/24/2006','Christmas');
insert into Closed_Day values('12405','10/5/2006','Conference');
insert into Closed_Day values('58493','11/8/2006','Meeting');
insert into Closed_Day values('75997','8/15/2006','Vacation');

insert into Personal_Time values('9967','9684932','86940','1','7/9/2006','9:00','5:00');
insert into Personal_Time values('9049','0191837','20305','1','5/5/2006','10:00','2:00');

insert into Person values('9857293','Peter','Smith','046890494','5555555555','pete2@alpha.com','123 Mina St','Oswego','NY','13126');
insert into Person values('0385038','Fred','Bern','768490237','1111111111','fredb@email.com','555 Pete St','FakeTown','AL','77845');
insert into Person values('9048373','Jim','O'malley','657361289','2222222222','jimmybean@yahoo.com','89 Lina Rd','Newtown','WI','99876');
insert into Person values('1932795','Bruce','George','657392739','3333333333','heyyou@hotmail.com','88 Church St','Tinker Town','HI','98573');
insert into Person values('2037593','Barbara','Reid','102657483','4445556654','barb@twcny.rr.com','987 Lost Ct','Managersville','MA','11785');
insert into Person values('6859473','Lilian','Nell','086758493','7685948579','email55@yell.com','908 Main St','Yule','MN','10198');
insert into Person values('8673947','Judi','Cody','857392014','8675847364','help_me@this.com','789 Forest St','Boulder','CO','67584');
insert into Person values('5847284','Mary','Terry','364758473','5647382956','whereyouare@lost.com','856 Tata Rd','Lostittown','ND','99086');
insert into Person values('9495727','Dan','Peck','847958302','6575493758','scared@freddy.com','726 Area Rd','Weirdville','TN','57684');
insert into Person values('7563838','Jill','Walker','957584928','7685723990','jump@hop.com','44 Rod St','Beverly Hills','Ca','90210');

insert into Appointment values('76857379','75997','9574839','7563838','8/15/2006','12:00','1:00');
insert into Appointment values('76849211','75648','8573837','9048373','9/10/2006','10:00','11:00');
insert into Appointment values('57483000','58493','9604830','0385038','5/4/2006','9:00','11:00');
insert into Appointment values('76843002','30495','4352625','9857293','8/19/2006','3:00','5:00');
insert into Appointment values('33558672','58493','1526462','6859473','3/30/2006','6:00','8:00');
insert into Appointment values('17285757','94832','0857372','8673947','10/6/2006','6:00','8:00');
/* Group 8 */
insert into Organization values('001','3','Crunk Juice');
insert into Organization values('002','1','Shizzle, Inc.');
insert into Organization values('003','5','Rocafella Records');
insert into Organization values('004','2','K-Swiss');
insert into Organization values('005','1','Phat Farm');
insert into Office values('301','001',,'A-1-A Beachfront Avenue','2');
insert into Office values('302','002',,'Southside','1');
insert into Office values('303','003',,'Upper West','3');
insert into Office values('304','004',,'NYC','5');
insert into Office values('305','005',,'South Central','1');
insert into Day values('301','Monday','0800','1700','15');
insert into Day values('302','Tuesday','1000','1300','5');
insert into Day values('303','Wednesday','1100','1130','30');
insert into Day values('304','Thursday','0300','1800','45');
insert into Day values('305','Friday','0800','1400','10');
insert into Person values('1001','Bobby','Digital','000998888','7183125200','wutang@forLife.com','360 Degrees Ave','Bronx','NY','10039');
insert into Person values('1002','Jay','Z','777665555','2125397210','jigga@shawncarter.com','12 Hova Ave','NYC','NY','10039');
insert into Person values('1003','Mike D','444559999','2123459876','kingatrhymes@mca.com','42 Intergalactic St','Manhattan','NY','10039');
insert into Person values('1004','Dr. Dre','222331111','2134458787','thedoc@deathrow.com','54 Frontin St','Long Beach','CA','90210');
insert into Person values('1005','Sean Paul','544667788','3188763300','dutty@island.com','420 Bob Marley Way','Kingston','JM','12345');
insert into Professional values('1001','301','true');
insert into Professional values('1002','302','true');
insert into Professional values('1003','303','true');
insert into Professional values('1004','304','true');
insert into Professional values('1005','305','true');
insert into Appointment values('3001','301','1001','1002','11/08/2006','1100','1115');
insert into Appointment values('3002','302','1002','1003','11/15/2007','1115','1145');
insert into Appointment values('3003','303','1003','1004','10/07/2006','0400','0430');
insert into Appointment values('3004','304','1004','1005','06/03/2006','1300','1330');
insert into Appointment values('3005','305','1005','1001','02/14/2007','1400','1430');
insert into Personal_Time values('5001','1001','7001','2','01/01/2006','0800','1700');
insert into Personal_Time values('5002','1002','7002','1','06/17/2006','1000','1200');
insert into Personal_Time values('5003','1003','7003','3','02/02/2006','0300','1200');
insert into Personal_Time values('5004','1004','7004','2','04/14/2006','0800','1000');
insert into Personal_Time values('5005','1005','7005','1','10/20/2006','1100','1130');
insert into Occurs values('7001','Random Occurance');
insert into Occurs values('7002','The thing, with the person');
insert into Occurs values('7003','Beer time');
insert into Occurs values('7004','You know');
insert into Occurs values('7005','Shenanigans');
insert into Closed_Day values('301','03/12/2006','Hungover');
insert into Closed_Day values('302','03/17/2006','St Patty's Day!');
insert into Closed_Day values('303','06/06/2006','Drunk');
insert into Closed_Day values('304','11/08/2006','Because I can');
insert into Closed_Day values('305','12/25/2006','Christmas!');
/* Group 7 */
insert into appointment   values(561456,000001,00000001,00000009,'3-12-06','10:00','10:30');
insert into appointment   values(561457,000002,00000007,00000010,'3-12-06','1:00','1:30');
insert into appointment   values(561458,000003,00000005,00000014,'3-12-06','2:00','3:00');
insert into appointment   values(561459,000004,00000002,00000017,'3-12-06','10:00','10:30');
insert into appointment   values(561460,000005,00000006,00000013,'3-12-06','9:30','10:00');
insert into appointment   values(561461,000006,00000004,00000012,'3-12-06','12:30','1:00');
insert into appointment   values(561462,000007,00000008,00000019,'3-12-06','2:00','3:00');
insert into appointment   values(561463,000008,00000018,00000011,'3-12-06','11:30','12:00');
insert into appointment   values(561464,000009,00000003,00000015,'3-12-06','9:00','9:30');
insert into appointment   values(561465,000009,00000003,00000016,'3-12-06','9:30','10:00');
insert into closed_day    values(0001,010206,'new years day');
insert into closed_day    values(0002,011606,'mlk birthday');
insert into closed_day    values(0003,022006,'washingtons birthday');
insert into closed_day    values(0004,052906,'memorial day');
insert into closed_day    values(0005,070406,'independence day');
insert into closed_day    values(0006,090406,'labor day');
insert into closed_day    values(0007,100906,'columbus day');
insert into closed_day    values(0008,111006,'veterans day');
insert into closed_day    values(0009,112306,'thanksgiving');
insert into closed_day    values(0010,122506,'christmas');
insert into day   values(000001,'monday','9:00','5:00',30);
insert into day   values(000001,'tuesday','9:00','5:00',30);
insert into day   values(000001,'wednesday','9:00','5:00',30);
insert into day   values(000001,'thursday','9:00','5:00',30);
insert into day   values(000001,'friday','9:00','5:00',30);
insert into day   values(000002,'monday','7:00','3:00',30);
insert into day   values(000002,'tuesday','7:00','3:00',30);
insert into day   values(000002,'wednesday','7:00','3:00',30);
insert into day   values(000002,'thursday','7:00','3:00',30);
insert into day   values(000002,'friday','7:00','3:00',30);
insert into day   values(000003,'monday','6:00','5:00',60);
insert into day   values(000003,'tuesday','6:00','5:00',60);
insert into day   values(000003,'wednesday','6:00','5:00',60);
insert into day   values(000003,'thursday','6:00','5:00',60);
insert into day   values(000003,'friday','6:00','5:00',60);
insert into day   values(000004,'monday','9:00','5:00',30);
insert into day   values(000004,'tuesday','9:00','5:00',30);
insert into day   values(000004,'wednesday','9:00','5:00',30);
insert into day   values(000004,'thursday','9:00','5:00',30);
insert into day   values(000004,'friday','9:00','5:00',30);
insert into day   values(000005,'monday','5:00','2:00',30);
insert into day   values(000005,'tuesday','5:00','5:00',30);
insert into day   values(000005,'wednesday','5:00','5:00',30);
insert into day   values(000005,'thursday','5:00','5:00',30);
insert into day   values(000005,'friday','5:00','5:00',30);
insert into day   values(000006,'monday','9:00','5:00',30);
insert into day   values(000006,'tuesday','9:00','5:00',30);
insert into day   values(000006,'wednesday','9:00','5:00',30);
insert into day   values(000006,'thursday','9:00','5:00',30);
insert into day   values(000006,'friday','9:00','5:00',30);
insert into day   values(000007,'monday','8:00','5:00',60);
insert into day   values(000007,'tuesday','8:00','5:00',60);
insert into day   values(000007,'wednesday','8:00','5:00',60);
insert into day   values(000007,'thursday','8:00','5:00',60);
insert into day   values(000007,'friday','8:00','5:00',60);
insert into day   values(000008,'monday','9:00','4:00',30);
insert into day   values(000008,'tuesday','9:00','4:00',30);
insert into day   values(000008,'wednesday','9:00','4:00',30);
insert into day   values(000008,'thursday','9:00','4:00',30);
insert into day   values(000008,'friday','9:00','4:00',30);
insert into day   values(000009,'monday','9:00','5:00',30);
insert into day   values(000009,'tuesday','9:00','5:00',30);
insert into day   values(000009,'wednesday','9:00','5:00',30);
insert into day   values(000009,'thursday','9:00','5:00',30);
insert into day   values(000009,'friday','9:00','5:00',30);
insert into occurs   values(01,'weekly');
insert into occurs   values(02,'monthly');
insert into occurs   values(03,'yearly');
insert into office   values(0001,000001,'Free Insurance','200 west first oswego',23);
insert into office   values(0001,000002,'Free Insurance','32 main st fulton',20);
insert into office   values(0001,000003,'Free Insurance','73 third ave ithica',18);
insert into office   values(0002,000004,'Oneill Insurance','85 south fifth st liverpool',21);
insert into office   values(0002,000005,'Oneill Insurance','37 east ninth st syracuse',16);
insert into office   values(0003,000006,'Mulvehill Insurance','55 broadway baldwinsville',15);
insert into office   values(0003,000007,'Mulvehill Insurance','5 east main st utica',25);
insert into office   values(0003,000008,'Mulvehill Insurance','25 north broad st rome',17);
insert into office   values(0003,000009,'Mulvehill Insurance','41 john st scriba',20);
insert into organization   values(0001,3,'free inc');
insert into organization   values(0002,2,'oneill inc');
insert into organization   values(0003,4,'mulvehill inc');
insert into person   values(00000001,'robert','free',564856495,3155649548,'rj@freeinc.com','625 west cayuga st','oswego','ny','13126');
insert into person   values(00000002,'patrick','oneill',0564268951,3156952456,'po@oneillinc.com','561 east seneca','liverpool','ny','1316');
insert into person   values(00000003,'john','mulvehill',0564589652,3156488962,'jm@mulvehillinc.com','25 main st','scriba','ny','13122');
insert into person   values(00000004,'daniel','jackson',125326523,3156256969,'dj@mulvehillinc.com','22 hayes st','baldwinsville','ny','13120');
insert into person   values(00000005,'steven','johnson',121210369,2135896145,'sj@freeinc.com','55 olive dr','ithica,'ny','13121');
insert into person   values(00000006,'chris','jameson',012301201,4445696586,'cj@poneillinc.com','1 main st','syracuse','ny','13129');
insert into person   values(00000007,'robert','jones',012102356,5556565896,'rj@freeinc.com','56 hampton dr','fulton','ny','13125');
insert into person   values(00000008,'brian','cooper',562562536,5555555555,'bc@mulvehillinc.com','37 lookout pt','utica','ny','13123');
insert into person   values(00000009,'andrew','wright',444454420,4646464649,'aw@hotmail.com','666 main st','oswego','ny','13126');
insert into person   values(00000010,'james','obrien',215222366,4596321452,'jo@hotmail.com','12 river st','fulton','ny','13125');
insert into person   values(00000011,'frank','ocean',2235698999,5696586932,'fo@hotmail.com','88 silver dr','rome','ny','13120');
insert into person   values(00000012,'mike','copperfield',111111111,1515151524,'mc@aol.com','985 john st','baldwinsville','ny','13121');
insert into person   values(00000013,'sally','smith',555563258,2535865214,'ss@hotmail.com','4 main st','syracuse','ny','13129');
insert into person   values(00000014,'john','doe',569851972,6965852365,'jd@aol.com','73 delra la','ithica','ny','13124');
insert into person   values(00000015,'william','parker',562312588,5565656565,'wp@verizon.com','9 utica dr','scriba','ny','13122');
insert into person   values(00000016,'jill','jenkins',125478563,6666666663,'jj@verizon.com','33 overview dr','scriba','ny','13122');
insert into person   values(00000017,'randy','daniels',562145682,5621256324,'rd@hotmail.com','26 bridge st','liverpool','ny','13166');
insert into person   values(00000018,'alex','conner',562312547,6564123568,'ac@mulvehillinc.com','11 john st','rome','ny','13120');
insert into person   values(00000019,'carl','fink',125648562,2659856,'cf@oaol.com','69 main st','utica','ny','13123');
insert into personal_time   values(97979790,00000001,01,1,'3-16-06','12:00','1:30');
insert into personal_time   values(97979781,00000002,01,1,'3-16-06','12:00','1:30');
insert into personal_time   values(97979702,00000003,01,1,'3-16-06','12:00','1:30');
insert into personal_time   values(97959793,00000004,03,3,'3-16-06','11:30','12:30');
insert into personal_time   values(97919794,00000005,02,2,'3-16-06','10:00','11:00');
insert into personal_time   values(97929795,00000006,02,2,'3-16-06','1:00','2:00');
insert into personal_time   values(91979796,00000007,01,1,'3-16-06','2:00','3:00');
insert into personal_time   values(79739797,00000008,02,2,'3-16-06','3:00','4:00');
insert into personal_time   values(97979998,00000018,03,5,'3-16-06','12:00','1:30');
insert into professional   values(00000001,0001,'false');
insert into professional   values(00000002,0001,'false');
insert into professional   values(00000003,0001,'false');
insert into professional   values(00000004,0001,'true');
insert into professional   values(00000005,0001,'false');
insert into professional   values(00000006,0001,'true');
insert into professional   values(00000007,0001,'false');
insert into professional   values(00000008,0001,'true');
insert into professional   values(00000018,0001,'false');
/* Group 4 */
insert into organization values (00001, , New York Yankees);

insert into office values (00001, 00001, Headquarters, New York, );
insert into office values (00002, 00001, South Offices, Florida, );

insert into person values (0000001, mariano, rivera, 123549834, , rivera@yankees.com, , New York, NY, );
insert into person values (0000002, robinson, cano, 698524753, , cano@yankees.com, , New York, NY, );
insert into person values (0000003, derek, jeter, 254781236, , jeter@yankees.com, , New York, NY, );
insert into person values (0000004, hideki, matsui, 254781236, , matsui@yankees.com, , New York, NY, );
insert into person values (0000005, melky, cabrera, 657411124, , mcabrera@yankees.com, , Tampa, FL, );
insert into person values (0000006, george, steinbrenner, 492833254, , steinbrenner@yankees.com, , New York, NY, );
insert into person values (0000007, brian, cashman, 369852147, , cashman@yankees.com, , Tampa, FL, );
insert into person values (0000008, randy, levine, 897563214, , levine@yankees.com, , Tampa, FL, );

insert into professional values (0000008, 00002, true);
insert into professional values (0000006, 00001, true);
insert into professional values (0000007, 00002, true);

insert into appointment values (00000001, 00001, 0000007, 0000003, 03282006, 1200, 1300);
insert into appointment values (00000002, 00001, 0000006, 0000002, 09282006, 1800, 1830);
insert into appointment values (00000003, 00002, 0000007, 0000005, 06102006, 0900, 1000);
insert into appointment values (00000004, 00001, 0000007, 0000001, 03312006, 1300, 1500);
insert into appointment values (00000005, 00002, 0000006, 0000005, 08012006, 2200, 2400);



insert into Organization  values (3467089231, 2, Acme INC);

insert into Office        values (4, 3467089231, office number four, 123 Road, 2);
insert into Office        values (2, 3467089231, office number two, 456 street, 1);

insert into Day           values (3467089231, weekday for office four, 900, 330, 30);
insert into Day           values (3467089231, weekday for office two, 730, 800, 60);

insert into Person        values (8496416196, Bob, Slade, 792651354, 3155559135, bob@acme.com, 65 Any Street, somewhere, New
York, 66845);
insert into Person        values (1498161651, George, Patterson, 316651344, 9463117961, george@acme.com, 66 This Drive, nowhere,
New York, 31566);
insert into Person        values (1749451296, Bill, Smith, 123549856, 7963159431, bill@acme.com, 245 That Road, anywhere, New
York, 31166);
insert into Person        values (9879421313, John, Scott, 875611418, 6513544897, john@gmail.com, 7965 Some Street, everywhere,
New York, 65655);
insert into Person        values (2576469987, Frank, Jones, 798412354, 911541348, pat@yahoo.com, 984 Some Road, where, New York,
98763);

insert into Professional  values (8496416196, 3467089231, true);
insert into Professional  values (1498161651, 3467089231, true);
insert into Professional  values (1749451296, 3467089231, true);

insert into Appointment   values (794651191, 3467089231, 8496416196, 9879421313, 092406, 10, 1030);
insert into Appointment   values (973155734, 3467089231, 1498161651, 2576469987, 102806, 2, 3);
insert into Appointment   values (972345495, 3467089231, 1749451296, 9879421313, 020706, 9, 1030);

insert into Personal_Time values (2, 1498161651, 4, 6, 041206, 400, 600);

insert into Occurs        values (7, daily);
insert into Occurs        values (4, weekly);

insert into Closed_Day    values (4, 070406, 4th of july);
/* Group 5 */
/*ORGANIZATION*/
insert into Organization values(777,3,'Group 5 Inc');

/*offices*/
insert into Office values(42,777,'Chuck's Insurance Co',
                        'Suite 3250',1);
insert into office values(43,777,'dr. phil the shrink',
                        'phil's house',1);
insert into Office values(44, 777, 'Making Money For Profit',
                        'In the Pantry',3);


/*Persons*/
insert into Person values(200,'Billy-bob','Thorton',
        123432231,13155913633,'bbob@thortonrules.com',
        '123 east 6th ave','O-town','NY',13126);
insert into Person values(201,'Jack','TheRipper',
        666666666,13256666666,'ikill4fun@yahoo.com',
        '666 satan alley','O-town','NY',13666);
insert into Person values(202,'dr.','phil',
        110873456,18004377445,'advice4u@drphil.com',
        '123 main street','anywhere','pa',12345);
insert into Person values(203,'chuck','norris',
        555666779,15184387669,'roundhouse@kick.com',
        '123 Awesome St','Albany','NY',12208);
insert into Person values(204,'Phil,'Gordon',
        101010101,13244567899,'idominatepoker@fulltiltpoker.com',
        '99999 bling bling ave','O-town','NY',13232);
insert into Person values(205,'Random','Person',
        123456789,12345678900,'random@person.com',
        '45678 random drive','0-town','NY',13126);


/*professional*/
insert into Professional values(203,42,true);
insert into Professional values(202,43,true);
insert into Professional values(204,44,true);
insert into Professional values(200,44,true);
insert into Professional values(201,44,true);

/**Days open**/
insert into Day values(42,'monday','08:00:00','16:30:00',30);
insert into Day values(42,'tuesday','08:00:00','16:30:00',30);
insert into Day values(42,'thursday','08:00:00','16:30:00',30);

insert into Day values(44,'sunday','08:00:00','20:00:00',24);
insert into Day values(44,'monday','08:00:00','20:00:00',24);
insert into Day values(44,'tuesday','08:00:00','20:00:00',24);
insert into Day values(44,'wednesday','08:00:00','20:00:00',24);
insert into Day values(44,'thursday','08:00:00','20:00:00',24);
insert into Day values(44,'friday','08:00:00','20:00:00',24);
insert into Day values(44,'saturday','08:00:00','20:00:00',24);

insert into Day values(43,'sunday','04:30:00','13:30:00',1);
insert into Day values(43,'monday','04:30:00','13:30:00',1);
insert into Day values(43,'tuesday','04:30:00','13:30:00',1);
insert into Day values(43,'thursday','04:30:00','13:30:00',1);
insert into Day values(43,'friday','04:30:00','13:30:00',1);
insert into Day values(43,'saturday','04:30:00','13:30:00',1);
/* Chen */
insert into organization values (392,2, 'Dealie Auto');
insert into organization values (829,2, 'Corvel');
insert into organization values (283,1, 'Beckham Soccer Outlet');
insert into organization values (182,3, 'Prudential Financial');
insert into organization values (293,2, 'Expedition Watches');
insert into organization values (329,1, 'USA tees');
insert into organization values (872,3, 'Distinguished Fashion');
insert into organization values (102,2, 'Unsolicited Telemarketing');

insert into office values (100, 182, 'Financial', '231 West Peyton', 2);
insert into office values (120, 329, 'Administrative', '982 East Syracuse', 3);
insert into office values (121, 872, 'Internal Auditing', 'Claymore Avenue', 2);
insert into office values (99, 102, 'Consumer Services', 'Breton Drive', 1);
insert into office values (124, 293, 'Payroll', 'Lancer Boulevard', 2);

insert into day values (100, Tuesday, '07:00:00', '19:00:00', 24);
insert into day values (120, Monday, '07:00:00', '19:00:00', 24);
insert into day values (121, Friday, '07:00:00', '19:00:00', 24);
insert into day values (99, Monday, '07:00:00', '19:00:00', 24);
insert into day values (124, Wednesday, '07:00:00', '19:00:00', 24);

insert into person values (13, 'Michael Breton', 892921232, 2329012, 'mbret@mailinator.com', '23
Courtesy Drive', 'Clayton', 'Arizona', 98123);
insert into person values (21, 'Daniel Muse', 900219322, 9829123, 'dMuse@mailinator.com', '891 Hvak
St', 'Reno', 'Nevada', 55623);
insert into person values (74, 'Linda Favre', 122327676, 9021121, 'lFavre@mailinator.com', '982 Hou
Van Road', 'Anchorage', 'Alaska', 11212);
insert into person values (69, 'Colleen Demarco', 112567212, 6463180, 'cDem@mailinator.com', '9882
Schatje Road', 'Weedsport', 'New York', 98823);
insert into person values (85, 'Josephine Faust', 092908712, 8063161, 'jF@mailinator.com', '982
Haute Vous Street', 'Euclid', 'Ohio', 91212);

insert into professional values (79, 100, true);
insert into professional values (13, 120, true);
insert into professional values (19, 121, true);
insert into professional values (32, 99, true);
insert into professional values (10, 124, true);

insert into appointment values (928, 100, 79, 10, '20-02-06', '07:00:00', '19:00:00');
insert into appointment values (2345, 120, 13, 32, '12-19-06', '07:00:00', '19:00:00');
insert into appointment values (1231, 121, 19, 19, '11-26-06', '07:00:00', '19:00:00');
insert into appointment values (1902, 99, 32, 13, '01-14-06', '07:00:00', '19:00:00');
insert into appointment values (12, 124, 10, 79, '07-02-06', '07:00:00', '19:00:00');

insert into personal_time values (192, 79, 42, 2, '20-01-06', '15:00:00', '15:30:00');
insert into personal_time values (199, 13, 34, 2, '15-03-06', '12:20:00', '12:50:00');
insert into personal_time values (012, 19, 22, 2, '12-09-06', '15:00:00', '15:30:00');
insert into personal_time values (112, 32, 67, 2, '02-02-06', '19:00:00', '19:30:00');
insert into personal_time values (42, 10, 98, 2, '07-01-06', '10:00:00', '10:30:00');

insert into occurs values (42, 'weekly');
insert into occurs values (34, 'weekly');
insert into occurs values (22, 'monthly');
insert into occurs values (67, 'monthly');
insert into occurs values (98, 'weekly');

insert into closed_day values (100, 030206, 'Administrative Maintenance');
insert into closed_day values (120, 040206, 'Janitorial Maintenance');
insert into closed_day values (121, 062906, 'Server Maintenance');
insert into closed_day values (94, 020506, 'Staff Training');
insert into closed_day values (124, 010106, 'Staff Meeting');
/* Patrick Dunn
 * CSC 459
 * Project 2 - Inserts for data
 
/*
 * Organization Table Data
*/

insert into organization values(101,2,"PWD Net Consulting");

/*
 * Office Table Data
*/

insert into office values(200,101,"PWD Net - Jamesville Office","123 Anystreet. Jamesville, NY 13078",2);
insert into office values(201,101,"PWD Net - Tully Office","123 Anystreet. Tully, NY 13159",1);

/*
 * Person Table
*/

insert into person values(1000,"Bob","Jones",012222012,3155551122,"bobjones@gmail.com","565 Anystreet","Jamesville","NY",13078);
insert into person values(1001,"Peter","Smith",058656565,3158889955,"petersmith@gmail.com","569 Anystreet","Tully","NY",13159);
insert into person values(1002,"Jack","Bauer",458258989,3151234567,"jackbauer@ctu.la.gov","122 Anystreet","Jamesville","NY",13078);
insert into person values(1003,"Patrick","Dun",077080905,3152223333,"pdunn5@gmail.com","589 Anystreet","Jamesville","NY",13078);

/*
 * Appointment Table
*/

insert into appointment values(900001,200,1003,1000,03242006,09:00,10:00);
insert into appointment values(900002,201,1002,1001,03272006,14:00,15:00);
insert into appointment values(900003,200,1003,1000,03282006,18:00,19:00);
insert into appointment values(900004,201,1002,1001,07152006,09:00,10:00);

/*
 * Professional Table
*/

insert into professional values(1002,200,true);
insert into professional values(1003,201,true);

/*
 * Closed_Day Table
*/

insert into closed_day(200,12252006,"Christmas");
insert into closed_day(201,12252006,"Christmas");
insert into closed_day(200,07042006,"Independence Day");
insert into closed_day(201,07042006,"Independence Day");
insert into closed_day(200,05312006,"Memorial Day");
insert into closed_day(201,05312006,"Memorial Day");
insert into closed_day(200,09032006,"Labor Day");
insert into closed_day(201,09032006,"Labor Day");

/*
 * Day Table
*/

/* Jamesville Office */

insert into day values(200,"Monday",08:00,16:00,60);
insert into day values(200,"Wednesday",08:00,16:00,60);
insert into day values(200,"Friday",08:00,12:00,60);

/* Tully Office */
insert into day values(201,"Tuesday",08:00,16:00,60);
insert into day values(201,"Thursday",08:00,12:00,60);

/*
 * Occurs Table
*/

insert into occurs(60001,"daily");
insert into occurs(60002,"weekly");
insert into occurs(60003,"bi-weekly");
insert into occurs(60004,"monthly");

/*
 * Personal_Time Table
*/

insert into personal_time values(50001,1002,60001,2,03282006,08:00,12:00);
insert into personal_time values(50002,1003,60002,1,03272006,12:00,02:00);
insert into personal_time values(50003,1002,60003,7,07152006,08:00,16:00);
insert into personal_time values(50003,1002,60004,7,08102006,08:00,09:00);

/* Group 1 */
Insert into APPOINTMENT values(1, 1, 843087, 433243, '03/24/06', '0800', '1000');
Insert into APPOINTMENT values(2, 1, 905764,  892035, '04/1/06', '1400', '1500');

Insert into APPOINTMENT values(12, 2, 234203, 965831, '04/01/06', '1400', '1500');
Insert into APPOINTMENT values(23,2, 435093, 234577, '03/21/06', '0900', '0930');

Insert into APPOINTMENT values(18,3, 909740, 324523, '05/26/06', '0730', '900');
Insert into APPOINTMENT values(19, 3, 903222 , 249212, '04/02/06', '1500', '1700');

Insert into APPOINTMENT values(34, 4, 198323,  549394 , '04/04/06', '1430', '1600');
Insert into APPOINTMENT values(14, 4, 123123, 023443, '04/02/06', '1030', '1100');

Insert into APPOINTMENT values(15, 5, 012020, 659943 , '04/02/06', '1030', '1100');
Insert into APPOINTMENT values(54, 5,  001012 , 366325, '03/31/06', '0830', '1200');

Insert into Closed_Day( 1,'08/12/06','Holiday');
Insert into Closed_Day(2 ,'05/26/06','Vacation');
Insert into Closed_Day(3 ,'04/13/06','Weekend');
Insert into Closed_Day(2 ,'09/02/06','Lunch');
Insert into Closed_Day(4 ,'08/02/06','Holiday');
Insert into Closed_Day(5 ,'05/06/06','Vacation');
Insert into Closed_Day(3 ,'04/03/06','Weekend');
Insert into Closed_Day(1 ,'09/12/06','Lunch');


Insert into Occurs values(4275,'daily');
Insert into Occurs values(4295,'monthly');
Insert into Occurs values(4254,'weekly');
Insert into Occurs values(4235,'yearly');
Insert into Occurs values(4555,'daily');
Insert into Occurs values(4458,'monthly');
Insert into Occurs values(3984,'weekly');
Insert into Occurs values(6339,'yearly');

 /* Professionals persons are BELOW */

Insert into People values(001012, ' Thomas  ' ,  ' Cappetta  ', 123322332 , 3122133111, 'troc@os.edu', '75 West side ', 'Miami, FL' , '13126');

Insert into People value(012020, 'Thomas', 'Sylvestor', 903293092, 5674902938, '5943 Middle Border Dr', 'Miami, FL' , '13126');

Insert into People values(123123 , ' Dorothy   ' ,  ' Halliday  ',  123432590, 3124412999, 'halliday@os.edu', '32 West side ','Houston, TX' , '13126');

Insert into People values( 198323, 'Cynthia', 'Powers', 930293940, 8910293201, 
'powers@yahoo.com ',  'Houston, TX' , '13126');


Insert into People values(909740, ' Debby   ' ,  'BackBreaker  ',  002330090, 7212329112, ' mich@ebay.com ', '43 Small lite rd ', 'Chicago, IL' , '11727');

Insert into People values(903222, 'Ronald', 'Baker', 039498232, 4329300222, 'baker@baker.com ' , 
'7832 Richard Dr',  'Chicago, IL' , '11727');

Insert into People values(435093 , ' Jenna  ' ,  ' Jamison  ',  220009989,  4529238111, ' minny@ebay.com ', '983 Fort Del rd', 'Los Angelos, CA' , '11727');

Insert into People values(234203, 'Josh', 'Superman', 389297302, 9387293992, 'superman@yahoo.com ' , '797 Flight Dr',  'Los Angelos, CA' , '11727');


Insert into People values(843087 , ' Fred  ' ,  ' Johnstown  ',  322343223, 9039321001, ' joe@ebay.com ', '923 Cracker Lane ', 'New York','NY' , '11727');

Insert into People values(905764 , ' Lisa   ' ,  ' Helw  ', 433434555, 0998112332, ' jonny@wester.com ', ' 732 Hell drive', 'New York','NY' , '11784');


/* CLIENTS ARE BELOW */

/* texas*/
Insert into People values(366325, 'Lynn', 'Whippersnapper', 676980039, 3494020494, 'whipper@whip.com', '543 Heist Dr, 'Houston, TX'  , '11784');

Insert into People values(659943, 'Tyson', 'Littleman', 900392042, 9040938495, 'ty@yahoo.com ', 
'593 Differential Dr, 'Houston, TX'  , '11784');

Insert into People values(892350 , ' Lousey    ' ,  ' Lou  ',  989090999, 9872324556, ' justin@wester.com ', '342 Marshall Dr ', 'Houston, TX'  , '11784');



/*Miami*/

Insert into People values( 023443, 'Tim', 'Tooter', '034923450, 1023920321, 'timTooter@yahoo.com ', 
'39 Independent Dr.', 'Miami, FL' , '11784');

Insert into People value(549394, 'Greg', 'Fuller', 920293832, 9012893999, 'fuller@edu.com ', '7895 Missing People Dr.' 'Miami, FL' , '11784'); 

Insert into People values(987324 , ' Don   ' ,  'Mattingly  ',  011080922, 8779880598 , ' superman@wester.com ', '34 Yankee Stadium Dr ', 'Miami, FL' , '11784');



/*Chicago*/
Insert into People values(249212, ' Joe ' ,  ' Jackson  ',   048564392 ,  3452320990, ' weiner@yahoo.com ', '45 Marshall Dr ', 'Chicago, IL' , '11784');

Insert into People values(324523 , ' Mike  ' ,  ' Jones  ',   902873553 ,  0932930221 ' oscar@yahoo.com ', '34532 St Rt 31 ', 'Chicago, IL' );

Insert into People values(234523 , ' Big Mama   ' ,  ' Jones  ',   754339009 ,  5469880990 , ' meyer@yahoo.com ', '23 Side Road ', 'Chicago, IL' );



/*LA*/
Insert into People values(234577 , ' Jumangee   ' ,  ' Oleary  ',   543670770,  6539890221 , ' rickJames@gmail.com ', '09321 West City Drive ', 'Los Angelos, CA' , '13041');

Insert into People values(965831 , ' Minnie   ' ,  ' Mouse  ',   897397103 ,  4392893774  , ' pimpinAintEasy@gmail.com ', ' 87 Tree lane ', 'Los Angelos, CA' , '13069');

Insert into People values(009343 , ' Mickey   ' ,  ' Mouse ',   096745214 ,   3123218922 , ' disneyWorld@gmail.com ',  '143 Mickey Dr ', 'Los Angelos, CA' , '13069');


/*NY*/
Insert into People values(892035 , ' Tiny   ' ,  ' John  ',  145398559 , 7932838172, ' studio48@gmail.com ', '69 Studio 48 Rd ', 'New York','NY' , '13069');

Insert into People values(433243, 'Holly','Berry', 897098734 , 4345640909, '  berry@er.com' , '743 Setter Dr', 'New York','NY' , '12032);

Insert into People values(542093, 'Ivan', 'Instant', 903435676, 3244329833, ' instant@ivan.com ', 454 InterState Rd', 'New York','NY' , '65434');

Insert into Personal_Time values(5445, 843087, 5626, 2656,'03/24/2006','1030','1100');
Insert into Personal_Time values(7522, 905764, 8545, 6598,'05/14/2006','1330','1400');
Insert into Personal_Time values(5645, 234203  , 5628, 2556,'06/04/2006','0930','1000')
Insert into Personal_Time values(5845, 435093  , 5627, 2756,'07/23/2006','1500','1530');
Insert into Personal_Time values(8445, 909740 , 5776, 2010,'04/24/2006','1630','1700');
Insert into Personal_Time values(6522, 903222  , 8544, 6590,'05/11/2006','1100','1130');
Insert into Personal_Time values(9645, 198323 , 1328, 1556,'06/16/2006','0900','0930');
Insert into Personal_Time values(3845, 012020, 5622, 2729,'06/21/2006','1400','1430');

/* THERE ARE ONLY 10 PROFESSIONALS ~V 2 per office */

Insert into  PROFESSIONAL values( 843087 , 1 , 'true' );
Insert into  PROFESSIONAL values( 905764, 1 , 'true' );

Insert into  PROFESSIONAL values( 234203 ,  2 , 'true' );
Insert into  PROFESSIONAL values( 435093 ,  2 , 'true' );


Insert into  PROFESSIONAL values( 909740 , 3 , 'true' );
Insert into  PROFESSIONAL values( 903222 , 3 , 'true' );

Insert into  PROFESSIONAL values( 198323  , 4 , 'true' );
Insert into  PROFESSIONAL values( 123123 , 4 , 'true' );

Insert into  PROFESSIONAL values( 012020 , 5 , 'true' );
Insert into  PROFESSIONAL values( 001012 , 5 , 'true' );


