Database:

ACTUAL DATA - Data for ConferenceDB

 -- BUILDING (Id, Name) DROP TABLE IF EXISTS `BUILDING`; CREATE TABLE `BUILDING`( Id INT, Name VARCHAR(20), PRIMARY KEY (Id) )ENGINE = InnoDB; INSERT INTO `BUILDING` VALUES (1, 'Edwards'), (2, 'Hartwell'), (3, 'Seymour Union'), (4, 'Tower'); -- DONE-- -- TIME_SLOT (TimeSlotId, StartTime, EndTime) DROP TABLE IF EXISTS `TIME_SLOT`; CREATE TABLE `TIME_SLOT`( TimeSlotId INT, StartTime VARCHAR(10), EndTime VARCHAR(10), PRIMARY KEY (TimeSlotId) )ENGINE = InnoDB; INSERT INTO `TIME_SLOT` VALUES (1, '09:00 AM', '10:30 AM'), (2, '10:45 AM', '11:45 AM'), (3, '01:15 PM', '02:15 PM'), (4, '02:30 PM', '03:30 PM'), (5, '03:45 PM', '04:45 PM'); -- DONE -- -- ROOM (RoomId, BuildingId, RoomName, Capacity) DROP TABLE IF EXISTS `ROOM`; CREATE TABLE `ROOM`( RoomId VARCHAR(32), BuildingId INT, RoomName VARCHAR(32), Capacity INT, PRIMARY KEY (RoomId, BuildingId), FOREIGN KEY (BuildingId) REFERENCES BUILDING.BuildingId ); INSERT INTO `ROOM` VALUES ('101', 1, ' ', 50), ('102', 1, ' ', 50), ('103', 1, ' ', 50), ('104', 1, ' ', 50), ('105', 1, ' ', 50), ('106', 1, ' ', 50), ('107', 1, ' ', 50), ('011', 2, ' ', 50), ('014', 2, ' ', 50), ('027', 2, ' ', 50), ('028', 2, ' ', 50), ('029', 2, ' ', 50), ('030', 2, ' ', 50), ('031', 2, ' ', 50), ('033', 2, ' ', 50), ('120', 2, ' ', 50), ('122', 2, ' ', 50), ('123', 2, ' ', 50), ('125', 2, ' ', 50), ('127', 2, ' ', 50), ('214', 2, ' ', 50), ('215', 2, ' ', 50), ('216', 2, ' ', 50), ('217', 2, ' ', 50), ('218', 2, ' ', 50), ('219', 2, ' ', 50), ('221', 2, ' ', 50), ('102', 4, ' ', 50), ('120', 4, ' ', 50), ('1107 Black Box', 4, ' ', 50), ('Dance Theater', 2, ' ', 50), ('Strasser Studio', 2, ' ', 50), ('Main Lounge', 3, ' ', 50), ('Outside NE Corner', 4, ' ', 50); -- DONE -- SUBJECT_CATEGORY(SubjectId, Description) DROP TABLE IF EXISTS `SUBJECT_CATEGORY`; CREATE TABLE `SUBJECT_CATEGORY`( SubjectId INT, Description VARCHAR(64), PRIMARY KEY (SubjectId) )ENGINE = InnoDB; INSERT INTO `SUBJECT_CATEGORY` VALUES (1, 'Anthropology'), (2, 'Art'), (3, 'Arts for Children'), (4, 'Biology'), (5, 'Business'), (6, 'Chemistry'), (7, 'Communication'), (8, 'Computer Science'), (9, 'Criminal Justice'), (10, 'Dance'), (11, 'Delta College'), (12, 'Earth Science'), (13, 'Economics and Finance'), (14, 'Education and Human Development'), (15, 'English'), (16, 'Environmental Science And Biology'), (17, 'Health Science'), (18, 'Health Science/Sociology'), (19, 'History'), (20, 'Interdisciplinary'), (21, 'Kinesiology, Sport Studies and Physical Education'), (22, 'Leadership Development'), (23, 'Mathematics'), (24, 'Modern Languages'), (25, 'Music'), (26, 'Nursing'), (27, 'Overseas Academic Programs'), (28, 'Philosophy'), (29, 'Physics'), (30, 'Political Science'), (31, 'Psychology'), (32, 'Recreation and Leisure Studies'), (33, 'Social Work'), (34, 'Theatre'), (35, 'Women And Gender Studies'); -- DONE -- PERSON (PersonId, LastName, FirstName, Email) DROP TABLE IF EXISTS `PERSON`; CREATE TABLE `PERSON`( PersonId INT, LastName VARCHAR(20), FirstName VARCHAR(20), Email VARCHAR(64), PRIMARY KEY (PersonId), UNIQUE LN_FN (LastName, FirstName) )ENGINE = InnoDB; INSERT INTO `PERSON` VALUES (1, 'Reviewer', 'General','reviwer@brockport.edu'), (2, 'Keating', 'Neal', ' '), (3, 'Jakubec', 'Shane',' '), (4, 'Rodriguez', 'Merida', ' '), (5, 'Ryan', 'Nicole', ' '), (6, 'Cho', 'Oh-Kon', ' '), (7, 'Angelo', 'Chelsie',' '), (8, 'Del Favero', 'Sarah', ' '), (9, 'Fereira', 'Kaleena', ' '), (10,'Gee', 'Alissa',' '), (11, 'Gothel', 'Nancy', ' '), (12, 'Haggerty', 'Emily', ' '), (13, 'Howland', 'Alexander', ' '), (14, 'Mazza', 'Bernadetta', ' '), (15, 'Schenk', 'Keifer', ' '), (16, 'Washington', 'Kathleen', ' '), (17, 'Walck', 'Megan', 'person@brockport.edu'), (18, 'Stoeckeler', 'Erica', 'person@brockport.edu'), (19, 'Suarez', 'Juanita', 'person@brockport.edu'), (20, 'Szilagyi', 'Janka', 'person@brockport.edu'), (21, 'Singh', 'Teresa', 'person@brockport.edu'), (22, 'Redman', 'Holly', 'person@brockport.edu'), (23, 'Robertson', 'Timothy', 'person@brockport.edu'), (24, 'Raymond', 'Colby', 'person@brockport.edu'), (25, 'Reger', 'Noah', 'person@brockport.edu'), (26, 'Rua', 'Robert', 'person@brockport.edu'), (27, 'Sachs', 'Moriah', 'person@brockport.edu'), (28, 'Sendker', 'Megan', 'person@brockport.edu'), (29, 'Sklar', 'Nicole', 'person@brockport.edu'), (30, 'Smith', 'Holly', 'person@brockport.edu'), (31, 'Soos', 'Meghan', 'person@brockport.edu'), (32, 'Swanson', 'Brent', 'person@brockport.edu'), (33, 'Tapia', 'Francisco', 'person@brockport.edu'), (34, 'Warren', 'Christine', 'person@brockport.edu'), (35, 'Watson', 'Hope', 'person@brockport.edu'), (36, 'Wesley', 'Angela', 'person@brockport.edu'), (37, 'Wodrasha', 'Brittany', 'person@brockport.edu'), (38, 'Wodraska', 'Amber', 'person@brockport.edu'), (39, 'Young', 'Megan', 'person@brockport.edu'), (40, 'Vandervoort', 'Kristen', 'person@brockport.edu'), (41, 'Rondon-Pari', 'Graziela', 'person@brockport.edu'), (42, 'Rush', 'Eric', 'person@brockport.edu'), (43, 'Smith', 'Michelle', 'person@brockport.edu'), (44, 'Schneider', 'Robert', 'person@brockport.edu'), (45, 'Weaver', 'Hilary', 'person@brockport.edu'), (46, 'Sikorski', 'Becca', 'person@brockport.edu'), (47, 'Urena', 'Sherly', 'person@brockport.edu'), (48, 'Scirvani', 'Emily', 'person@brockport.edu'), (49, 'Ramsay', 'Jennifer', 'person@brockport.edu'), (50, 'Smith', 'Kaleigh', 'person@brockport.edu'), (51, 'Wexler', 'Emily', 'person@brockport.edu'), (52, 'Zaccheus', 'Oladoyin', 'person@brockport.edu'), (53, 'Williams', 'Carissa', 'person@brockport.edu'), (54, 'Scharf', 'Nathan', 'person@brockport.edu'), (55, 'Vazguez', 'Pedro', 'person@brockport.edu'), (56, 'Walik', 'Andrew', 'person@brockport.edu'), (57, 'Smathers', 'Amanda', 'person@brockport.edu'), (58, 'Wilcox', 'Tamara', 'person@brockport.edu'), (59, 'Schreder', 'Janet', 'person@brockport.edu'), (60, 'Spraker', 'Chelsea', 'person@brockport.edu'), (61, 'Surman', 'Audra', 'person@brockport.edu'), (62, 'Ryan', 'Heather', 'person@brockport.edu'), (63, 'Perira', 'Gustavo', 'person@brockport.edu'), (64, 'Parker', 'Nicole', 'person@brockport.edu'), (66, 'York', 'Julia', 'person@brockport.edu'), (68, 'Smith', 'Rebecca', 'person@brockport.edu'), (69, 'Steir', 'William', 'person@brockport.edu'), (70, 'Smith', 'Roxanne', 'person@brockport.edu'), (71, 'Rice', 'Michael', 'person@brockport.edu'), (72, 'Wahl', 'Gregory', 'person@brockport.edu'), (73, 'Thomas', 'Devon', 'person@brockport.edu'), (74, 'Stephenson', 'Elizabeth', 'person@brockport.edu'), (75, 'Ralph', 'P. Gibson', 'person@brockport.edu'), (76, 'Spencer', 'Craig', 'person@brockport.edu'), (77, 'Stout', 'Collin', 'person@brockport.edu'), (78, 'Rowe', 'Brittney', 'person@brockport.edu'), (79, 'Ram', 'Seetha', 'person@brockport.edu'), (80, 'Yadava', 'Krishna', 'person@brockport.edu'), (81, 'Warner', 'Kevin', 'person@brockport.edu'), (82, 'Rearic', 'Lindsey', 'person@brockport.edu'), (83, 'Shaughnessy', 'Lyndsey', 'person@brockport.edu'), (84, 'Simon', 'Julia', 'person@brockport.edu'), (85, 'Simon', 'Veronica', 'person@brockport.edu'), (86, 'Sinchak', 'Marie', 'person@brockport.edu'), (87, 'Stewart', 'Tricia', 'person@brockport.edu'), (88, 'Szywala', 'Lauren', 'person@brockport.edu'), (89, 'Tozer', 'Stephanie', 'person@brockport.edu'), (90, 'Voges', 'Wayne', 'person@brockport.edu'), (91, 'Warncke', 'Kerstin', 'person@brockport.edu'), (92, 'Weinman', 'Maureen', 'person@brockport.edu'), (93, 'Tsubota', 'Stuart', 'person@brockport.edu'), (94, 'Trimboli', 'Joseph','person@brockport.edu'), (95, 'Yaeger', 'Kathryn','person@brockport.edu'), (96, 'Ryan', 'Theodore', 'person@brockport.edu'), (97, 'Shpakovych', 'Yevgen', 'person@brockport.edu'), (98, 'Vengelova', 'Milena', 'person@brockport.edu'), (99, 'Randolph', 'Joshua', 'person@brockport.edu'), (100, 'Sciandra', 'Nicole', 'person@brockport.edu'), (101, 'Strife', 'Kyle', 'person@brockport.edu'), (102, 'Wagner', 'Nicholas', 'person@brockport.edu'), (103, 'Rajasethupathy', 'Kulathur', 'person@brockport.edu'), (104, 'Zollweg', 'James', 'person@brockport.edu'), (105, 'Richard', 'Turner', 'person@brockport.edu'), (106, 'Wright', 'Allison', 'person@brockport.edu'), (107, 'Zhang', 'Jie', 'person@brockport.edu'), (108, 'Snyder', 'Andrew', 'person@brockport.edu'), (109, 'Rosekrans', 'Taylor', 'person@brockport.edu'), (110, 'Sepulveda', 'Brianna', 'person@brockport.edu'), (111, 'Ray', 'Michael', 'person@brockport.edu'), (112, 'Schubel', 'Natalie', 'person@brockport.edu'), (113, 'Wolniewicz', 'Christine', 'person@brockport.edu'), (114, 'Restina', 'Alexandra', 'person@brockport.edu'), (115, 'Thompsell', 'Angela', 'person@brockport.edu'), (116, 'Van Hooft', 'Amy', 'person@brockport.edu'), (117, 'Pandava', 'Arjuna', 'person@brockport.edu'), (118, 'Underwood', 'Alise', 'person@brockport.edu'), (119, 'Pandava', 'Bhima', 'person@brockport.edu'), (120, 'Simon', 'Lauren', 'person@brockport.edu'), (121, 'Stephany', 'Matthew', 'person@brockport.edu'), (122, 'Singh', 'Gurpreet', 'person@brockport.edu'), (123, 'Smith', 'Krysta', 'person@brockport.edu'), (124, 'Radford', 'Stanley', 'person@brockport.edu'), (125, 'Tahar', 'Mohammed', 'person@brockport.edu'), (126, 'Ratcliff', 'Jennifer', 'person@brockport.edu'), (127, 'Witnauer', 'James', 'person@brockport.edu'), (128, 'Wojick', 'Brittany', 'person@brockport.edu'), (129, 'Rinella', 'Mark', 'person@brockport.edu'), (130, 'Rounds', 'Kala', 'person@brockport.edu'), (131, 'Rich', 'Katelyn', 'person@brockport.edu'), (132, 'Sargeant', 'Sarah-Catherine', 'person@brockport.edu'), (133, 'Stanonis', 'Jennifer', 'person@brockport.edu'), (134, 'Starr', 'John', 'person@brockport.edu'), (135, 'Turner', 'Claire', 'person@brockport.edu'), (136, 'Van Buren', 'Patricia', 'person@brockport.edu'), (137, 'Vanamburg', 'Karl', 'person@brockport.edu'), (138, 'Vandewater', 'Caitlin', 'person@brockport.edu'), (139, 'Webber', 'Linda', 'person@brockport.edu'), (140, 'Spallina', 'Margaret', 'person@brockport.edu'), (141, 'Whitman', 'Mary Jo', 'person@brockport.edu'), (142, 'Rafael', 'Melnard Chilyn', 'person@brockport.edu'), (143, 'Sylvester', 'Erica', 'person@brockport.edu'), (144, 'Yamada', 'Mariko', 'person@brockport.edu'), (145, 'Seidel', 'Hannah', 'person@brockport.edu'), (146, 'Rauber', 'Christopher', 'person@brockport.edu'), (147, 'Strivings', 'Jonathan', 'person@brockport.edu'), (175, 'Selbert', 'Chad', 'person@brockport.edu'), (148, 'Simpson', 'Michael', 'person@brockport.edu'), (149, 'Scotty', 'Kristen', 'person@brockport.edu'), (150, 'Sanderson-Kilchenstein', 'David', 'person@brockport.edu'), (151, 'Torre', 'Jose', 'person@brockport.edu'), (152, 'Welch', 'Brittany', 'person@brockport.edu'), (153, 'Stachowski', 'Ann', 'person@brockport.edu'), (154, 'Sarrazin', 'Natalie', 'person@brockport.edu'), (155, 'Gowda', 'Range', 'person@brockport.edu'), (156, 'Modi', 'Narendra', 'person@brockport.edu'), (157, 'Kichha', 'Sudeepa ', 'person@brockport.edu'), (158, 'Wolniewicz', 'Patricia', 'person@brockport.edu'), (159, 'Simpson', 'Neil', 'person@brockport.edu'), (160, 'Tripoli', 'Marisa', 'person@brockport.edu'), (161, 'Samantha ', 'Vakiener', 'person@brockport.edu'), (162, 'Russo', 'Stephanie', 'person@brockport.edu'), (163, 'Valentin', 'Christina', 'person@brockport.edu'), (164, 'Rey', 'Sia', 'person@brockport.edu'), (165, 'Walker', 'Kyle', 'person@brockport.edu'), (166, 'Singla', 'Ramesh', 'person@brockport.edu'), (167, 'Thompson', 'Howard', 'person@brockport.edu'), (168, 'Schneider', 'Alisha', 'person@brockport.edu'), (169, 'Townsend', 'Kathryn', 'person@brockport.edu'), (170, 'Whittingham', 'Elizabeth', 'person@brockport.edu'), (171, 'Schenk', 'Kiefer', 'person@brockport.edu'), (172, 'Sparling', 'Andrew', 'person@brockport.edu'), (173, 'Whorton', 'James', 'person@brockport.edu'), (174, 'Wilcox', 'Douglas', 'person@brockport.edu'); -- SESSION-1 I-P (Rao) INSERT INTO `PERSON` VALUES (247, 'Johns', 'Laura', 'person@brockport.edu'), (176, 'Paulus', 'Leah', 'person@brockport.edu'), (177, 'Kazin', 'Gary', 'person@brockport.edu'), (178, 'Lipomi', 'Adriana', 'person@brockport.edu'), (179, 'Pratt', 'Bryan', 'person@brockport.edu'), (180, 'Phillips', 'Bianca', 'person@brockport.edu'), (181, 'Podyma', 'Chelsea', 'person@brockport.edu'), (182, 'Mahaney', 'Megan', 'person@brockport.edu'), (183, 'Lawrence', 'Imani', 'person@brockport.edu'), (184, 'Perez', 'Jasmin', 'person@brockport.edu'), (185, 'Peak', 'Allison', 'person@brockport.edu'), (186, 'Kirk', 'Ariel', 'person@brockport.edu'), (187, 'Pena', 'Jose', 'person@brockport.edu'), (188, 'Ippolito', 'Michael', 'person@brockport.edu'), (189, 'Knapp', 'Gregory', 'person@brockport.edu'), (190, 'Ko', 'Chuck', 'person@brockport.edu'), (191, 'Krasicki', 'Ashley', 'person@brockport.edu'), (192, 'McKinney_Henry', 'Janay', 'person@brockport.edu'), (193, 'Meehan', 'Nicole', 'person@brockport.edu'), (194, 'Mitchell', 'Alyssa', 'person@brockport.edu'), (195, 'Monti', 'Emily', 'person@brockport.edu'), (196, 'Moore', 'McKenzi', 'person@brockport.edu'), (197, 'Mundroff', 'Chelsie', 'person@brockport.edu'), (198, 'Nusri', 'Paul', 'person@brockport.edu'), (199, 'Newbill', 'Alesha', 'person@brockport.edu'), (200, 'Newby', 'Jessica', 'person@brockport.edu'), (201, 'Oaks', 'Kathryn', 'person@brockport.edu'), (202, 'Perez', 'Amisail', 'person@brockport.edu'), (203, 'Peter', 'Yanicka', 'person@brockport.edu'), (204, 'Prichard', 'Gerard', 'person@brockport.edu'), (205, 'Motkovski', 'Gregory', 'person@brockport.edu'), (206, 'Kerr', 'Jessica', 'person@brockport.edu'), (207, 'Bachhan', 'Amitabh', 'person@brockport.edu'), (208, 'Muscato', 'Matthew', 'person@brockport.edu'), (209, 'Platt', 'Deanna', 'person@brockport.edu'), (210, 'Lester', 'Kent', 'person@brockport.edu'), (211, 'Parelka', 'Georgiana', 'person@brockport.edu'), (212, 'Platner', 'Mallory', 'person@brockport.edu'), (213, 'Nunnery', 'Brandon', 'person@brockport.edu'), (214, 'Laporta', 'Kathryn', 'person@brockport.edu'), (215, 'Merryman', 'Rachel', 'person@brockport.edu'); INSERT INTO `PERSON` VALUES (216, 'Padalino', 'Madelyn', 'person@brockport.edu'), (217, 'Morasco', 'Matthew', 'person@brockport.edu'), (218, 'Olek', 'Austin', 'person@brockport.edu'), (219, 'Llewellyn', 'Tysha', 'person@brockport.edu'), (220, 'Nutting', 'Michael', 'person@brockport.edu'), (221, 'McDonald', 'Brittany', 'person@brockport.edu'), (222, 'Muzzy', 'Angie', 'person@brockport.edu'), (223, 'Kohler', 'Andrew', 'person@brockport.edu'), (224, 'Kumar', 'Kishore', 'person@brockport.edu'), (225, 'LaLonde', 'Kathy', 'person@brockport.edu'), (226, 'Novarro', 'Alyssa', 'person@brockport.edu'), (227, 'Lonsberry', 'Hannah', 'person@brockport.edu'), (228, 'Mitrakos', 'Tiffany', 'person@brockport.edu'), (229, 'Kosek', 'Peter', 'person@brockport.edu'), (230, 'Loveless', 'Amanda', 'person@brockport.edu'), (231, 'Micale', 'Elisa', 'person@brockport.edu'), (232, 'Khanna', 'Matthew', 'person@brockport.edu'), (233, 'Pundit', 'Kent', 'person@brockport.edu'), (234, 'Pruner', 'Rachel', 'person@brockport.edu'), (235, 'Melnychuck', 'Nazariy', 'person@brockport.edu'), (236, 'Jeckovich', 'Sarah', 'person@brockport.edu'), (237, 'Mack', 'Tabatha', 'person@brockport.edu'), (238, 'Jacobs', 'Lincoln', 'person@brockport.edu'), (239, 'Kapaan', 'Joanna', 'person@brockport.edu'), (240, 'Nichols', 'Tyrone', 'person@brockport.edu'), (241, 'ONeill', 'Wayne', 'person@brockport.edu'), (242, 'Holzschuh', 'Jennalee', 'person@brockport.edu'), (243, 'Thomas-Bell', 'Jacqueline', 'person@brockport.edu'), (244, 'Thomas', 'Richard', 'person@brockport.edu'), (245, 'Campbell', 'Teresa', 'person@brockport.edu'), (246, 'Scrivani', 'Emily', 'person@brockport.edu'); -- done -- TEAM 1 INSERT INTO `PERSON` VALUES (901, 'Adenegan', 'Racheal', ' '), (902, 'Akinjiola', 'Oluyinka', ' '), (903, 'Alejo', 'Yokastheline', ' '), (904, 'Alesi', 'Thomas', ' '), (905, 'Allen', 'Caitlin', ' '), (906, 'Allentoff', 'Jonathan', ' '), (907, 'Ameele', 'Sarah', ' '), (909, 'Argetsinger', 'Gail', ' '), (910, 'Ayala', 'Andy', ' '), (911, 'Bacheler', 'Virginia', ' '), (912, 'Badger', 'Megan', ' '), (913, 'Bailey', 'Kathleen', ' '), (914, 'Balog', 'Linda', ' '), (915, 'Baltzell', 'Falon', ' '), (916, 'Banerjee', 'Priya', ' '), (917, 'Barnes', 'Chelsea', ' '), (918, 'Bateman', 'John', ' '), (919, 'Bauer', 'Christopher', ' '), (920, 'Bauer', 'Riley', ' '), (921, 'Beauchamp', 'Gregory', ' '), (922, 'Bell', 'David', ' '), (923, 'Benincasa', 'Christine', ' '), (924, 'Bennett', 'Steven', ' '), (925, 'Bernacki', 'Rebecca', ' '), (926, 'Bernsten', 'Nicole', ' '), (927, 'Berschwinger', 'Teresa', ' '), (928, 'Beyer', 'Jacob', ' '), (929, 'Bialey', 'Bradley', ' '), (930, 'Bills', 'Cienna', ' '), (931, 'Bishop', 'Bianca', ' '), (932, 'Black', 'Ralph', ' '), (933, 'Blackwell', 'Sarah', ' '), (934, 'Blackwood', 'Joshua', ' '), (935, 'Blair', 'Isabelle', ' '), (936, 'Bliss', 'Emily', ' '), (937, 'Blood', 'Thomas', ' '), (939, 'Bloom', 'Rebecca', ' '), (940, 'Boerner', 'Julie', ' '), (941, 'Bojko', 'Cameron', ' '), (942, 'Bourque', 'Courtney', ' '), (943, 'Boyer', 'Sarah', ' '), (944, 'Brabo', 'Ellen', ' '), (945, 'Brandow', 'Kelsey', ' '), (946, 'Bremer', 'Kristin', ' '), (947, 'Brooks', 'Adam', ' '), (948, 'Brown', 'Michael', ' '), (949, 'Browning', 'Melissa', ' '), (950, 'Broyld', 'Fabrice', ' '), (951, 'Brunswick', 'Kammie', ' '), (952, 'Brusseau', 'Timothy', ' '), (953, 'Bryan', 'Steven', ' '), (954, 'Bryant', 'Madeleine', ' '), (955, 'Buchheit', 'Stacie', ' '), (956, 'Buehler', 'Elizabeth', ' '), (957, 'Bunce', 'Caitlin', ' '), (958, 'Burgos-Melendez', 'Marielys', ' '), (959, 'Cade', 'Elise', ' '), (960, 'Cadwell', 'Kaitlyn', ' '), (961, 'Campbell', 'Alexandra', ' '), (962, 'Camps', 'Roberto', ' '), (963, 'Canbolat', 'Mustafa', ' '), (964, 'Carlin', 'Stephanie', ' '), (965, 'Carlos Acosta', 'Juan', ' '), (966, 'Carpenter', 'Cara', ' '), (967, 'Carroll', 'Robert', ' '), (968, 'Carter', 'Hilal', ' '), (969, 'Casilio', 'Karen', ' '), (970, 'Castner', 'Kristie', ' '), (971, 'Catchmen', 'Allison', ' '), (972, 'Chefalo', 'Carly', ' '), (973, 'Cheney', 'Aubrey', ' '), (974, 'Chilyn Rafael', 'Melnard', ' '), (976, 'Ciccone', 'Thomas', ' '), (977, 'Clark', 'Laura', ' '), (978, 'Clark', 'Mary', ' '), (979, 'Clark', 'Stephen', ' '), (980, 'Colling', 'Michael', ' '), (981, 'Collins', 'Bridget', ' '), (982, 'Comden', 'Kelly', ' '), (983, 'Contestable', 'Laura', ' '), (984, 'Conti', 'Brooke', ' '), (986, 'Modi', 'Jayna', ' '), (987, 'Cooper', 'Jayna', ' '), (988, 'Copeland', 'Emily', ' '), (989, 'Copelton', 'Denise', ' '), (990, 'Corvera', 'Anna', ' '), (991, 'Corwin', 'James', ' '), (992, 'Cost', 'Patrick', ' '), (993, 'Cox', 'Brett', ' '), (994, 'Crawford', 'Brian', ' '), (995, 'Cronlund', 'Joshua', ' '), (996, 'Cross', 'Kevin', ' '), (997, 'Cruppi', 'Tara', ' '), (998, 'Cutcliffe', 'Jessica', ' '), (1001, 'Fernandez', 'Bruce', ' '), (1003, 'Ferreira', 'Kaleena', ' '), (1004, 'Field', 'Lauren', ' '), (1005, 'Evenden', 'Haley', ' '), (1006, 'Feller', 'Rebekah', ' '), (1007, 'Denner', 'Damiene', ' '), (1008, 'Dickinson', 'Tracey', ' '), (1009, 'English', 'Erin', ' '), (1010, 'Flores', 'Jeiri', ' '), (1011, 'Day', 'Kimberly', ' '), (1012, 'Eisenstein', 'Michael', ' '), (1013, 'Dohr', 'Douglas', ' '), (1014, 'Dudley', 'Kara', ' '), (1015, 'Des Jardin', 'Kathryn', ' '), (1016, 'Doberstein', 'Sara', ' '), (1017, 'DeGuzman', 'Melchor', ' '), (1018, 'Fallon', 'Moira', ' '), (1019, 'David', 'Tamala', ' '), (1020, 'Dicker', 'Georges', ' '), (1021, 'Doerner', 'Paige', ' '), (1022, 'Donovan', 'Casey', ' '), (1023, 'Fairbrother', 'Daniel', ' '), (1024, 'Duffy', 'Brian', ' '), (1025, 'Fuller', 'Kyle', ' '), (1026, 'Doyle', 'James', ' '), (1027, 'Fischer', 'Katie', ' '), (1028, 'Driscoll', 'Casey', ' '), (1029, 'Feeney', 'Katherine', ' '), (1030, 'Funston', 'Nicole', ' '), (1031, 'Davis', 'Tyshon', ' '), (1032, 'Foote', 'Stephanie', ' '), (1033, 'DErasmo', 'Stefanie', ' '), (1034, 'Drake', 'Katherine', ' '), (1035, 'Fenton', 'Brianne', ' '), (1036, 'Ferro', 'Corina', ' '), (1037, 'Fowler', 'Aubrey', ' '), (1038, 'Frankiewich', 'Theresa', ' '), (1039, 'Freeman', 'Shannon', ' '), (1040, 'Dishaw', 'Lisa', ' '), (1041, 'Deci', 'Michael', ' '), (1042, 'Devlin', 'Brendan', ' '), (1043, 'DArcangelis', 'Nicole', ' '), (1044, 'Debbins', 'Christopher', ' '), (1045, 'Eick', 'James', ' '), (1046, 'Esara', 'Pilapa', ' '), (1047, 'Ducey', 'Marsha', ' '), (1048, 'Frainier', 'Alyssa', ' '), (1049, 'Fadner', 'Scott', ' '), (1050, 'Dyer', 'Tashauna', ' '), (1051, 'Decker', 'Amanda', ' '), (1052, 'Darrow', 'Felicia', ' '), (1053, 'Frazier-Smith', 'Matthew', ' '), (1054, 'Dattellas', 'Stephanie', ' '), (1055, 'Dixson', 'Adam', ' '), (1056, 'Fagiolo', 'Jessica', ' '), (1057, 'Douglas', 'David', ' '), (1059, 'Hartnett', 'Dale', ' '), (1063, 'Hing', 'Huey', ' '), (1064, 'Hasnat', 'Baban', ' '), (1065, 'Hubbard', 'Kitty', ' '), (1066, 'Herrmann Jr.', 'Ken', ' '), (1067, 'Hoffmann', 'Markus', ' '), (1068, 'Haytock', 'Jennifer', ' '), (1069, 'Hecker', 'Jennifer', ' '), (1070, 'Haynes', 'James', ' '), (1071, 'Hughes', 'Suzanne', ' '), (1073, 'Goethel', 'Nancy', ' '), (1077, 'Harper', 'Kristen', ' '), (1078, 'Hashimoto', 'Yuko', ' '), (1079, 'Haller', 'Lisa', ' '), (1080, 'Greer', 'David', ' '), (1081, 'Gandhi', 'Jennalee', ' '), (1082, 'Haliback', 'Stephanie', ' '), (1083, 'Giverson', 'Jessica', ' '), (1084, 'Glenn', 'Chyna', ' '), (1085, 'Goode', 'Michelle', ' '), (1086, 'Hess', 'Katelyn', ' '), (1087, 'Hopkins', 'Alyssa', ' '), (1088, 'Hatzigiannidis', 'Apostolos', ' '), (1089, 'Henahan', 'Brandon', ' '), (1090, 'Hall', 'Sharon', ' '), (1091, 'Gallant', 'Heather', ' '), (1092, 'Giuseppetti', 'Angela', ' '), (1093, 'George', 'Jessica', ' '), (1094, 'Graham', 'Adam', ' '), (1095, 'Helt', 'Jay-Christian', ' '), (1096, 'Goodspeed', 'Andrew', ' '), (1097, 'Greenman', 'Ashley', ' '), (1098, 'Griffiths', 'Gwyn', ' '), (1099, 'Helft', 'Jennifer', ' '), (1100, 'Herman', 'Susan', ' '), (1101, 'Green', 'Martin', ' '), (1102, 'Hepworth', 'Matthew', ' '), (1103, 'Hrubes', 'Tina', ' '), (1104, 'Glantz', 'Jaime', ' '), (1105, 'Hedges', 'Geoffrey', ' '), (1106, 'Gibbens', 'Rebecca', ' '), (1107, 'Green', 'Burnice', ' '), (1108, 'Gunther', 'Morgan', ' '), (1109, 'Gursslin', 'Todd', ' '), (1110, 'Guy', 'Katherine', ' '), (1111, 'Holmes', 'Maattchaas', ' '), (1112, 'Giambona', 'Jourdan', ' '), (1113, 'Gilhooly', 'Moria', ' '), (1114, 'Graham', 'Abigail', ' '), (1115, 'Gruver', 'Meagan', ' '), (1116, 'Hillenbrand', 'Ashley', ' '), (1117, 'Howell', 'Marissa', ' '), (1118, 'Hare', 'Natalie', ' '), (1119, 'Heydens', 'Alyssa', ' '), (1120, 'Huber', 'Katherine', ' '), (1121, 'Gardner', 'John', ' '), (1122, 'Grossman', 'Kevin', ' '), (1123, 'Hathaway', 'Stephanie', ' '), (1124, 'Haude', 'Katrina', ' '), (1125, 'Hedding', 'Christina', ' '), (1126, 'Geroux', 'Bobby', ' '), (1128, 'Geer', 'Brandon', ' '), (1129, 'Harrington', 'Kevin', ' '), (1130, 'Hellwig', 'Carrie', ' '), (1131, 'Glynn', 'Michelle', ' '), (1132, 'Hulme', 'Richard', ' '), (1133, 'Heminway', 'Aaron', ' '), (1134, 'Graham', 'Andrea', ' '); -- These are all session chairs INSERT INTO `PERSON` VALUES (801, 'Mills', 'Lori', 'person@brockport.edu'), (802, 'Cook', 'Laurie', 'person@brockport.edu'), (804, 'He', 'LeRong', 'person@brockport.edu'), (805, 'Patel', 'Dale', 'person@brockport.edu'), (808, 'Norment', 'Christopher', 'person@brockport.edu'), (809, 'Martin', 'Morag', 'person@brockport.edu'), (811, 'Bilinski', 'Kim', 'person@brockport.edu'), (812, 'Haibach', 'Pamela', 'person@brockport.edu'), (813, 'Hullfish', 'William', 'person@brockport.edu'), (814, 'Heavey', 'Elizabeth', 'person@brockport.edu'), (816, 'Orr', 'Susan', 'person@brockport.edu'), (817, 'Forzano', 'Lori-Ann', 'person@brockport.edu'), (818, 'Dauenhauer', 'Jason', 'person@brockport.edu'), (819, 'Bloom', 'Davida', 'person@brockport.edu'), (820, 'LeSavoy', 'Barbara', 'person@brockport.edu'), (821, 'Gokhale', 'Virginia', 'person@brockport.edu'), (822, 'Mitra', 'Sandeep', 'person@brockport.edu'), (823, 'Shah', 'Maura', 'person@brockport.edu'), (824, 'Norris', 'Mark', 'person@brockport.edu'), (825, 'Moyer', 'Paul', 'person@brockport.edu'), (826, 'Leiberman', 'Lauren', 'person@brockport.edu'), (827, 'Prajitura', 'Gabriel', 'person@brockport.edu'), (828, 'Wilkerson-Baker', 'Donna', 'person@brockport.edu'), (829, 'Jurek', 'Steven', 'person@brockport.edu'), (830, 'McNall', 'Laurel', 'person@brockport.edu'), (831, 'Karim', 'Rehnuma', 'person@brockport.edu'), (832, 'Mitrano', 'Barbara', 'person@brockport.edu'), (833, 'Orzel', 'Vitginia', 'person@brockport.edu'), (834, 'Prioleau', 'Darwin', 'person@brockport.edu'), (835, 'Mosher', 'Hilary', 'person@brockport.edu'), (836, 'Morris', 'Will', 'person@brockport.edu'), (837, 'Konkuman', 'Ferman', 'person@brockport.edu'), (838, 'Kozub', 'Mary', 'person@brockport.edu'), (839, 'Kasper', 'Barbara', 'person@brockport.edu'), (840, 'Pelletier', 'Michel', 'person@brockport.edu'), (841, 'Keefe', 'Maura', 'person@brockport.edu'), (842, 'Rossi', 'Frank', 'person@brockport.edu'), (843, 'Payne', 'Skye', 'person@brockport.edu'), (844, 'Iafrati', 'Nancy', 'person@brockport.edu'), (845, 'Lipko', 'Amanda', 'person@brockport.edu'), (846, 'Sadguru', 'Ralph', 'person@brockport.edu'); -- DONE -- -- REVIEWER (ReviewerId) DROP TABLE IF EXISTS `REVIEWER`; CREATE TABLE `REVIEWER`( ReviewerId INT, PRIMARY KEY (ReviewerId), FOREIGN KEY (ReviewerId) REFERENCES PERSON.PersonId ); INSERT INTO `REVIEWER` VALUES (1); -- DONE -- SESSION_CHAIR (SessionChairId) DROP TABLE IF EXISTS `SESSION_CHAIR`; CREATE TABLE `SESSION_CHAIR`( SessionChairId INT, PRIMARY KEY (SessionChairId), FOREIGN KEY (SessionChairId) REFERENCES PERSON.PersonId ); INSERT INTO `SESSION_CHAIR` VALUES (1),(2),(6), (19),(20),(41),(44),(49),(63), (69),(75),(81),(93),(103),(104),(106),(107),(115),(124),(126),(127),(151),(154), (164),(173),(174); INSERT INTO `SESSION_CHAIR` VALUES (801), (802), (804), (805),(808),(809),(811), (812), (813), (814), (816), (817), (818), (819), (820), (821), (822), (823), (824), (825), (826), (827), (828), (829), (830), (831), (832), (833), (834), (835), (836), (837), (838), (839), (840), (841), (842), (843), (844), (845), (846) ; INSERT INTO `SESSION_CHAIR` VALUES (938), (911), (948), (984), (914), (963), (916), (932), (909), (999), (1000), (1017), (1018), (1019), (1020), (1046), (1047), (1058), (1059), (1060), (1061), (1063), (1064), (1065), (1066), (1067), (1068), (1069), (1070); -- DONE (4-13-12) -- AUTHOR (AuthorId) DROP TABLE IF EXISTS `AUTHOR`; CREATE TABLE `AUTHOR`( AuthorId INT, PRIMARY KEY (AuthorId), FOREIGN KEY (AuthorId) REFERENCES PERSON.PersonId ); INSERT INTO `AUTHOR` VALUES (3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15), (16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30), (31),(32),(33),(34),(35),(36),(37),(38),(39),(40),(41),(42),(43),(44),(45), (46),(47),(48),(49),(50),(51),(52),(53),(54),(55),(56),(57),(58),(59),(60), (61),(62),(63),(64),(65),(66),(67),(68),(69),(70),(71),(72),(73),(74),(75), (76),(77),(78),(81),(82),(83),(84),(85),(86),(87),(88),(89),(90), (91),(92),(93),(94),(95),(96),(97),(98),(99),(100),(101),(102),(103),(104),(105), (106),(107),(108),(109),(110),(111),(112),(113),(114),(115),(116),(118),(120), (121),(122),(123),(124),(125),(126),(127),(128),(129),(130),(131),(132),(133),(134),(135), (136),(137),(138),(139),(140),(141),(142),(143),(144),(145),(146),(147),(148),(149),(150), (151),(152),(153),(154),(158),(159),(160),(161),(162),(163),(164),(165), (167),(168),(169),(170),(171),(172),(173),(174),(175),(176),(177),(178),(179),(180), (181),(182),(183),(184),(185),(186),(187),(188),(189),(190),(191),(192),(193),(194),(195), (196),(197),(198),(199),(200),(201),(202),(203),(204),(205),(206),(207),(208),(209),(210), (211),(212),(213),(214),(215),(216),(217),(218),(219),(220),(221),(222),(223),(224),(225), (226),(227),(228),(229),(230),(231),(232),(233),(234),(235),(236),(237),(238),(239),(240), (241),(242),(243),(244),(245),(246); INSERT INTO `AUTHOR` VALUES (903), (904), (905), (907), (908), (910), (911), (912), (914), (916), (917), (920), (921), (923), (926), (929), (930), (931), (932), (937), (398), (941), (942), (944), (945), (947), (948), (949), (951), (952), (954), (955), (956), (960), (961), (962), (963), (966), (968), (970), (971), (972), (973), (974), (976), (977), (978), (980), (983), (984), (985), (986), (987), (988), (989), (992), (993), (994), (998), (1001), (1002), (1003) , (1004), (1005), (1006), (1007), (1008), (1009), (1010), (1011), (1012), (1013), (1014), (1015), (1016), (1021), (1022), (1023), (1024), (1025), (1026), (1027), (1028), (1029), (1030), (1031), (1032), (1033), (1034), (1035), (1036), (1037), (1038), (1039), (1040), (1041), (1042), (1043), (1044), (1045), (1048), (1049), (1050), (1051), (1052), (1053), (1054), (1055), (1056), (1057), (1067), (1071), (1072), (1073), (1074), (1075), (1076), (1077), (1078), (1079), (1080), (1061), (1081), (1082), (1083), (1084), (1059), (1091), (1092), (1093), (1094), (1095), (1096), (1097), (1098), (1099), (1100), (1101), (1102), (1103), (1104), (1105), (1106), (1107), (1109), (1110), (1111), (1112), (1113), (1114), (1115), (1116), (1117), (1119), (1120), (1121), (1122), (1123), (1124), (1125), (1126), (1127), (1129), (1130), (1131), (1132), (1133), (1134); -- CONTACT_AUTHOR (ContactAuthorId) DROP TABLE IF EXISTS `CONTACT_AUTHOR`; CREATE TABLE `CONTACT_AUTHOR`( ContactAuthorId INT, PRIMARY KEY (ContactAuthorId), FOREIGN KEY (ContactAuthorId) REFERENCES AUTHOR.AuthorId ); INSERT INTO `CONTACT_AUTHOR` VALUES (3), (4), (5), (7),(6),(1096),(967),(180),(181),(17), (805),(990),(958),(21), (995),(918),(242),(812),(22),(927); INSERT INTO `CONTACT_AUTHOR` VALUES (1004), (1006), (1011), (1013), (1002), (1014), (1021), (1022), (1023), (1018), (1025), (1026), (1028), (1033), (1040), (1029), (1045), (1030), (1048), (1052), (1020), (1012), (1057), (975), (913), (902), (982), (901), (991), (969), (957), (979), (934), (965), (919), (915), (946), (925), (940), (943), (953), (939), (959), (996), (981), (950), (962), (906), (928), (922), (909), (997), (935), (933), (964), (936), (924), (1080), (1081), (1082), (1087), (1089), (1090), (1091), (1092), (1094), (1097),(1098), (1100), (1104), (1111), (1116), (1117), (1118),(1119), (1121), (1122), (1125), (1126), (1133), (1134), (1061), (1067); -- DONE -- SESSION_ROOM_CHAIR (SessionId, TimeSlotId, RoomId, BuildingId, SessionChairId) DROP TABLE IF EXISTS `SESSION_ROOM_CHAIR`; CREATE TABLE `SESSION_ROOM_CHAIR`( SessionId INT, TimeSlotId INT, RoomId VARCHAR(32), BuildingId INT, SessionChairId INT, PRIMARY KEY (SessionId), FOREIGN KEY (TimeSlotId) REFERENCES TIME_SLOT.TimeSlotId, FOREIGN KEY (RoomId) REFERENCES ROOM.RoomId, FOREIGN KEY (BuildingId) REFERENCES BUILDING.BuildingId, FOREIGN KEY (SessionChairId) REFERENCES SESSION_CHAIR.SessionChairId ); INSERT INTO `SESSION_ROOM_CHAIR` VALUES (1, 1, '102', 1, 2), (2, 1, '105', 1, 6); INSERT INTO `SESSION_ROOM_CHAIR` VALUES (101, 1, '102', 1, 2), (102, 1, 'Outside NE Corner', 4, ' '), (103, 1, '105', 1, 6), (104, 1, '217', 2, ' '), (105, 1, '120', 2, 804), (106, 1, 'Dance Theater', 2, 20), (107, 1, '122', 2, 808), (108, 1, '219', 2, 809), (109, 1, '31', 2, 812), (110, 1, '103', 1, 811), (111, 1, '123', 2, 41), (112, 1, '120', 4, 813), (113, 1, '214', 2, 814), (114, 1, '215', 2, 44), (115, 1, '30', 2, 816), (116, 1, '104', 1, 817), (117, 1, '218', 2, 818), (118, 1, '106', 1, 819), (119, 1, '127', 2, 820), (201, 2, '14', 2, 49), (202, 2, '217', 2, 1063), (203, 2, '120', 2, 1064), (204, 2, '29', 2, 948), (205, 2, '106', 1, 911), (206, 2, '125', 2, ' '), (207, 2, '102', 1, 1017), (208, 2, 'Strasser Dance Studio', 2, ' '), (209, 2, 'Dance Theater', 2, 58), (210, 2, '107', 1, 1065), (211, 2, '215', 2, 63), (212, 2, '216', 2, 1018), (213, 2, '218', 2, 984), (214, 2, '122', 2, ' '), (215, 2, '30', 2, 914), (216, 2, '219', 2, ' '), (217, 2, '221', 2, ' '), (218, 2, '31', 2, ' '), (219, 2, '33', 2, ' '), (220, 2, '123', 2, ' '), (221, 2, '120', 4, 813), (222, 2, '214', 2, 1019), (223, 2, '27', 2, 1020), (224, 2, '103', 1, 924), (225, 2, '104', 1, ' '), (226, 2, '11', 2, ' '), (227, 2, '28', 2, 1066), (228, 2, '105', 1, 75), (229, 2, '127', 2, ' '); INSERT INTO `SESSION_ROOM_CHAIR` VALUES (301, 3, 'Main Lounge', 3, 1), (302, 3, '217', 2, 1 ), (303, 3, '120', 2, 1), (304, 3, '101', 1, 1), (305, 3, 'Strasser Studio', 2, 1), (306, 3, '216', 2, 1), (307, 3, '218', 2, 1), (308, 3, '122', 2, 1), (309, 3, '219', 2, 1), (310, 3, '215', 2, 1), (311, 3, '031', 2, 1), (312, 3, '123', 2, 1), (313, 3, '120', 4, 1), (314, 3, '027', 2, 1), (315, 3, '104', 1, 1), (316, 3, '102', 1, 1), (317, 3, '127', 2, 1); INSERT INTO `SESSION_ROOM_CHAIR` VALUES (401, 4, '106', 1, 1), (402, 4, '215', 2, 1), (403, 4, '217', 2, 1), (404, 4, '219', 2, 1), (405, 4, 'Strasser Studio', 2, 1); INSERT INTO `SESSION_ROOM_CHAIR` VALUES (419, 4, '031', 2, 1), (407, 4, '216', 2, 1), (408, 4, '218', 2, 1), (409, 4, '122', 2, 1), (410, 4, '014', 2, 1), (411, 4, '102', 1, 1), (412, 4, '123', 2, 1), (413, 4, '102', 4, 1), (414, 4, '214', 2, 1), (415, 4, '027', 2, 1), (416, 4, '104', 1, 1), (417, 4, '1107 Black Box', 4, 1), (418, 4, '127', 2, 1); INSERT INTO `SESSION_ROOM_CHAIR` VALUES (501, 5, '217', 2, 1), (502, 5, '106', 1, 1), (503, 5, 'Strasser Studio', 2, 1), (504, 5, 'Strasser Studio', 2, 1); INSERT INTO `SESSION_ROOM_CHAIR` VALUES (505, 5, '216', 2, 1), (506, 5, '221', 2, 1), (507, 5, '218', 2, 1), (508, 5, '218', 2, 1), (509, 5, '218', 2, 1), (510, 5, '122', 2, 1), (511, 5, '102', 1, 1), (512, 5, '219', 2, 1), (513, 5, '102', 1, 1), (514, 5, '1107', 4, 1); -- Just type the first 10-12 words in the title -- PAPER (PaperId, Title, ContactAuthorId, SubjectId, -- SessionId, StartTime, EndTime) DROP TABLE IF EXISTS `PAPER`; CREATE TABLE `PAPER`( PaperId INT, Title VARCHAR(512), ContactAuthorId INT, SubjectId INT, SessionId INT, StartTime VARCHAR(10), EndTime VARCHAR(10), PRIMARY KEY (PaperId), FOREIGN KEY (ContactAuthorId) REFERENCES CONTACT_AUTHOR.ContactAuthorId, FOREIGN KEY (SubjectId) REFERENCES SUBJECT_CATEGORY.SubjectId, FOREIGN KEY (SessionId) REFERENCES SESSION_ROOM_CHAIR.SessionId ); -- INSERT INTO `PAPER` VALUES -- (1, 'Indigenous People on the Road to Rio + 20', 3, 1, 1, '09:00 AM', '09:20 AM'), -- (2, 'Here come the Americans: Visual Culture Change During the Meiji Era in Japan', -- 4, 1, 1, '09:20 AM', '09:40 AM'), -- (3, 'Indian Residential School Syndrome and the International Impact: ....', -- 5, 1, 1, '09:40 AM', '10:00 AM'), -- (4, 'Puppeteers are Here', 7, 1, 2, '09:00 AM', '10:30 AM'); -- TEAM 8: Cuong Luu, William Vongsekyo, Carson Hapeman -- Session 3 Papers INSERT INTO `PAPER` VALUES (6, 'Archaelogical Field School in Petra, Jordan', 1033, 1, 3, '01:15 PM', '02:15 PM'), (7, 'Arts in Education Research Poster Session', 81, 1, 3, '01:15 PM', '02:15 PM'), (8, 'BIO 201 Class Project  Mapping e(r), Transgenes on the X Chromosome of the Fruit Fly', 959, 4, 3, '01:15 PM', '01:45 PM'), (9, 'Analysis of the Regulatory Region of the e(r) Gene in Drosophila melanogaster', 1040, 4, 3, '01:45 PM', '02:15 PM'), (10, 'Use of Simulation Modeling in Sport Facility Resource Utilization', 996, 5, 3, '01:15 PM', '01:40 PM'); INSERT INTO `PAPER` VALUES (11, 'Impact of EURO 2012 on People\'s Attitudes Towards Traveling to the Ukraine', 97, 5, 3, '01:40 PM', '02:00 PM'), (12, 'The Influence of Consumer Buying Behavior on Product Returns', 98, 5, 3, '02:00 PM', '02:15 PM'), (13, 'Inquiring What Nature Does: Experiments in the Physical Chemistry Laboratory', 1067, 6, 3, '01:15 PM', '02:15 PM'), (14, 'Racing Through My Mind: An ALS Journey', 1098, 7, 3, '01:15 PM', '02:15 PM'), (15, 'PHP to ColdFusion: A study in Practical Language Conversion', 252, 8, 3, '01:15 PM', '02:15 PM'), (16, 'Capturing Culture through Dance: Incorporating African Aesthetics into Modern Dance', 1111, 10, 3, '01:15 PM', '01:45 PM'), (17, 'The Democratization of Dance Criticism', 253, 10, 3, '01:45 PM', '02:15 PM'), (18, 'Pressure Systems and Their Influence on Lake Effect Snow', 254, 12, 3, '01:15 PM', '02:15 PM'), (19, 'Ice Cover Over Lake Erie and Its Relationship to Lake Effect Snowfall', 208, 12, 3, '01:15 PM', '02:15 PM'), (20, 'The End of the World in 2012  How Scared Should We Be?', 104, 12, 3, '01:15 PM', '02:15 PM'); INSERT INTO `PAPER` VALUES (21, 'Hands-on or Hands-Off: Is Hands-On Learning Worth the Effort?', 256, 14, 3, '01:15 PM', '02:15 PM'), (22, 'Literature of the 1920\'s and Women\'s Sexuality', 108, 15, 3, '01:15 PM', '01:30 PM'), (23, 'Gatsby: Achieving Status through Conspicuous Consumption', 109, 15, 3, '01:30 PM', '01:45 PM'), (24, 'Luxury Breeds Complications', 1030, 15, 3, '01:45 PM', '02:00 PM'), (25, 'The Indefinite Marriage', 258, 15, 3, '02:00 PM', '02:15 PM'), (26, 'Ecuador: The Struggle Being a Megadiverse Country in a World of Scarce Natural Resources', 259, 16, 3, '01:15 PM', '01:25 PM'), (27, 'Biodiversity in Ecuador\'s Cloud Forests and the Life History of the Yellow-Chinned Spinetail', 260, 16, 3, '01:25 PM', '01:45 PM'), (28, 'Reducing, Reusing, Recycling: a Comparative Analysis of Waste Management in Ecuador and America', 110, 16, 3, '01:45 PM', '01:55 PM'), (29, 'Waste Management in Ecuador vs. the United States', 1116, 16, 3, '01:55 PM', '02:05 PM'), (30, 'Medicinal Plants', 1117, 16, 3, '02:05 PM', '02:15 PM'), (31, 'Lymphatic Filariasis in Southeast Asia and Sub-saharan Africa', 112, 17, 3, '01:15 PM', '02:15 PM'), (32, 'Perceptions and Practices for Improving Health Using Animal-Assisted Therapies', 1029, 17, 3, '01:15 PM', '02:15 PM'), (33, 'The Roles and Treatment of Women During World War I as a Result of Their Gender', 1118, 19, 3, '01:15 PM', '01:35 PM'), (34, 'The Royal Brand  A Digital Historian Approach', 950, 19, 3, '01:15 PM', '01:45 PM'), (35, 'The U-boat Campaigns of the First World War', 261, 19, 3, '01:35 PM', '01:55 PM'), (36, 'The U.S. Automotive Industry\'s Response to the 1970s American Consumer Market', 1045, 19, 3, '01:45 PM', '02:15 PM'), (37, 'Stormtrooper Tactics: The Origins of Blitzkrieg', 261, 19, 3, '01:55 PM', '02:15 PM'); INSERT INTO `PAPER` VALUES (38, 'Aquatics and Autism: Teaching Aquatic Skills to Children With Autism', 837, 21, 3, '01:15 PM', '02:15 PM'), (39, 'Visual Inequalities', 116, 23, 3, '1:15 PM', '02:15 PM'), (40, 'The Dynamics of the Tepee Map', 262, 23, 3, '1:15 PM', '02:15 PM'), (41, 'Orbital Behavior of Bishop\'s Operator', 263, 23, 3, '1:15 PM', '02:15 PM'), (42, 'Political Image-Making in the Pre-Modern Nation State', 118, 24, 3, '01:15 PM', '02:15 PM'), (43, 'Correlation Between Spanish Oral Proficiency and English Grammar Knowledge',962, 24, 3, '01:35 PM', '02:15 PM'), (44, 'Music for Dance', 906, 25, 3, '01:35 PM', '02:15 PM'), (45, 'Community Health in Costa Rica', 1119, 26, 3, '01:15 PM', '02:15 PM'), (46, 'On the Necessity of Descartes\' Eternal Truths', 251, 28, 3, '01:15 PM', '02:15 PM'), (47, 'Modeling Heavy Quarkonia', 264, 29, 3, '01:15 PM', '02:15 PM'), (48, 'The Monochromator', 1121, 29, 3, '01:15 PM', '02:15 PM'), (49, 'Physical Concepts of Ground Penetrating Radar', 9999, 29, 3, '01:15 PM', '02:15 PM'), (50, 'Method for Building a Mutual Inductance Bridge', 9999, 29, 3, '01:15 PM', '02:15 PM'), (51, 'Intergallactic MgII Absorbers in the Sloan Digital Sky Survey', 928, 29, 3, '01:15 PM', '02:15 PM'), (52, 'Photometry and Extra-Solar Planet Detection', 1122, 29, 3, '01:15 PM', '02:15 PM'), (53, 'Probing the Intergalactic Medium (IGM) of Space', 922, 29, 3, '01:15 PM', '02:15 PM'), (54, 'Advanced Physics Lab. II', 125, 29, 3, '01:15 PM', '02:15 PM'), (55, 'Experimental Investigation of Silicon Powders using X-Ray Diffraction', 265, 29, 3, '01:15 PM', '02:15 PM'), (56, 'The Impact of Ostracism on Stigma Consciousness and Rejection Sensitivity', 126, 31, 3, '01:15 PM', '02:15 PM'), (57, 'Performance Factors in Associative Learning: Assessment of the Sometimes Competing Retrieval Model', 128, 31, 3, '01:15 PM', '02:15 PM'), (58, 'The Perception of Pride in Marginalized Groups', 129, 31, 3, '01:30 PM', '02:15 PM'), (59, 'The Impact of Ostracism and Bullying on Feelings of Empowerment, Self-Stigma, and Perceived Stigma in Individuals with Visual Impairments', 130, 31, 3, '01:45 PM', '02:15 PM'); INSERT INTO `PAPER` VALUES (60, 'Under the Red Umbrella: An Inside Investigation of The Sex Industry', 267, 33, 3, '01:15 PM', '02:15 PM'), (61, 'Over at the Frankenstein Place  The Dramaturgy of Rocky Horror Show', 215, 34, 3, '01:15 PM', '02:15 PM'), (62, 'Adventures in Costume History', 909, 34, 3, '01:15 PM', '02:15 PM'), (63, 'Women Across Cultures: An Honors Sex Culture (WMS 360) and Levin Global Workforce Project Poster Session', 820, 35, 3, '01:15 PM', '02:15 PM'), (64,'Motivations and Restrictions of Rural Chinese Women Migrating to the City',99,1,4,'02:30 PM', '02:45 PM'), (65,'Being Female: What a Difference it Makes',140,1,4, '02:45 PM', '03:00 PM'), (66,'Iranian Revolution Restuctures Gender Roles',1030,1,4,'03:00 PM', '03:15 PM'), (67,'Rescuing Girlhood from Sexual Exploitation: A New Approach for Preventative Policies and Educational Programs in Nepal',1097,1,4,'03:15 PM','03:30 PM'), (68,'Living Sculpture',141,2,4,'02:30 PM','03:30 PM'), (69,'Characterization of in vitro Enzymatic Activity of TbLpn and Its Role in Phospholipid Biosynthesis in Trypanosoma brucei',269,4,4,'02:30 PM','2:45 PM'), (70,'A Novel Trypanosome Cytoplasmic Protein Interacts With the Enzyme TbPRMT1',1048,4,4,'02:45 PM','03:00 PM'), (71,'Cloning of the KitA Gene From Zebrafish',965,4,4,'03:00 PM','03:15 PM'), (72,'Expression and Characterization of a Mutant of the Lipin Homolog TbLpn in Trypanosoma brucei',270,4,4,'03:15 PM','03:30 PM'), (73,'Business Web Site Presentation',933,7,4,'02:30 PM','02:45 PM'), (74,'Slideshow Exhibition',1052, 7,4,'02:45 PM','03:00 PM'), (75,'Video Presentation',271,7,4,'03:00 PM','03:30 PM'), (76,'Almost Involuntary',272,10,4,'02:30 PM','02:45 PM'), (77,'Individual Beyond Culture',144,10,4,'02:45 PM','03:00 PM'), (78,'Re-choreographing Power',145,10,4,'03:00 PM','03:15 PM'), (79,'Dance Discoveries: One Choreographer\'s Journey',273,10,4,'03:15 PM','03:30 PM'), (80,'Paleoecology of an Ichthyosaur Specimen',146,12,4,'02:30 PM','02:45 PM'), (81,'Use of Geographic Information Systems (GIS) for Weather Hazard Management',274,12,4,'02:45 PM','03:00 PM'), (82,'Geographic Information Systems (GIS) in the \'Cloud\'',104,12,4,'03:00 PM','03:30 PM'), (83,'If You Give a Kid a Cookie...',149,12,4,'02:30 PM','02:45 PM'), (84,'Thinking and Learning: Teaching English Language Learners',206,12,4,'02:45 PM','03:30 PM'), (85,'The Failure of Conspicuous Consumption in The Great Gatsby',276,15,4,'02:30 PM','02:45 PM'), (86,'Automobiles as Crime Catalysts in Faulkner\'s Sanctuary',1125,15,4,'02:45 PM','03:00 PM'), (87,'An Illusion of Society: The Reflection of the Criminal',277,15,4,'03:00 PM','03:30 PM'), (88,'Assessing Lake Ontario Coastal Wetlands: A Comparison of Two Methods Using Fish Community Assemblages',150,16,4,'02:30 PM','02:45'), (89,'Ecological and Societal Effects of Dwindling Salmonid Populations Due to Overfishing, Overexploitation and Human Water Use Practices',278,16,4,'02:45 PM','03:00 PM'), (90,'Lipid Content and Fatty Acid Signatures in Lake Trout Eggs From the Great Lakes, Cayuga Lake, and Lake Champlain',1126,16,4,'03:00 PM','03:15 PM'), (91,'Spatiotemporal Variation in Fatty Acid Signatures of Lake Michigan Spottail Shiner (Notropis hudsonius)',279,16,4,'03:15 PM','03:30 PM'), (92,'The Phenomenological Exploration of the Lived-Experience of Giving Birth at Home',280,17,4,'02:30 PM','03:30 PM'), (93,'Get Your Head Examined: Phrenology a 19th Century Pseudo-science?',152,19,4,'02:30 PM','02:45 PM'), (94,'Black Dolls and American Children: Learning What Dark Skin Meant in Antebellum America',153,19,4,'02:45 PM','03:00 PM'), (95,'19th Century American Necrography: Picturesque Influence, Neo-Classical Revival and Necrotourism in Relation to Early American Funerary Landscaping',1021,19,4,'03:00 PM','03:15 PM'), (96,'Early American Writing Implements: Their History and Cultural Significance',281,19,4,'03:15 PM','03:30 PM'), (97,'The French Female Gaze',282,25,4,'02:30 PM','03:30 PM'), (98,'Brockport Xylophone Ensemble',154,25,4,'02:30 PM','03:00 PM'), (99,'Playing the Piano: Some Techniques from Class Piano II',154,25,4,'03:00 PM','03:30 PM'), (100,'Legislative Issues Affecting Nursing in 2012',844,26,4,'02:30 PM','03:30 PM'), (101,'The Coherence of Cartesian Freedom',1020,28,4,'02:30 PM','03:30 PM'), (102,'Is Overconfidence Adaptive in Young Children?',964,31,4,'02:30 PM','02:45 PM'), (103,'Can You Predict Your Grade? How Students Anxiety Relates to Prediction on ExamPerformance',162,31,4,'02:45 PM','03:30 PM'), (104,'Turtle Play (The Play About the Turtle)',16,34,4,'02:30 PM','03:30 PM'), (105,'WMS 360 Women Across Cultures: Sex and Gender Representations Across Person and Place',283,35,4,'02:30 PM','03:30'), -- Paper (PaperID, Title, ContactAuthorID, SubjectId, -- SSessionId, StartTime, EndTime), (106, 'Nuclear Encoded Protiens Important in Mitochondrial Genome Stability', 284, 4, 5, '3:45 PM', '4:00 PM'), (107, 'The Benefits of Preventative Medicin in Zoo\'s: A Retrospective Study...', 165, 4, 5, '4:00 PM', '4:15 PM'), (108, 'Woman\'s Body Image: The Role Of The Media' , 285, 7, 5, '3:45 PM', '4:00 PM'), (109, 'The Misleading Link Between Violence and Video Games', 167, 7, 5, '4:00 PM', '4:15 PM'), (110,'Pixel Perfect: An Analysis of Female Body Imange in the Media', 936, 7, 5, '4:15 PM', '4:30 PM'), (111,'Unsquare Dance: A Collaborative Performance', 9999, 10, 5, '3:45 PM', '4:00 PM'), (112,'Improvisation and Problem Solving as Composition and Performance', 286, 10, 5, '4:00 PM', '4:15 PM'), (113,'Inclusion: Behind The Scenes and Beyond the Models', 287, 14, 5, '3:45 PM', '4:00 PM'), (114,'The Lord of the Rings: A Readers\' Theatre Presentation', 170, 15, 5, '3:45 PM', '4:00 PM'), (115,'Creative Writing Studend and Faculty Open Mic', 288, 15, 5, '3:45PM', '4:00PM'), (116,'Effects of Macronutrients, Hydroperiod, and Riparian Buffers on Typha...', 1133, 16, 5, '3:45 PM', '4:00 PM'), (117,'Quantitative Survey of Freshwater Muscles in Honeyoye Creek', 289, 16, 5, '4:00 PM', '4:15 PM'), (118,'The Effects of Marcellus Shale Gas Drilling on Wetlands in...', 1134, 16, 5, '4:15 PM', '4:30 PM'), (119,'Thomas Payne: Author Of Independance', 290, 19, 5, '3:45 PM', '4:00 PM'), (120,'Fragments of Love and War', 924, 19, 5, '3:45 PM', '4:00 PM'), (121,'From Red Army to Auschwitz and Back: A Survivor\'s Story', 1012, 19, 5, '4:05 PM', '4:20 PM'), (122,'The Beginnings of Mormonism', 1057, 19, 5, '4:05 PM', '4:20PM'), (123,'Factory Girls: Their Work and Their Rights, 1810-1850', 291, 19, 5, '4:25 PM', '4:40 PM'), (124,'Three Short Student-Directed Plays', 292, 34, 5, '3:45 PM', '4:00 PM'); INSERT INTO `PAPER` (`PaperId`, `Title`, `ContactAuthorId`, `SubjectId`, `SessionId`, `StartTime`, `EndTime`) VALUES (2001, 'Indigenous Peoples on the Road to Rio +20', 3, '1', '1', '9:00 AM', '9:20 AM'), (2002, 'The Status of Woman in the Ancient World', 9999, '9999', '1', '10:45 AM', '11:00 AM'), (2003, 'Here Come the Americans: Visual Culture Change Durin gthe Meiji Era in Japan', 4, '1', '1', '9:20 AM', '9:40 AM'), (2004, 'Indian Residential School Syndrome and the Intergenerational Impact: Self Determination Theory in the Context of a Silent Genocide', 5, '1', '1', '9:40 AM', '10:00 AM'), (2005, 'Raku Firing Process', 801, '2', '1', '10:00 AM', '10:20 AM'), (2006, 'Puppeteers are Here!', 6, '3', '1', '9:00 AM', '9:20 AM'), (2007, 'How Cells Respond to an Appetite Hormone: The Molecular Aspects of Receptor Desensitization', 1096, '4', '1', '9:00 AM', '9:20 AM'), (2008, 'Characterization of Melanin-concentrating Hormone 1 Receptor Expression in SH-SY5Y Neuroblastoma Cells: A Potential Role for Receptor Clustering in the Regulation of MCH Signaling.', 179, '4', '1', '9:20 AM', '9:40 AM'), (2009, 'MCH Signaling is Attenuated by Beta-arrestin Overexpression But Enhanced by Caveolin-1 RNAi in BHK 570 cells.', 967, '4', '1', '9:40 AM', '10:00 AM'), (2010, 'Desensitization of MCH Signaling Most Likely Due to Sequestration of Signaling Components Rather Than Removal of Receptors From the Plasma Membrane', '9999', '4', '1', '10:00 AM', '10:20 AM'), (2011, 'Perceptions of Apple Inc. in the Context of Its Unique Marketing Techniques', 180, '5', '1', '9:00 AM', '9:20 AM'), (2012, 'Benefit Corporations: The New Generation of Corporations', 181, '5', '1', '9:20 AM', '9:40 AM'), (2013, 'HR Manual: A Generalist''s Guide to Hiring a Successful Employee', 17, '5', '1', '9:40 AM', '10:00 AM'), (2014, 'The Effectiveness of Social Media Marketing in Higher Education', 182, '5', '1', '10:00 AM', '10:20 AM'), (2015, 'Lessons From Memphis: Exploring & Learning', 805, '7', '1', '9:00 AM', '9:20 AM'), (2016, 'Flores, Palmas, y Zapateado: Flamenco for Modern Dancers', 990, '10', '1', '9:00 AM', '9:30 AM'), (2017, 'Dance Pedagogy: Integrating Cultural Diversity', 958, '10', '1', '9:30 AM', '10:00 AM'), (2018, 'More Than Just Samba', 902, '10', '1', '10:00 AM', '10:30 AM'), (2019, 'Content Integration in the Elementary Classroom Through the Use of Games', 21, '14', '1', '9:00 AM', '9:30 AM'), (2020, 'Lets Help Them Enjoy Brockport! Understanding the Needs of College Students With Autism', 1006, '14', '1', '9:30 AM', '10:00 AM'), (2021, 'Hoary Bat Habitat Preferences in New York State: Determining a Model for Management Purposes', 995, '16', '1', '9:00 AM', '9:15 AM'), (2022, 'Investigating the Henslow''s Sparrow Population Status and Habitat Preferences Within New York State.', 186, '16', '1', '9:15 AM', '9:30 AM'), (2023, 'Effects of Stormwater Retention Ponds on Calling Amphibian Populations', 918, '16', '1', '9:30 AM', '9:45 AM'), (2024, 'Grassland Bird Abundance and Habitat Quality in New York State', 1080, '16', '1', '9:45 AM', '10:00 AM'), (2025, 'Migratory Songbird Orientation and Energetics', 242, '16', '1', '10:00 AM', '10:15 AM'), (2026, 'Taverns and Coffeehouses: Respectability in Early America', 812, '19', '1', '9:00 AM', '9:25 AM'), (2027, 'Weimar Consumerism: Revitalization, Americanization, and the Deception of Modernity', 812, '19', '1', '9:25 AM', '9:50 AM'), (2028, 'Treatment Adherence to Physical Therapy', 22, '21', '1', '9:00 AM', '9:15 AM'), (2029, 'Are We Really Creating Healthy Heroes?', 187, '21', '1', '9:15 AM', '9:30 AM'), (2030, 'Classroom Activity Breaks and Physical Activity Levels of Children', 927, '21', '1', '9:30 AM', '10:00 AM'), (2031, 'A Kinesiological Analysis of Gait', 22, '21', '1', '10:00 AM', '10:15 AM'), (2032, 'The Leadership Development Program: Gold Certificate Social Action Projects', 73, '22', '1', '9:00 AM', '9:30 AM'), (2033, 'Informational Session on Mexico and Peru ', 982, '24', '1', '9:00 AM', '9:30 AM'), (2034, 'Jazz Saxophone Quartet', 813, '24', '1', '9:30 AM', '10:00 AM'), (2035, 'Evaluation of the Implementation of the 2010 ACOG Guidelines for Adolescent Pap Smear Management in a Women''s Health Practice', 43, '26', '1', '9:00 AM', '9:15 AM'), (2036, 'Improving Colorectal Screening Outcomes in People of African Descent', 901, '26', '1', '9:15 AM', '9:30 AM'), (2037, 'The Role of Curricula in Fostering Cultural Desire in Student Nurses', 1087, '26', '1', '9:30 AM', '10:00 AM'), (2038, 'Intimate Partner Violence and Nursing Education', 1011, '26', '1', '10:00 AM', '10:15 AM'), (2039, 'The Role of Higher Education in Producing Internationally Educated Students: Featured Study Abroad Programs at The College at Brockport', 44, '27', '1', '9:00 AM', '9:30 AM'), (2040, 'Study Abroad Personal Experiences', 243, '27', '1', '9:30 AM', '10:00 AM'), (2041, 'Narrowcasting Politics: Diminishing Democracy?', 1089, '30', '1', '9:00 AM', '9:30 AM'), (2042, 'The American Indentured Student', 991, '30', '1', '9:30 AM', '10:00 AM'), (2043, 'Eating Disorders and Their Affect on Interpersonal Difficulties', 214, '31', '1', '9:00 AM', '9:20 AM'), (2044, 'Executive Function in External, Emotional, and Restrained Eaters', 45, '31', '1', '9:20 AM', '9:40 AM'), (2045, 'Effects of Watching Television While Exercising', 969, '31', '1', '9:40 AM', '10:00 AM'), (2046, 'Resident Service Coordinator Program Evaluation: Meeting the Needs of Older, Disabled Adults in Subsidized Housing', 1090, '33', '1', '9:00 AM', '9:15 AM'), (2047, 'Information Technology and Student Engagement', 1091, '33', '1', '9:15 AM', '9:35 AM'), (2048, 'Nursing Home Culture Change', 957, '33', '1', '9:35 AM', '9:55 AM'), (2049, 'Habitat Goes to Houston', 32, '33', '1', '9:55 AM', '10:05 AM'), (2050, 'From Greek Old Comedy to New Comedy', 979, '34', '1', '9:00 AM', '9:08 AM'), (2051, 'The True King of New Comedy', 1013, '34', '1', '9:08 AM', '9:16 AM'), (2052, 'What Say You Other Roman Citizens - the Theatre? Psshh! I''d Rather Go to the Games!', 244, '34', '1', '9:16 AM', '9:24 AM'), (2053, 'Italian Renaissance Theatre: Revolutionizing the Stage', 46, '34', '1', '9:24 AM', '9:32 AM'), (2054, 'Christopher Marlow - The Man Who Died Many Deaths', 1014, '34', '1', '9:32 AM', '9:40 AM'), (2055, 'Sexuality and Gender Roles in Asian Theatre', 8, '34', '1', '9:40 AM', '9:48 AM'), (2056, 'David Garrick - Theatrical Innovator', 215, '34', '1', '9:48 AM', '9:56 AM'), (2057, 'From Actor to Assassin: The Tragedy of John Wilkes Booth', 934, '34', '1', '9:56 AM', '10:04 AM'), (2058, 'The Controversy of Racial Humor in Vaudeville Theatre', 8, '34', '1', '10:04 AM', '10:12 AM'), (2059, 'The Show Must Go On- The Impact of 9/11 on Broadway', 245, '34', '1', '10:12 AM', '10:20 AM'), (2060, 'In the Blood - An Investigation of Motherhood''s Struggle With Society', 1092, '34', '1', '10:20 AM', '10:28 AM'), (2061, 'The Economic Cooptation and Betrayal of Feminism', 965, '35', '1', '9:00 AM', '9:15 AM'), (2062, 'An Analysis of Western Feminism', 47, '35', '1', '9:15 AM', '9:30 AM'), (2063, 'It Was Just a Joke: Misogynistic Humor Perpetuating Rape Culture on College Campuses', 246, '35', '1', '9:30 AM', '9:45 AM'), (2064, 'The Status of Woman in the Ancient World', 50, '1', '2', '10:45 AM', '11:00 AM'), (2065, 'Kouros, Korai and Ka: A Comparative Study of the Human Body in Stone', 1021, '1', '2', '11:00 AM', '11:15 AM'), (2066, 'Death at a Funeral: Ancient Greek Funeral Customs in Athens', '9999', '1', '2', '11:15 AM', '11:30 AM'), (2067, 'Zooarchaeology: The Art of Examining Animal Bone', 1094, '1', '2', '11:30 AM', '11:45 AM'), (2068, 'Characterization of the wnt5 Expression Pattern During Olfactory Map Development in Drosophila', 51, '4', '2', '10:45 AM', '11:00 AM'), (2069, 'Visualization of Novel Guidepost Cells in Drosophila Olfactory Map Development', 1095, '4', '2', '11:00 AM', '11:15 AM'), (2070, 'CHO-K1 and BHK Cell Exposure to ''Environmentally Safe'' Simple Green and 2-Butoxyethanol Has an Alarming Effect In Cell Viability', 1022, '4', '2', '11:15 AM', '11:45 AM'), -- (2071, 'Understanding Oil Subsidy in Nigeria', , 52, '2', '10:45 AM', '11:00 AM'), (2072, 'Microfinancing Health Initiatives for Economic Development: A Comparative Study of Strategies', 1097, '5', '2', '11:00 AM', '11:20 AM'), (2073, 'Financial Literacy - Can You Read Your Money?', '9999', '5', '2', '11:20 AM', '11:45 AM'), (2074, 'Analysis of Drinking Water for Trihalomethanes by Membrane-Introduction GC-MS', 53, '6', '2', '10:45 AM', '11:00 AM'), (2075, 'Ion-Pairing Of The Ionic Liquid 1-Hexyl-3-methylimidazolium Bis(trifyl)amide In Chloroform', 54, '6', '2', '11:00 AM', '11:45 AM'), (2076, 'Authentic Voices: Videos for Migrant Workers and Community Service Providers', 1098, '7', '2', '10:45 AM', '11:00 AM'); INSERT INTO `PAPER` VALUES (2077, 'Fast Trax Bike Rental Program', 1023, '8', '2', '10:45 AM', '11:05 AM'), (2078, 'The Human Power Project', '9999', '8', '2', '11:05 AM', '11:25 AM'), (2079, 'Cloud-based Services: Just Hype or Providing Real Value? Evidence From a Micro-enterprise Context', '9999', '8', '2', '11:25 AM', '11:45 AM'), (2080, 'Perceptions of Police Officers Regarding Juvenile Delinquency in Rochester, NY', 55, '9', '2', '10:45 AM', '11:05 AM'), (2081, 'Parenting and Deviance: Unraveling the Connections of Parenting Styles and Deviance Among Youth in Western NY', 56, '9', '2', '11:05 AM', '11:25 AM'), (2082, 'Women''s Role in Terrorism', 57, '9', '2', '11:25 AM', '11:45 AM'), (2083, 'Cultural Exchange: Tap Dancing in Mexico',59 , '10', '2', '10:45 AM', '11:45 AM'), (2084, 'Dancers are Musicians are Dancers', 58, '10', '2', '10:45 AM', '11:45 AM'), (2085, 'Choreographing on the Low Level: An Unveiling', 915, '10', '2', '11:05 AM', '11:25 AM'), (2086, '(Re)Framing Fragmentation', 958, '10', '2', '11:25 AM', '11:45 AM'), (2087, 'Researching Native American Culture in the 21st Century', 61, '11', '2', '10:45 AM', '11:45'), (2088, 'Parameters Effects on Hail Size', 946, '12', '2', '10:45 AM', '11:00 AM'), (2089, 'Examination of the Relationships Between the Quasi-biennial Osillation, the Atlantic Multidecadal Oscillation, the Southern Oscillation, and the Accumulated Cyclone Energy in the Atlantic Basin', 1018, '12', '2', '11:00 AM', '11:15 AM'), (2090, 'Storm Chasing: Getting Ahead of the Storm', 64, '12', '2', '11:15 AM', '11:45 AM'), (2091, 'Implementing Tk20 Assessment System', 1018, '14', '2', '10:45 AM', '11:45 AM'), (2092, 'John Donne: The Sacramentality of Sex', 1025, '15', '2', '10:45 AM', 'NA'), (2093, 'World Building in Science Fiction and Fantasy', 1026, '15', '2', '11:00 AM', '11:45 AM'), (2094, 'Exploring the Potential for Emerald Ash Borer Induced Change in Western New York Forests', 925, '16', '2', '10:45 AM', '11:00 AM'), (2095, 'The Search for a Relict Prairie Community in Western New York', 66, '16', '2', '11:00 AM', '11: 15 AM'), (2096, 'Impact of White-tailed Deer Herbivory on Forest Composition at Letchworth State Park', 940, '16', '2', '11:15 AM', '11:45 AM'), (2097, 'Epidemiology of Onchocerciasis: A Neglected Tropical Disease', 916, '18', '2', '10:45 AM', '11:15 AM'), (2098, 'Feeding the Celiac Family: Medically-Restricted Diets & Gendered Feeding Work', 110, '18', '2', '11:15 AM', '11:45 AM'), (2099, 'Cotton Mather and the Salem Witchcraft Crisis', 68, '19', '2', '10:45 AM', '11:00 AM'), (2100, 'Confession and Contrition: Motivations and Impact on the Salem Witchcraft Trials', '9999', '19', '2', '11:00 AM', '11:15 AM'), (2101, 'The Devil''s Specter: Spectral Evidence and the Salem Witchcraft Crisis', 943, '19', '2', '11:15 AM', '11:45 AM'), (2102, 'Everything You Always Wanted to Know About Securing a Job - But Were Afraid to Ask', 69, '20', '2', '10:45 AM', '11:45 AM'), (2103, 'Professional Development and Leadership Opportunities Throughout the KSSPE Program', 247, '21', '2', '10:45 AM', '11:45 AM'), (2104, 'Graphs to the Extreme!', 248, '23', '2', '10:45 AM', '11:00 AM'), (2105, 'Can''t Touch This (A Study on Untouchable Numbers)', 248, '23', '2', '11:00 AM', '11:45 AM'), (2106, ' Voice and Collective Identity in La Voz Dormida', 249, '24', '2', '10:45 AM', '11:00 AM'), (2107, 'Fracophonie: Am Alternate Education for Globalization', 250, '24', '2', '11:00 AM', '11:45 AM'), (2108, 'Jazz Saxophone Quartet + Rhythm', 813, '25', '2', '10:45 AM', '11:45 AM'), (2109, 'Pura Vida Costa Rica', 1011, '26', '2', '10:45 AM', '11:45 AM'), (2110, 'Plato''s Changing View of Participation', 251, '28', '2', '10:45 AM', '11:45 AM'), (2111, 'SUNY Brockport EuroSim Club', 953, '30', '2', '10:45 AM', '11:45 AM'), (2112, 'University Environment, Sense of Belonging and Academic Success: Utilization of Campus Resources as a Moderating Factor', 73, '31', '2', '10:45 AM', '11:15 AM'), (2113, 'The Effect of Delay on Metacomprehension of Negated Text', 1028, '31', '2', '11:15 AM', '11:45 AM'), (2114, 'How Recreation Helps Marine Wives Cope With Deployments', 939, '32', '2', '10:45 AM', '11:45 AM'), (2115, 'Vietnam Struggling', 1100, '33', '2', '10:45 AM', '11:45 AM'), (2116, 'When Government Sponsored Theatre and the Beavers Revolted.', 75, '34', '2', '10:45 AM', '11:45 AM'), (2117, 'Representations of Women in Popular Music: Empowered or Exploited?', 1104, '35', '2', '10:45 AM', '11:05 AM'), (2118, 'College Sexual Assault Prevention and Education: From Theory to Practice', 78, '35', '2', '11:05 AM', '11:45 AM'); --PAPER_AUTHOR (PaperId, AuthorId) --(1, 3), (2, 4), (3, 5), (4, 7), (4, 8), (4, 9), (4, 10), (4, 11), (4, 12), (4, 13), --(4, 14), (4, 15), (4, 16); -- There is only one reviewer. So, the reviwer is the -- same for all papers -- PAPER_REVIEWER (PaperId, ReviewerId) DROP TABLE IF EXISTS `PAPER_REVIEWER`; CREATE TABLE `PAPER_REVIEWER`( PaperId INT, ReviewerId INT, PRIMARY KEY (PaperId), FOREIGN KEY (PaperId) REFERENCES PAPER.PaperId, FOREIGN KEY (ReviewerId) REFERENCES REVIEWER.ReviewerId ); INSERT INTO `PAPER_REVIEWER` VALUES (1, 1),(2, 1),(3, 1),(4, 1),(5, 1),(6, 1),(7, 1),(8, 1),(9, 1),(10, 1),(11, 1),(12, 1),(13, 1),(14, 1),(15, 1),(16, 1),(17, 1),(18, 1),(19, 1),(20, 1), (21, 1),(22, 1),(23, 1),(24, 1),(25, 1),(26, 1),(27, 1),(28, 1),(29, 1),(30, 1),(31, 1),(32, 1),(33, 1),(34, 1),(35, 1),(36, 1),(37, 1),(38, 1),(39, 1),(40, 1), (41, 1),(42, 1),(43, 1),(44, 1),(45, 1),(46, 1),(47, 1),(48, 1),(49, 1),(50, 1),(51, 1),(52, 1),(53, 1),(54, 1),(55, 1),(56, 1),(57, 1),(58, 1),(59, 1),(60, 1), (61, 1),(62, 1),(63, 1),(64, 1),(65, 1),(66, 1),(67, 1),(68, 1),(69, 1),(70, 1),(71, 1),(72, 1),(73, 1),(74, 1),(75, 1),(76, 1),(77, 1),(78, 1),(79, 1),(80, 1), (81, 1),(82, 1),(83, 1),(84, 1),(85, 1),(86, 1),(87, 1),(88, 1),(89, 1),(90, 1),(91, 1),(92, 1),(93, 1),(94, 1),(95, 1),(96, 1),(97, 1),(98, 1),(99, 1),(100, 1), (101, 1),(102, 1),(103, 1),(104, 1),(105, 1),(106, 1),(107, 1),(108, 1),(109, 1),(110, 1),(111, 1),(112, 1),(113, 1),(114, 1),(115, 1),(116, 1),(117, 1),(118, 1),(119, 1),(120, 1), (121, 1),(122, 1),(123, 1),(124, 1),(125, 1),(126, 1),(127, 1),(128, 1),(129, 1),(130, 1),(131, 1),(132, 1),(133, 1),(134, 1),(135, 1),(136, 1),(137, 1),(138, 1),(139, 1),(140, 1), (141, 1),(142, 1),(143, 1),(144, 1),(145, 1),(146, 1),(147, 1),(148, 1),(149, 1),(150, 1),(151, 1),(152, 1),(153, 1),(154, 1),(155, 1),(156, 1),(157, 1),(158, 1),(159, 1),(160, 1), (161, 1),(162, 1),(163, 1),(164, 1),(165, 1),(166, 1),(167, 1),(168, 1),(169, 1),(170, 1),(171, 1),(172, 1),(173, 1),(174, 1),(175, 1),(176, 1),(177, 1),(178, 1),(179, 1),(180, 1), (181, 1),(182, 1),(183, 1),(184, 1),(185, 1),(186, 1),(187, 1),(188, 1),(189, 1),(190, 1),(191, 1),(192, 1),(193, 1),(194, 1),(195, 1),(196, 1),(197, 1),(198, 1),(199, 1),(200, 1), (201, 1),(202, 1),(203, 1),(204, 1),(205, 1),(206, 1),(207, 1),(208, 1),(209, 1),(210, 1),(211, 1),(212, 1),(213, 1),(214, 1),(215, 1),(216, 1),(217, 1),(218, 1),(219, 1),(220, 1), (221, 1),(222, 1),(223, 1),(224, 1),(225, 1),(226, 1),(227, 1),(228, 1),(229, 1),(230, 1),(231, 1),(232, 1),(233, 1),(234, 1),(235, 1),(236, 1),(237, 1),(238, 1),(239, 1),(240, 1), (241, 1),(242, 1),(243, 1),(244, 1),(245, 1),(246, 1),(247, 1),(248, 1),(249, 1),(250, 1),(251, 1),(252, 1),(253, 1),(254, 1),(255, 1),(256, 1),(257, 1),(258, 1),(259, 1),(260, 1), (261, 1),(262, 1),(263, 1),(264, 1),(265, 1),(266, 1),(267, 1),(268, 1),(269, 1),(270, 1),(271, 1),(272, 1),(273, 1),(274, 1),(275, 1),(276, 1),(277, 1),(278, 1),(279, 1),(280, 1), (281, 1),(282, 1),(283, 1),(284, 1),(285, 1),(286, 1),(287, 1),(288, 1),(289, 1),(290, 1),(291, 1),(292, 1),(293, 1),(294, 1),(295, 1),(296, 1),(297, 1),(298, 1),(299, 1),(300, 1); -- DONE