SQLQueryinsert.sql

/*(---------ADDRESS_DIVISION INSERT---------)*/
 
INSERT INTO ADDRESS_DIVISION VALUES(02215,'MA','USA')
INSERT INTO ADDRESS_DIVISION VALUES(02216,'MA','USA')
INSERT INTO ADDRESS_DIVISION VALUES(02217,'MA','USA')
INSERT INTO ADDRESS_DIVISION VALUES(02218,'MA','USA')
INSERT INTO ADDRESS_DIVISION VALUES(02219,'MA','USA')
 
INSERT INTO ADDRESS_DIVISION VALUES
(02220,'MA', 'US'), (02221,'MA', 'US'),(02222,'MA', 'US'), (02223,'MA', 'US'), (02224,'MA', 'US'), (02225,'MA', 'US');
 
INSERT INTO ADDRESS_DIVISION VALUES(10001,'NY','USA')
INSERT INTO ADDRESS_DIVISION VALUES(10002,'NY','USA')
INSERT INTO ADDRESS_DIVISION VALUES(10003,'NY','USA')
INSERT INTO ADDRESS_DIVISION VALUES(10004,'NY','USA')
INSERT INTO ADDRESS_DIVISION VALUES(10005,'NY','USA')
INSERT INTO ADDRESS_DIVISION VALUES(10006,'NY','USA')
INSERT INTO ADDRESS_DIVISION VALUES(07302,'NJ','USA')
INSERT INTO ADDRESS_DIVISION VALUES(07303,'NJ','USA')
INSERT INTO ADDRESS_DIVISION VALUES(07304,'NJ','USA')
INSERT INTO ADDRESS_DIVISION VALUES(07305,'NJ','USA')
INSERT INTO ADDRESS_DIVISION VALUES(07306,'NJ','USA')
INSERT INTO ADDRESS_DIVISION VALUES(07307,'NJ','USA')
INSERT INTO ADDRESS_DIVISION VALUES(07308,'NJ','USA')
 
INSERT INTO ADDRESS_DIVISION VALUES(02120,'MA','USA')
INSERT INTO ADDRESS_DIVISION VALUES(02121,'NY','USA')
INSERT INTO ADDRESS_DIVISION VALUES(02101,'LA','USA')

/*(---------PERSON INSERT---------)*/
 
INSERT INTO PERSON VALUES
(02215, 'Simon', 'Frachie', 'female', '11/30/1996', 'simonfrachie@gmail.com', '8976549012', 'st', 'NUQ873412980'),
(02215, 'Shimona', 'Gosling', 'female', '09/10/1996', 'shimonagosling@gmail.com', '7609126589', 'st','NUQ873412891'),
(02215, 'Shinchan', 'Huyang', 'male', '07/24/1996', 'shinchanhuyang@gmail.com', '8976546789', 'st', 'NUQ873489034'),
(02215, 'Christine', 'Rosling', 'female', '11/21/1997', 'christinerosling@gmail.com', '6174709975', 'st', 'NUQ873409908'),
(02215, 'Chriselle', 'Peth', 'female', '09/19/1996', 'chrisellepeth@gmail.com', '6174709973', 'st','NUQ873409765'),
(02215, 'Venassa', 'Guptill', 'female', '08/30/1996', 'venassaguptill@gmail.com', '8978342130', 'st', 'NUQ873409764'),
(02215, 'Nichole', 'Brown', 'female', '12/03/1997', 'nicholebrown@gmail.com', '8998901234', 'st',  'NUQ873409763'),
(02216, 'Micheal', 'Toit', 'male', '12/05/1997', 'michealtoit@gmail.com', '8998901564', 'st',  'NUQ873409762'),
(02216, 'Michelle', 'Yu', 'female', '09/05/1997', 'michelleyu@gmail.com', '8998907898', 'st','NUQ873409761'),
(02216, 'Victoria', 'Beckham', 'female', '07/05/1997', ' victoriabeckham@gmail.com', '8998978542', 'st',  'NUQ873409759'),
(02216, 'Justin', 'Westler', 'male', '06/06/1997', ' justinwestler@gmail.com', '8998978543', 'st',  'NUQ873409758'),
(02216, 'Vick', 'Hustling', 'male', '08/05/1997', ' vickhustling@gmail.com', '8998978523', 'st',  'NUQ873409757'),
(02216, 'Gerard', 'Butler', 'male', '07/08/1997', 'gerardbutler@gmail.com', '8998972341', 'st',  'NUQ873409756'),
(02217, 'Justin', 'Jameson', 'male', '07/12/1997', 'justinj@gmail.com', '8998978654', 'st',  'NUQ873409755'),
(02217, 'George', 'Meson', 'male', '12/12/1995', 'mesongeorge@gmail.com', '8998987123', 'st',  'NUQ873409754'),
(02217, 'Xiang', 'Wing', 'male', '10/12/1997', 'xiwi@gmail.com', '6175469912', 'st',  'NUQ873409753'),
(02218, 'Rose', 'Whisper', 'female', '03/12/1997', 'whisperrose@gmail.com', '8961734790', 'st',  'NUQ873409752'),
(02218, 'Rosalind', 'Young', 'female', '03/09/1997', 'rosalindyoung@gmail.com', '8961736712', 'st',  'NUQ873409751'),
(02218, 'Nick', 'Perry', 'male', '03/22/1997', 'nickperry@gmail.com', '8961734630', 'st',  'NUQ873409750'),
(02218, 'Lewis', 'Henry', 'male', '02/12/1997', 'lewishenry@gmail.com', '6174704563', 'st',  'NUQ873409749'),
(02219, 'Rico', 'Mathew', 'male', '03/17/1997', 'nickperry@gmail.com', '8961734630', 'st',  'NUQ873409750'),
(02219, 'John', 'Mason', 'male', '08/27/1997', 'johnmason@gmail.com', '8961734655', 'st',  'NUQ873409751'),
(02219, 'Amanda', 'Kale', 'female', '08/15/1997', 'amandak@gmail.com', '8961734633', 'st',  'NUQ873409752'),
(02219, 'Katie', 'Joseph', 'female', '09/22/1997', 'katiej@gmail.com', '8961734722', 'st',  'NUQ873409753'),
(02219, 'Amelia', 'Sage', 'female', '10/12/1997', 'ameliasage@gmail.com', '8961736714', 'st',  'NUQ873409754');
 
INSERT INTO PERSON VALUES (02120, 'Ronit','Chougule','male', '1996-04-18','ronit@gmail.com','6178589733','st','NUQ345654345');
INSERT INTO PERSON VALUES (02121, 'Sahil','Gadge','male', '1997-05-20','sahil@gmail.com','6178589932','st','NUQ345654348');
INSERT INTO PERSON VALUES (02120, 'Tejas','Bawankar','male', '1994-09-22','tejas@gmail.com','6178589323','st','NUQ345654342');
INSERT INTO PERSON VALUES (02120, 'Siddhartha','Savant','male', '1996-09-20','sid@gmail.com','6178584324','st','NUQ345904345');
INSERT INTO PERSON VALUES (02101, 'Shekhar','Karedla','male', '1996-03-08','shekhar@gmail.com','6178484344','st','NUQ345952341');
INSERT INTO PERSON VALUES (02101, 'Sandeep','Barla','male', '1999-05-22','sandeep@gmail.com','4178285324','st','NUQ345654444');
INSERT INTO PERSON VALUES (02101, 'Bhargavi','Rao','female', '1996-03-27','bhargavi@gmail.com','6178534324','st','NUQ34565445');
INSERT INTO PERSON VALUES (02120, 'Devashree','Kulkarni','female', '1998-12-17','devashree@gmail.com','5278584324','st','NUQ345654555');
INSERT INTO PERSON VALUES (02121, 'Kimaya','Khilare','female', '1998-02-09','kimaya@gmail.com','5129584324','st','NUQ345654666');
INSERT INTO PERSON VALUES (02101, 'Rucha','Chauthai','female', '1996-02-21','rucha@gmail.com','6378344324','st','NUQ345654777');
INSERT INTO PERSON VALUES (02101, 'Vaibhavi','Tambakhu','female', '1996-08-07','vaibhavi@gmail.com','6328342224','st','NUQ345654888');
INSERT INTO PERSON VALUES (02120, 'Avanti','Dorale','female', '1997-08-29','avanti@gmail.com','9378374322','st','NUQ345654999');
INSERT INTO PERSON VALUES (02121, 'Mrunal','Johnson','female', '1994-05-02','mrunal@gmail.com','9320364324','st','NUQ34565900');
INSERT INTO PERSON VALUES (02121, 'Danial','Moore','male', '2001-02-21','danial@gmail.com','9200344324','st','NUQ345654901');
INSERT INTO PERSON VALUES (02121, 'Mike','Watson','male', '2003-06-11','mike@gmail.com','9008344324','st','NUQ345654802');
INSERT INTO PERSON VALUES (02121, 'Alex','Lee','male', '2004-11-22','alex@gmail.com','9001834324','st','NUQ345654903');
INSERT INTO PERSON VALUES (02120, 'Chintan','Khanna','male', '1994-12-23','chintan@gmail.com','9002834324','st','NUQ345654804');
INSERT INTO PERSON VALUES (02120, 'Lionel','Messi','male', '1990-12-21','lionel@gmail.com','9003834324','st','NUQ345654905');
INSERT INTO PERSON VALUES (02120, 'Jessica','Reus','female', '2001-02-12','jessica@gmail.com','9005834324','st','NUQ345654806');
INSERT INTO PERSON VALUES (02121, 'Ellen','Obama','female', '1995-01-04','ellen@gmail.com','9006834324','st','NUQ345654907');
INSERT INTO PERSON VALUES (02101, 'Cristiano','Ronaldo','male', '1992-04-02','cristiano@gmail.com','9007834324','st','NUQ345654808');
INSERT INTO PERSON VALUES (02101, 'Kevin','Debruyne','male', '1996-02-12','kevin@gmail.com','9008834324','st','NUQ345654909');
INSERT INTO PERSON VALUES (02121, 'Andres','Iniesta','male', '1998-06-08','andres@gmail.com','9009834324','st','NUQ345654810');
INSERT INTO PERSON VALUES (02121, 'Xavi','Hernandez','male', '1999-09-11','xavi@gmail.com','9010834324','st','NUQ345654911');
INSERT INTO PERSON VALUES (02121, 'Gerrad','Pique','male', '2002-02-01','gerrad@gmail.com','9011834324','st','NUQ345654812');
 
INSERT INTO PERSON VALUES
(02215, 'Madeleine', 'Albright', 'female', '10/30/1990', 'albrightmadeline@gmail.com', '8976986567', 'pf',  'NUQ456765897'),
(02216, 'Maya', 'Angelou', 'female', '10/31/1980', 'angeloumaya@gmail.com', '8978976567', 'pf',  'NUQ987656789'),
(02217, 'Scott','Armstrong', 'male', '09/30/1990', 'armstrongscott@gmail.com', '9876789345', 'pf',  'NUQ9871238765'),
(02218, 'Bill', 'Ayers', 'male', '08/24/1990', 'ayersbill@gmail.com', '1209834567', 'pf',  'NUQ875367894'),
(02219, 'Maria', 'Aznar', 'male', '08/23/1990', 'aznarjosemaria@gmail.com', '8976986567', 'pf',  'NUQ456765897'),
(02220, 'Jimmy', 'Carter',  'male', '10/23/1980', 'carterjimmy@gmail.com', '8976984566', 'pf',  'NUQ456765845'),
(02221, 'Noam', 'Chomsky', 'male', '10/30/1990', 'chomskynoam@gmail.com', '8974446567', 'pf',  'NUQ456766787'),
(02222, 'Henry', 'Gates',  'male', '06/12/1985', 'gateshenry@gmail.com', '8974446123', 'pf',  'NUQ456766789'),
(02223, 'Al', 'Gore', 'male', '10/10/1987', 'goreal@gmail.com', '1234321234', 'pf',  'NUQ456787937'),
(02224, 'Grandin', 'Temple', 'male', '05/25/1986', 'grandintemple@gmail.com', '8974449999', 'pf',  'NUQ456766782');
 
INSERT INTO PERSON VALUES
(02225, 'Sohil', 'Thakur', 'male', '05/15/1986', 'thakursohil@gmail.com', '8974449449', 's',  'NUQ456766882'),
(02215, 'Siddhesh', 'Sharma', 'male', '05/25/1986', 'sharmasiddhesh@gmail.com', '8974445799', 's',  'NUQ456766982'),
(02216, 'Yash', 'Jain', 'male', '05/25/1990', 'jainyash@gmail.com', '8974449900', 's',  'NUQ456766702'),
(02217, 'Geoff', 'Thomas', 'male', '05/25/1992', 'thomasgeoff@gmail.com', '8974449901', 's',  'NUQ456766712'),
(02218, 'Abhilash', 'Sharma', 'male', '03/13/1986', 'sharmaabhilash@gmail.com', '8974449902', 's',  'NUQ456766722'),
(02219, 'Ferry', 'Sharma', 'male', '05/23/1990', 'sharmaferry@gmail.com', '8974449903', 's',  'NUQ456766732'),
(02220, 'Shubham', 'Yadav', 'male', '05/25/1989', 'yadavshubham@gmail.com', '8974449904', 's',  'NUQ456766742'),
(02221, 'Nick', 'Patel', 'male', '05/26/1986', 'patelnick@gmail.com', '8974449905', 's',  'NUQ456766752'),
(02222, 'Gaurav', 'Thakur', 'male', '05/27/1986', 'thakurgaurav@gmail.com', '8974449906', 's',  'NUQ456766762'),
(02223, 'Azhar', 'Khan', 'male', '05/28/1986', 'khanazhar@gmail.com', '8974449907', 's',  'NUQ456766772');
 
INSERT INTO PERSON VALUES (10001, 'Adah','Kamat','male', '1968-04-18','adahkamat@gmail.com','6178581213','dr','NUQ678967856');
INSERT INTO PERSON VALUES (10002, 'Ishita','Lad','female', '1966-08-22','ishitalad33@gmail.com','9774658121','dr','NUQ678967855');
INSERT INTO PERSON VALUES (10003, 'Navya','Sathe','female', '1965-11-06','navyasathe6@gmail.com','8456535647','dr','NUQ678967858');
INSERT INTO PERSON VALUES (10004, 'Taraa','Shetty','female', '1972-12-16','taraas_16@gmail.com','6745321123','dr','NUQ678967859');
INSERT INTO PERSON VALUES (10005, 'Kevin','Patel','female', '1961-11-19','kevinPatel19@gmail.com','7896057689','dr','NUQ678967860');
INSERT INTO PERSON VALUES (10005, 'Nimit','Soman','female', '1962-04-29','nimitsoman@gmail.com','9898765403','dr','NUQ678967861');
INSERT INTO PERSON VALUES (10006, 'Aman','Dev','male', '1966-09-19','amand19@gmail.com','9867957485','dr','NUQ678967862');
INSERT INTO PERSON VALUES (07302, 'Raunak','Kumbhar','male', '1969-09-14','raunakkumbhar14@gmail.com','8567327317','dr','NUQ678967863');
INSERT INTO PERSON VALUES (07303, 'Yash','Gokhale','male', '1975-09-24','yashgokhale@gmail.com','8574448976','dr','NUQ678967864');
INSERT INTO PERSON VALUES (07304, 'Andal','Salvi','male', '1977-07-12','andalsalvi@gmail.com','7768690567','dr','NUQ678967865');
INSERT INTO PERSON VALUES (07305, 'Chaitali','Hundlani','female', '1967-09-17','chaitali17h@gmail.com','9998671232','dr','NUQ678967866');
INSERT INTO PERSON VALUES (07306, 'Durga','Sawant','female', '1973-05-19','durgasawant@gmail.com','9856567223','dr','NUQ678967867');
INSERT INTO PERSON VALUES (07307, 'Harsha','Godbole','female', '1971-06-29','harshagodbole@gmail.com','7667502093','dr','NUQ678967868');
INSERT INTO PERSON VALUES (07308, 'Johar','Pradhan','male', '1978-09-30','joharpardhan30@gmail.com','6786723222','dr','NUQ678967869');


/*(--------- VACCINATION INSERT---------)*/
 
 
INSERT INTO VACCINATION VALUES (1, 'covishield','01-05-2021',2,'Fenway Post covid center 2');
INSERT INTO VACCINATION VALUES (2, 'Covaxine','07-06-2021',1,'412 Park avenue center 1');
INSERT INTO VACCINATION VALUES (3, 'Pfizer','11-07-2021',2,'Dubai vaccine covid center 9');
INSERT INTO VACCINATION VALUES (4, 'covishield','12-05-2021',2,'6 Street park covid center 2');
INSERT INTO VACCINATION VALUES (5, 'Covishield','10-06-2021',2,'12 Beaker street covid center');
INSERT INTO VACCINATION VALUES (6, 'covishield','07-05-2021',2,'New port Post covid center 2');
INSERT INTO VACCINATION VALUES (7, 'Pfizer','03-05-2021',2,'Boston hospital covid center');
INSERT INTO VACCINATION VALUES (8, 'Pfizer','11-05-2021',2,'Sharjah hospital center');
INSERT INTO VACCINATION VALUES (9, 'Pfizer','04-05-2021',2,'New Jersey City hospital center');
INSERT INTO VACCINATION VALUES (10, 'Pfizer','01-05-2021',2,'NewYork City hospital center');
INSERT INTO VACCINATION VALUES (11, 'covishield','11-07-2021',2,'71 ground John hospital covid center');


/*(--------- BUILDING INSERT---------)*/

INSERT INTO BUILDING VALUES(1, 101, 'COE','Behrakiz', 50)
INSERT INTO BUILDING VALUES(2, 201, 'khoury','Edd Hall', 100)
INSERT INTO BUILDING VALUES(2, 202, 'khoury','Edd Hall', 90)
INSERT INTO BUILDING VALUES(2, 203, 'khoury','Edd Hall', 40)
INSERT INTO BUILDING VALUES(3, 301, 'Law College','Michael Hall', 80)
INSERT INTO BUILDING VALUES(3, 302, 'Law College','Michael Hall', 70)
INSERT INTO BUILDING VALUES(3, 303, 'Law College','Michael Hall', 100)
INSERT INTO BUILDING VALUES(4, 401, 'khoury','International Hall', 90)
INSERT INTO BUILDING VALUES(4, 402, 'khoury','International Hall', 90)
INSERT INTO BUILDING VALUES(4, 403, 'khoury','International Hall', 90)
INSERT INTO BUILDING VALUES(4, 404, 'khoury','International Hall', 90)
INSERT INTO BUILDING VALUES(5, 501, 'COE','ELL Hall', 100)
INSERT INTO BUILDING VALUES(5, 502, 'COE','ELL Hall', 100)
INSERT INTO BUILDING VALUES(5, 503, 'COE','ELL Hall', 100)
INSERT INTO BUILDING VALUES(5, 504, 'COE','ELL Hall', 100)
INSERT INTO BUILDING VALUES(6, 601, 'Law College','Richard Hall', 150)
INSERT INTO BUILDING VALUES(6, 602, 'Law College','Richard Hall', 150)
INSERT INTO BUILDING VALUES(6, 603, 'Law College','Richard Hall', 150)
INSERT INTO BUILDING VALUES(6, 604, 'Law College','Richard Hall', 150)
INSERT INTO BUILDING VALUES(6, 605, 'Law College','Richard Hall', 150)
INSERT INTO BUILDING VALUES(7, 701, 'COE','Curry Center', 200)
INSERT INTO BUILDING VALUES(7, 702, 'COE','Curry Center', 200)
INSERT INTO BUILDING VALUES(8, 801, 'khoury','Charchil Hall', 50)
INSERT INTO BUILDING VALUES(8, 802, 'khoury','Charchil Hall', 50)
INSERT INTO BUILDING VALUES(8, 803, 'khoury','Charchil Hall', 50)


/*(--------- COVID_RECORD INSERT---------)*/

INSERT INTO COVID_RECORD VALUES (1, 99, 97, 'Negative', '2021-05-13 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (3, 101.1, 88, 'Positive', '2021-06-14 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (5, 99, 99, 'Negative', '2021-07-15 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (7, 101.6, 85, 'Positive', '2021-08-16 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (9, 101.1, 87, 'Positive', '2021-09-17 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (11, 99, 96, 'Negative', '2021-10-18 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (13, 99, 97, 'Negative', '2021-11-19 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (15, 101.4, 86, 'Positive', '2021-10-20 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (17, 99, 98, 'Negative', '2021-01-21 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (19, 99, 99, 'Negative', '2021-02-22 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (21, 101.3, 88, 'Positive', '2021-03-23 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (23, 99, 99, 'Negative', '2021-04-24 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (25, 101.2, 89, 'Positive', '2021-05-25 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (27, 99, 95, 'Negative', '2021-06-26 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (29, 101.8, 87, 'Positive', '2021-07-27 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (31, 99, 97, 'Negative', '2021-08-28 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (33, 99, 98, 'Negative', '2021-09-29 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (35, 101.9, 84, 'Positive', '2021-10-30 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (37, 99, 94, 'Negative', '2021-11-01 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (39, 99, 96, 'Negative', '2021-10-02 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (41, 101.7, 85, 'Positive', '2021-01-03 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (43, 99, 98, 'Negative', '2021-02-04 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (45, 99, 99, 'Negative', '2021-05-05 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (47, 101.8, 87, 'Positive', '2021-08-06 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (49, 99, 97, 'Negative', '2021-10-07 07:15:31.0', 'RTPCR')
 
INSERT INTO COVID_RECORD VALUES (51, 99, 97, 'Negative', '2021-05-13 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (53, 101.1, 88, 'Positive', '2021-06-14 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (55, 99, 99, 'Negative', '2021-07-15 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (57, 101.6, 85, 'Positive', '2021-08-16 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (59, 101.1, 87, 'Positive', '2021-09-17 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (61, 99, 96, 'Negative', '2021-10-18 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (63, 99, 97, 'Negative', '2021-11-19 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (65, 101.4, 86, 'Positive', '2021-10-20 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (67, 99, 98, 'Negative', '2021-01-21 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (69, 99, 99, 'Negative', '2021-02-22 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (71, 101.3, 88, 'Positive', '2021-03-23 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (72, 99, 99, 'Negative', '2021-04-24 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (73, 101.2, 89, 'Positive', '2021-05-25 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (74, 99, 95, 'Negative', '2021-06-26 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (75, 101.8, 87, 'Positive', '2021-07-27 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (76, 99, 97, 'Negative', '2021-08-28 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (77, 99, 98, 'Negative', '2021-09-29 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (78, 101.9, 84, 'Positive', '2021-10-30 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (79, 99, 94, 'Negative', '2021-11-01 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (80, 99, 96, 'Negative', '2021-10-02 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (81, 101.7, 85, 'Positive', '2021-01-03 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (82, 99, 98, 'Negative', '2021-02-04 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (83, 99, 99, 'Negative', '2021-05-05 07:15:31.0', 'RTPCR')
INSERT INTO COVID_RECORD VALUES (84, 101.8, 87, 'Positive', '2021-08-06 07:15:31.0', 'Antigen')
INSERT INTO COVID_RECORD VALUES (70, 99, 97, 'Negative', '2021-10-07 07:15:31.0', 'RTPCR');

/*(--------- QUARANTINE CENTER INSERT---------)*/
insert into QUARANTINE_CENTER VALUES (111, 'boylston street'), (112, 'ward street'), (113,'park street'), (114,'huntington avenue'),
(115,'roxbury street'), (116,'longwood street'), (117,'lawn street'), (118,'smith street'), (119,'heath street'), (120,'charles street');


/*(--------- QUARANTINE INSERT---------)*/
INSERT into QUARANTINE values(111, 1, '10/20/2019'), (112, 10, '10/25/2020'), (113, 15, '10/18/2020'), (114, 20, '09/20/2020'),
(115, 25, '08/20/2021'), (116, 30, '07/10/2021'), (117, 35, '01/27/2020'), (118, 40, '01/20/2019'), (119, 45, '10/21/2020'),
(120, 50, '02/02/2020');


/*(--------- VISIT INSERT---------)*/
INSERT INTO VISIT VALUES(1, 2, 202, '2021-07-14 07:20:31.0')
INSERT INTO VISIT VALUES(8, 2, 203, '2021-07-15 07:20:31.0')
INSERT INTO VISIT VALUES(10, 2, 203, '2021-07-16 08:20:31.0')
INSERT INTO VISIT VALUES(17, 2, 203, '2021-07-16 08:20:31.0')
INSERT INTO VISIT VALUES(20, 3, 302, '2021-08-16 09:20:31.0')
INSERT INTO VISIT VALUES(22, 3, 302, '2021-08-18 09:20:31.0')
INSERT INTO VISIT VALUES(25, 3, 302, '2021-08-21 09:20:31.0')
INSERT INTO VISIT VALUES(29, 3, 303, '2021-08-22 10:20:31.0')
INSERT INTO VISIT VALUES(33, 4, 404, '2021-09-25 11:20:31.0')
INSERT INTO VISIT VALUES(36, 4, 404, '2021-09-24 18:20:31.0')
INSERT INTO VISIT VALUES(39, 4, 404, '2021-09-29 16:20:31.0')
INSERT INTO VISIT VALUES(40, 4, 402, '2021-09-30 04:20:31.0')
INSERT INTO VISIT VALUES(42, 5, 501, '2021-10-14 06:20:31.0')
INSERT INTO VISIT VALUES(46, 5, 501, '2021-10-15 14:20:31.0')
INSERT INTO VISIT VALUES(49, 5, 502, '2021-10-18 12:20:31.0')
INSERT INTO VISIT VALUES(51, 6, 601, '2021-10-02 11:20:31.0')
INSERT INTO VISIT VALUES(53, 6, 601, '2021-11-09 19:20:31.0')
INSERT INTO VISIT VALUES(55, 6, 601, '2021-11-07 23:20:31.0')
INSERT INTO VISIT VALUES(57, 7, 702, '2021-11-05 19:20:31.0')
INSERT INTO VISIT VALUES(59, 7, 702, '2021-11-04 21:20:31.0')
INSERT INTO VISIT VALUES(63, 7, 702, '2021-08-07 06:20:31.0')
INSERT INTO VISIT VALUES(68, 8, 801, '2021-10-04 04:20:31.0')
INSERT INTO VISIT VALUES(75, 8, 802, '2021-10-02 03:20:31.0')
INSERT INTO VISIT VALUES(78, 8, 803, '2021-07-05 06:20:31.0')
INSERT INTO VISIT VALUES(83, 8, 803, '2021-09-08 02:20:31.0')


/*(--------- STUDENT INSERT---------)*/

INSERT INTO STUDENT VALUES(1,'Fall', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(2,'Fall', 'Computer Science', 'bachelor')
INSERT INTO STUDENT VALUES(3,'Spring', 'Civil EM', 'Masters')
INSERT INTO STUDENT VALUES(4,'Summer', 'Information Systems', 'bachelor')
INSERT INTO STUDENT VALUES(5,'Fall', 'Civil EM', 'Masters')
INSERT INTO STUDENT VALUES(6,'Spring', 'Computer Science', 'bachelor')
INSERT INTO STUDENT VALUES(7,'Summer', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(8,'Fall', 'Civil EM', 'bachelor')
INSERT INTO STUDENT VALUES(9,'Summer', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(10,'Spring', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(11,'Fall', 'Information Systems', 'bachelor')
INSERT INTO STUDENT VALUES(12,'Summer', 'Computer Science', 'Masters')
INSERT INTO STUDENT VALUES(13,'Fall', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(14,'Fall', 'Civil EM', 'Masters')
INSERT INTO STUDENT VALUES(15,'Fall', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(16,'Summer', 'Civil EM', 'bachelor')
INSERT INTO STUDENT VALUES(17,'Fall', 'Computer Science', 'Masters')
INSERT INTO STUDENT VALUES(18,'Spring', 'Information Systems', 'bachelor')
INSERT INTO STUDENT VALUES(19,'Fall', 'Computer Science', 'Masters')
INSERT INTO STUDENT VALUES(20,'Summer', 'Information Systems', 'bachelor')
INSERT INTO STUDENT VALUES(21,'Fall', 'Civil EM', 'Masters')
INSERT INTO STUDENT VALUES(22,'Spring', 'Information Systems', 'bachelor')
INSERT INTO STUDENT VALUES(23,'Summer', 'Computer Science', 'bachelor')
INSERT INTO STUDENT VALUES(24,'Fall', 'Civil EM', 'bachelor')
INSERT INTO STUDENT VALUES(25,'Spring', 'Information Systems', 'Masters')
 
INSERT INTO STUDENT VALUES(26,'Fall', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(27,'Fall', 'Computer Science', 'bachelor')
INSERT INTO STUDENT VALUES(28,'Spring', 'Mechanical Systems', 'Masters')
INSERT INTO STUDENT VALUES(29,'Summer', 'Information Systems', 'bachelor')
INSERT INTO STUDENT VALUES(30,'Fall', 'Mechanical Systems', 'Masters')
INSERT INTO STUDENT VALUES(31,'Spring', 'Computer Science', 'bachelor')
INSERT INTO STUDENT VALUES(32,'Summer', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(33,'Fall', 'Mechanical Systems', 'bachelor')
INSERT INTO STUDENT VALUES(34,'Summer', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(35,'Spring', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(36,'Fall', 'Mechanical Systems', 'bachelor')
INSERT INTO STUDENT VALUES(37,'Summer', 'Computer Science', 'Masters')
INSERT INTO STUDENT VALUES(38,'Fall', 'Information Systems', 'Masters')
INSERT INTO STUDENT VALUES(39,'Fall', 'Computer Science', 'Masters')
INSERT INTO STUDENT VALUES(40,'Fall', 'Mechanical Systems', 'Masters')
INSERT INTO STUDENT VALUES(41,'Summer', 'Information Systems', 'bachelor')
INSERT INTO STUDENT VALUES(42,'Fall', 'Computer Science', 'Masters')
INSERT INTO STUDENT VALUES(43,'Spring', 'Mechanical Systems', 'bachelor')
INSERT INTO STUDENT VALUES(44,'Fall', 'Computer Science', 'Masters')
INSERT INTO STUDENT VALUES(45,'Summer', 'Information Systems', 'bachelor')
INSERT INTO STUDENT VALUES(46,'Fall', 'Mechanical Systems', 'Masters')
INSERT INTO STUDENT VALUES(47,'Spring', 'Information Systems', 'bachelor')
INSERT INTO STUDENT VALUES(48,'Summer', 'Computer Science', 'bachelor')
INSERT INTO STUDENT VALUES(49,'Fall', 'Mechanical Systems', 'bachelor')
INSERT INTO STUDENT VALUES(50,'Spring', 'Information Systems', 'Masters')


/*(--------- UHCS_RECORD INSERT---------)*/
INSERT INTO UHCS_RECORD VALUES (5,'12-09-2020 07:20:31.0','fever','C','acetaminophen or ibuprofen',null);
INSERT INTO UHCS_RECORD VALUES (10,'11-05-2021 08:20:31.0','cough','C','dextromethorphan', null);
INSERT INTO UHCS_RECORD VALUES (15,'12-09-2020 11:20:31.0','constipation','C','Linaclotide', null);
INSERT INTO UHCS_RECORD VALUES (25,'04-09-2021 03:20:31.0','stomach pain','C','acetaminophen or loperamide',null);
INSERT INTO UHCS_RECORD VALUES (45,'05-10-2020 23:20:31.0','stuffy nose','C','oxymetazoline',null);
INSERT INTO UHCS_RECORD VALUES (52,'02-09-2021 11:20:31.0','fever','C','acetaminophen',null);
INSERT INTO UHCS_RECORD VALUES (58,'11-10-2021 09:20:31.0','headache','C','Naproxen',null);
INSERT INTO UHCS_RECORD VALUES (55,'07-07-2020 08:20:31.0','sore throat','C','naproxen',null);
INSERT INTO UHCS_RECORD VALUES (68,'12-12-2020 15:20:31.0','fever','C','acetaminophen',null);
INSERT INTO UHCS_RECORD VALUES (62,'04-08-2021 13:20:31.0','nausea','C','Ativan',null);
INSERT INTO UHCS_RECORD VALUES (64,'11-09-2021 13:20:31.0','loss of smell','C','hydroxychloroquine',null);
INSERT INTO UHCS_RECORD VALUES (70,'12-11-2021 13:20:31.0','loss of taste','C','Ativan',null);
INSERT INTO UHCS_RECORD VALUES (66,'14-11-2021 13:20:31.0','loss of taste','C','hydroxychloroquine',null);
 

 /*(--------- COURSE INSERT---------)*/
INSERT INTO COURSE VALUES('DMDD',4)
INSERT INTO COURSE VALUES('AED',4)
INSERT INTO COURSE VALUES('ENCP',1)
INSERT INTO COURSE VALUES('Web Design',3)
INSERT INTO COURSE VALUES('Web Tools',3)
INSERT INTO COURSE VALUES('Data Science',3)
INSERT INTO COURSE VALUES('Deep Learning',4)
INSERT INTO COURSE VALUES('DADABI',1)
INSERT INTO COURSE VALUES('DAM',4)
INSERT INTO COURSE VALUES('BISA',4)

/*(--------- PROFESSOR INSERT---------)*/ 
insert into PROFESSOR VALUES(51,'Computer Science', 'Associate Professor'), (52,'Civil', 'Associate Professor'),
(53,'Mechanical', 'Associate Professor'), (54,'Information Systems','Associate Professor'),
(55,'Computer Science','Professor'), (56,'Computer Science',''), (57,'Information Systems','Professor'),
(58,'Information Systems','Assistant Professor'),
(59,'Electrical','Professor'), (60,'Mechanical','Associate Professor');


/*(--------- STAFF INSERT---------)*/
INSERT INTO STAFF VALUES(61,'Security Officer',6)
INSERT INTO STAFF VALUES(62,'Electronic Maintenance Technician Officer',4)
INSERT INTO STAFF VALUES(63,'Building Maintenance Worker',7)
INSERT INTO STAFF VALUES(64,'Janitor',8)
INSERT INTO STAFF VALUES(65,'Security Officer',6)
INSERT INTO STAFF VALUES(66,'Jaintor',8)
INSERT INTO STAFF VALUES(67,'Electronic Maintenance Technician Officer',4)
INSERT INTO STAFF VALUES(68,'Electronic Maintenance Technician Officer',4)
INSERT INTO STAFF VALUES(69,'Security Officer',6)
INSERT INTO STAFF VALUES(70,'Security Officer',6)


/*(--------- UHCS_DOCTOR INSERT---------)*/
INSERT INTO UHCS_DOCTOR VALUES (71,'MBBS,MD',20);
INSERT INTO UHCS_DOCTOR VALUES (72,'BDS',15);
INSERT INTO UHCS_DOCTOR VALUES (73,'MBBS,MD',22);
INSERT INTO UHCS_DOCTOR VALUES (74,'BHMS',19);
INSERT INTO UHCS_DOCTOR VALUES (75,'MBBS,MD',20);
INSERT INTO UHCS_DOCTOR VALUES (76,'BDS',20);
INSERT INTO UHCS_DOCTOR VALUES (77,'BHMS',29);
INSERT INTO UHCS_DOCTOR VALUES (78,'BDS',22);
INSERT INTO UHCS_DOCTOR VALUES (79,'MBBS,MD',21);
INSERT INTO UHCS_DOCTOR VALUES (80,'BHMS',20);
INSERT INTO UHCS_DOCTOR VALUES (81,'BDS',17);
INSERT INTO UHCS_DOCTOR VALUES (82,'MBBS,MD',20);
INSERT INTO UHCS_DOCTOR VALUES (83,'MBBS,MD',19);
INSERT INTO UHCS_DOCTOR VALUES (84,'BDS',22);
 

/*(--------- REGISTER INSERT---------)*/

INSERT INTO REGISTER VALUES
(1610000, 21467, 3000,'first'),
(1610002, 21469, 3001,'second'),
(1610004, 21471, 3002,'third'),
(1610006, 21473, 3003,'final'),
(1610008, 21475, 3004,'first'),
(1610010, 21477, 3005,'second'),
(1610012, 21479, 3006,'third'),
(1610014, 21481, 3007,'final'),
(1610016, 21483, 3008,'first'),
(1610018, 21485, 3009,'second'),
 
(1610020, 21467, 3000,'first'),
(1610022, 21469, 3001,'second'),
(1610024, 21471, 3002,'third'),
(1610026, 21473, 3003,'final'),
(1610028, 21475, 3004,'first'),
(1610030, 21477, 3005,'second'),
(1610032, 21479, 3006,'third'),
(1610034, 21481, 3007,'final'),
(1610036, 21483, 3008,'first'),
(1610038, 21485, 3009,'second'),
 
(1610040, 21467, 3000,'first'),
(1610042, 21469, 3001,'second'),
(1610044, 21471, 3002,'third'),
(1610046, 21473, 3003,'final'),
(1610048, 21475, 3004,'first'),
(1610050, 21477, 3005,'second'),
(1610052, 21479, 3006,'third'),
(1610054, 21481, 3007,'final'),
(1610056, 21483, 3008,'first'),
(1610058, 21485, 3009,'second'),
 
(1610060, 21467, 3000,'first'),
(1610062, 21469, 3001,'second'),
(1610064, 21471, 3002,'third'),
(1610066, 21473, 3003,'final'),
(1610068, 21475, 3004,'first'),
(1610070, 21477, 3005,'second'),
(1610072, 21479, 3006,'third'),
(1610074, 21481, 3007,'final'),
(1610076, 21483, 3008,'first'),
(1610078, 21485, 3009,'second'),
 
(1610080, 21467, 3000,'first'),
(1610082, 21469, 3001,'second'),
(1610084, 21471, 3002,'third'),
(1610086, 21473, 3003,'final'),
(1610088, 21475, 3004,'first'),
(1610090, 21477, 3005,'second'),
(1610092, 21479, 3006,'third'),
(1610094, 21481, 3007,'final'),
(1610096, 21483, 3008,'first'),
(1610098, 21485, 3009,'second')


/*(--------- ACCESS INSERT---------)*/
 
INSERT INTO ACCESS VALUES (5001,911);
INSERT INTO ACCESS VALUES (5002,913);
INSERT INTO ACCESS VALUES (5003,911);
INSERT INTO ACCESS VALUES (5004,915);
INSERT INTO ACCESS VALUES (5005,917);
INSERT INTO ACCESS VALUES (5006,919);
INSERT INTO ACCESS VALUES (5007,921);
INSERT INTO ACCESS VALUES (5008,923);
INSERT INTO ACCESS VALUES (5009,933);
INSERT INTO ACCESS VALUES (5010,935);

update VACCINATION set numberOfVaccination=1 where vaccinationID=507 and personID=8
update VACCINATION set numberOfVaccination=1 where vaccinationID=510 and personID=11
update VACCINATION set numberOfVaccination=1 where vaccinationID=504 and personID=5