web programming

################## # book table ################## INSERT INTO book VALUES(101, 'LB2351.2 .F475 2011', 'Crazy U', 'Simon & Schuster', 'Hardcover', true, 25.00); INSERT INTO book VALUES(102, 'HV8079.C65 C93 2008', 'Cyber Forensics', 'Auerbach', 'Library', true, 87.95); INSERT INTO book VALUES(103, 'HA32.S572 2004', 'SPSS for Introductory Statistics', 'Lawrence Erlbaum', 'Paperback', true, 29.95); INSERT INTO book VALUES(104, 'QA76.76.C68 S29 2018', 'Malware Data Science', 'No Starch Press', 'paperback', false, 49.95); INSERT INTO book VALUES(105, 'HN90.I56.L37 2005', 'Darknet', 'Wiley', 'Hardcover', false, 25.95); INSERT INTO book VALUES(106, 'BCJ971.B8 W5513 2010', 'Hagakure', 'Kodansha', 'Paperback', true, 14.95); INSERT INTO book VALUES(107, 'QA76.9 .A25 M567 2005', 'The Art of Intrusion', 'Wiley', 'Library', true, 27.50); INSERT INTO book VALUES(108, 'BF76.7 .P83 2001', 'APA Publication Manual 5e', 'APA', 'Paperback', false, 49.95); ################## # patron table ################## INSERT INTO patron VALUES(1856, 'O\'Brian', 'Lisa', 'undergrad'); INSERT INTO patron VALUES(2179, 'Linden', 'Erik', 'graduate'); INSERT INTO patron VALUES(1142, 'Le', 'Tran', 'undergrad'); INSERT INTO patron VALUES(2038, 'Washington', 'LaTrisia', 'graudate'); INSERT INTO patron VALUES(6587, 'Lopez', 'Marcela', 'staff'); INSERT INTO patron VALUES(5192, 'Ng', 'Tony', 'faculty'); INSERT INTO patron VALUES(5728, 'Ellis', 'Mandy', 'faculty'); INSERT INTO patron VALUES(1028, 'Campbell', 'Mike', 'undergrad'); ##################### # bookpatron table ##################### INSERT INTO bookpatron VALUES(101, 6587, '2019-09-15', null, false); INSERT INTO bookpatron VALUES(102, 5192, '2019-10-28', null, false); INSERT INTO bookpatron VALUES(103, 2179, '2018-05-09', '2018-06-30', false); INSERT INTO bookpatron VALUES(103, 5728, '2018-03-25', null, true); INSERT INTO bookpatron VALUES(105, 1028, '2017-08-17', '2017-09-05', false); INSERT INTO bookpatron VALUES(106, 1142, '2019-04-01', null, false); INSERT INTO bookpatron VALUES(107, 2179, '2019-03-25', null, false); INSERT INTO bookpatron VALUES(108, 5728, '2016-09-28', '2016-12-03', false);