insertion.sql

 --<----------------------- company side ----------------------->


-------- Insert Employees

-- Positve insertions for Employees hierarchy
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Monique Vaughan-Hughes', '83520 Reindahl Court', 93791547, 'mvaughanhughes0@php.net', '2020-06-29', '2021-02-18');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Carline Melbury', '079 Vera Park', 80681213, 'cmelbury1@nba.com', '2020-03-09', '2020-08-20');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Vivia Colquitt', '11280 Messerschmidt Circle', 94049769, 'vcolquitt2@sphinn.com', '2020-10-30', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Reyna Dancer', '6 Becker Trail', 83203719, 'rdancer3@newsvine.com', '2020-07-21', '2020-09-04');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Mandel Ruzek', '89882 Mosinee Pass', 99804305, 'mruzek4@google.it', '2021-03-29', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Evelin Cloke', '5 Sutherland Drive', 99929540, 'ecloke5@ifeng.com', '2020-04-13', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Willdon Shallow', '7 Welch Terrace', 94874511, 'wshallow6@usa.gov', '2020-07-07', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Brooks Rodolico', '0782 Raven Parkway', 84428906, 'brodolico7@pinterest.com', '2020-10-23', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Alejandro Mcwhinnie', '9 Redwing Junction', 92825050, 'amcwhinnie8@epa.gov', '2020-11-27', '2021-03-02');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Thatcher Taffley', '53607 Memorial Circle', 95816445, 'ttaffley9@wired.com', '2020-07-07', '2020-10-28');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Duke Bold', '6 Crescent Oaks Road', 88750510, 'dbolda@networkadvertising.org', '2021-03-11', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Florie Izkovitz', '2 Grim Alley', 99786865, 'fizkovitzb@blogs.com', '2021-03-02', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Hinda Belliss', '5673 Briar Crest Junction', 92620980, 'hbellissc@howstuffworks.com', '2020-11-22', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Ed Kimmings', '29869 Sommers Lane', 84409716, 'ekimmingsd@java.com', '2020-12-20', '2021-01-09');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Giffie Count', '63 Eastlawn Parkway', 80064723, 'gcounte@cisco.com', '2020-04-05', '2020-11-23');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Nell Dragge', '79 American Park', 84512276, 'ndraggef@blogs.com', '2020-09-17', '2021-03-03');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Jamil Wherrett', '71 Rigney Center', 82378116, 'jwherrettg@webeden.co.uk', '2020-04-27', '2020-06-26');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Shellysheldon Merner', '815 Ramsey Trail', 88359347, 'smernerh@typepad.com', '2020-04-20', '2020-11-02');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Lorena Potier', '1606 Marquette Street', 83814468, 'lpotieri@ucoz.com', '2021-02-27', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Alonzo Berisford', '135 Crescent Oaks Road', 97192688, 'aberisfordj@economist.com', '2021-01-17', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Pepi Sherwyn', '01477 Banding Plaza', 96246243, 'psherwynk@github.io', '2020-05-12', '2020-11-07');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Tami Vodden', '1 Pine View Pass', 81744565, 'tvoddenl@cisco.com', '2020-09-15', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Grantley Giff', '4214 Cherokee Drive', 87757034, 'ggiffm@oakley.com', '2020-04-29', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Lila Rubinsaft', '34479 Hauk Hill', 80848442, 'lrubinsaftn@seattletimes.com', '2020-10-02', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Viki Bes', '9 Rieder Lane', 92508570, 'vbeso@parallels.com', '2021-02-02', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Gabriellia Vlasenko', '6355 Del Sol Circle', 98895079, 'gvlasenkop@cbc.ca', '2020-05-20', '2021-01-19');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Jasen Mengo', '8 Leroy Junction', 87067538, 'jmengoq@sbwire.com', '2021-02-18', '2020-06-01');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Sherman Dillingham', '9 Debs Trail', 90236018, 'sdillinghamr@oaic.gov.au', '2020-08-21', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Danika Beebee', '945 School Plaza', 85669083, 'dbeebees@howstuffworks.com', '2020-11-20', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Dylan Saffe', '4 Blaine Plaza', 83118209, 'dsaffet@squidoo.com', '2020-04-14', '2020-12-29');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Marijo Tyers', '61992 Eastwood Trail', 86990811, 'mtyersu@cocolog-nifty.com', '2020-04-27', '2020-05-27');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Markus Reimer', '20471 Saint Paul Parkway', 80592548, 'mreimerv@hexun.com', '2021-03-23', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Meghann Beville', '66 Toban Street', 92575876, 'mbevillew@addtoany.com', '2020-07-15', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Martica Cossum', '91 Graceland Lane', 85758117, 'mcossumx@miibeian.gov.cn', '2020-11-07', '2021-01-23');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Bonnibelle Sleaford', '92883 Corscot Parkway', 86772156, 'bsleafordy@kickstarter.com', '2020-09-08', '2021-03-30');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Anetta Holbie', '2702 Kedzie Pass', 90009840, 'aholbiez@furl.net', '2020-07-08', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Fanechka Seeman', '9927 Dottie Street', 95618835, 'fseeman10@goo.ne.jp', '2020-10-30', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Weylin Grogona', '512 Anniversary Terrace', 82368819, 'wgrogona11@unesco.org', '2020-05-01', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Prinz Salmen', '4 Raven Avenue', 89221168, 'psalmen12@mlb.com', '2020-12-24', NULL);
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Matteo Goodbarne', '4 Oakridge Pass', 84836578, 'mgoodbarne13@constantcontact.com', '2020-05-28', '2020-06-27');

-- Negative insertions for Employees hierarchy
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Pancho Tiernan', '7 Sunfield Way', 99475631, 'ptiernand@wiley.com', '2020-07', '2021-03-31');
INSERT INTO Employees (name, address, phone, email, join_date, depart_date) VALUES ('Denis Vitte', '63902 Northland Point', 93036730, 'dvittee@indiegogo.com', NULL, '2020-12-01');


-------- Insert Part_time_emp

-- Positve insertions for Part_time_emp
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (1, 181.65);
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (2, 74.5);
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (3, 40.02);
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (4, 30.4);
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (5, 97.64);
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (6, 172.47);
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (7, 106.76);
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (8, 166.29);
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (9, 52.84);
INSERT INTO Part_time_emp (eid, hourly_rate) VALUES (10, 121.8);

-- Negative insertions for Part_time_emp

-------- Insert Full_time_emp

-- Positve insertions for Full_time_emp
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (11, 2498.71);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (12, 6657.6);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (13, 1871.16);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (14, 13720.14);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (15, 17379.43);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (16, 16054.66);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (17, 15607.85);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (18, 11318.07);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (19, 17949.38);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (20, 10143.3);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (21, 17869.1);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (22, 15782.84);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (23, 5699.07);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (24, 10031.57);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (25, 7027.88);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (26, 11955.85);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (27, 10002.81);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (28, 18565.96);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (29, 7540.22);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (30, 1322.98);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (31, 6933.71);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (32, 16847.11);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (33, 18386.67);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (34, 15185.09);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (35, 13098.43);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (36, 9160.57);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (37, 2061.32);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (38, 18507.38);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (39, 11557.5);
INSERT INTO Full_time_emp (eid, monthly_salary) VALUES (40, 4669.47);
-- Negative insertions for Full_time_emp

-------- Insert Instructors

-- Positve insertions for Instructors
INSERT INTO Instructors (eid) VALUES (1);
INSERT INTO Instructors (eid) VALUES (2);
INSERT INTO Instructors (eid) VALUES (3);
INSERT INTO Instructors (eid) VALUES (4);
INSERT INTO Instructors (eid) VALUES (5);
INSERT INTO Instructors (eid) VALUES (6);
INSERT INTO Instructors (eid) VALUES (7);
INSERT INTO Instructors (eid) VALUES (8);
INSERT INTO Instructors (eid) VALUES (9);
INSERT INTO Instructors (eid) VALUES (10);
INSERT INTO Instructors (eid) VALUES (11);
INSERT INTO Instructors (eid) VALUES (12);
INSERT INTO Instructors (eid) VALUES (13);
INSERT INTO Instructors (eid) VALUES (14);
INSERT INTO Instructors (eid) VALUES (15);
INSERT INTO Instructors (eid) VALUES (16);
INSERT INTO Instructors (eid) VALUES (17);
INSERT INTO Instructors (eid) VALUES (18);
INSERT INTO Instructors (eid) VALUES (19);
INSERT INTO Instructors (eid) VALUES (20);
-- Negative insertions for Instructors

-------- Insert Part_time_instructors

-- Positve insertions for Part_time_instructors
INSERT INTO Part_time_instructors (eid) VALUES (1);
INSERT INTO Part_time_instructors (eid) VALUES (2);
INSERT INTO Part_time_instructors (eid) VALUES (3);
INSERT INTO Part_time_instructors (eid) VALUES (4);
INSERT INTO Part_time_instructors (eid) VALUES (5);
INSERT INTO Part_time_instructors (eid) VALUES (6);
INSERT INTO Part_time_instructors (eid) VALUES (7);
INSERT INTO Part_time_instructors (eid) VALUES (8);
INSERT INTO Part_time_instructors (eid) VALUES (9);
INSERT INTO Part_time_instructors (eid) VALUES (10);

-- Negative insertions for Part_time_instructors

-------- Insert Full_time_instructors

-- Positve insertions for Full_time_instructors
INSERT INTO Full_time_instructors (eid) VALUES (11);
INSERT INTO Full_time_instructors (eid) VALUES (12);
INSERT INTO Full_time_instructors (eid) VALUES (13);
INSERT INTO Full_time_instructors (eid) VALUES (14);
INSERT INTO Full_time_instructors (eid) VALUES (15);
INSERT INTO Full_time_instructors (eid) VALUES (16);
INSERT INTO Full_time_instructors (eid) VALUES (17);
INSERT INTO Full_time_instructors (eid) VALUES (18);
INSERT INTO Full_time_instructors (eid) VALUES (19);
INSERT INTO Full_time_instructors (eid) VALUES (20);

-- Negative insertions for Full_time_instructors

-------- Insert Administrators

-- Positve insertions for Administrators
INSERT INTO Administrators (eid) VALUES (21);
INSERT INTO Administrators (eid) VALUES (22);
INSERT INTO Administrators (eid) VALUES (23);
INSERT INTO Administrators (eid) VALUES (24);
INSERT INTO Administrators (eid) VALUES (25);
INSERT INTO Administrators (eid) VALUES (26);
INSERT INTO Administrators (eid) VALUES (27);
INSERT INTO Administrators (eid) VALUES (28);
INSERT INTO Administrators (eid) VALUES (29);
INSERT INTO Administrators (eid) VALUES (30);

-- Negative insertions for Administrators


-------- Insert Managers

-- Positve insertions for Managers
INSERT INTO Managers (eid) VALUES (31);
INSERT INTO Managers (eid) VALUES (32);
INSERT INTO Managers (eid) VALUES (33);
INSERT INTO Managers (eid) VALUES (34);
INSERT INTO Managers (eid) VALUES (35);
INSERT INTO Managers (eid) VALUES (36);
INSERT INTO Managers (eid) VALUES (37);
INSERT INTO Managers (eid) VALUES (38);
INSERT INTO Managers (eid) VALUES (39);
INSERT INTO Managers (eid) VALUES (40);

-- Negative insertions for Managers



-------- Insert Pay_slips


-- Positve insertions for Pay_slips
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (8, '2020-10-31', 1662.9, 10, NULL);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (9, '2021-01-31', 1585.2, 30, NULL);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (10, '2020-08-31', 12180, 100, NULL);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (19, '2021-03-31', 17949.38, NULL, 31);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (20, '2021-01-31', 10143.3, NULL, 31);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (21, '2020-10-31', 17869.1, NULL, 7);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (22, '2021-01-31', 15782.84, NULL, 31);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (23, '2020-08-31', 5699.07, NULL, 31);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (24, '2020-10-31', 10031.57, NULL, 30);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (25, '2021-02-28', 7027.88, NULL, 27);

-- Negative insertions for Pay_slips
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (100, '2021-01-31', 15782.84, NULL, 31);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (23, '2020-08-31', 5699.07, NULL, 31);
INSERT INTO Pay_slips (eid, payment_date, amount, num_work_hours, num_work_days) VALUES (23, '2020-10-31', 10031.57, NULL, 30);


 --<----------------------- company side ----------------------->

-------- Insert Customers

-- Positve insertions for Customers hierarchy
INSERT INTO Customers (name,phone,email,address) VALUES ('Nell T. Calderon',76044067,'Nunc.lectus@orci.ca','2447 Enim. Avenue');
INSERT INTO Customers (name,phone,email,address) VALUES ('Merritt C. Wagner',61281669,'tristique.senectus.et@luctuslobortisClass.org','P.O. Box 752, 5557 Neque Av.');
INSERT INTO Customers (name,phone,email,address) VALUES ('Adara M. Bailey',89253939,'augue.scelerisque@mauris.net','Ap #329-1731 Et Rd.');
INSERT INTO Customers (name,phone,email,address) VALUES ('Adara M. Bailey',89686053,'a@aliquameuaccumsan.edu','P.O. Box 105, 9504 Tristique St.');
INSERT INTO Customers (name,phone,email,address) VALUES ('Oren C. Byrd',30999101,'mi.felis.adipiscing@Fusce.ca','3840 Mauris Street');
INSERT INTO Customers (name,phone,email,address) VALUES ('Brian Z. Osborn',30999101,'ut.nulla@amalesuadaid.com','241-1798 Fusce Av.');
INSERT INTO Customers (name,phone,email,address) VALUES ('James L. Barrett',1323854,'tempor.arcu@mauriselit.com','P.O. Box 590, 5859 Quam Av.');
INSERT INTO Customers (name,phone,email,address) VALUES ('Abbot C. Woods',93308560,'adipiscing@augueeutellus.com','878-1689 Natoque Rd.');
INSERT INTO Customers (name,phone,email,address) VALUES ('Burton O. Langley',24345387,'Aliquam@ut.ca','878-1689 Natoque Rd.');
INSERT INTO Customers (name,phone,email,address) VALUES ('Dorothy K. Nguyen',22745671,'a@ullamcorper.net','Ap #365-1251 Pede Ave');

-- Negative insertions for Customers hierarchy
INSERT INTO Customers (name,phone,email,address) VALUES ('Conan H. Hewitt',83453879,'lorem@nonarcu.edu','P.O. Box 159, 6870 Fusce Rd.');
INSERT INTO Customers (name,phone,email,address) VALUES ('John Z. Witt',37291142,'blandit.Nam.nulla@nonfeugiat.ca','8822 Magna. Rd.');
INSERT INTO Customers (name,phone,email,address) VALUES ('Cameron T. Castillo',92187324,'lacinia@eget.org','224-9477 Vitae Road');


-------- Insert Rooms

-- Positve insertions for Rooms
INSERT INTO Rooms (location,seating_capacity) VALUES ('#06-013, P.O. Box 919, 1276 Nunc Rd.',151);
INSERT INTO Rooms (location,seating_capacity) VALUES ('P.O. Box 518, 3075 Ipsum. Av.',132);
INSERT INTO Rooms (location,seating_capacity) VALUES ('Ap #219-5134 Consequat Ave',16);
INSERT INTO Rooms (location,seating_capacity) VALUES ('604-1129 Convallis Ave',53);
INSERT INTO Rooms (location,seating_capacity) VALUES ('Ap #221-9496 Cursus Road',119);
INSERT INTO Rooms (location,seating_capacity) VALUES ('2075 Ligula. Rd.',27);
INSERT INTO Rooms (location,seating_capacity) VALUES ('445-4464 Ipsum Av.',55);
INSERT INTO Rooms (location,seating_capacity) VALUES ('P.O. Box 152, 9645 Nec Street',190);
INSERT INTO Rooms (location,seating_capacity) VALUES ('646-2248 Nisi. Av.',99);
INSERT INTO Rooms (location,seating_capacity) VALUES ('Ap #601-7100 Ipsum. St.',41);

-- Negative insertions for Rooms
INSERT INTO Rooms (location,seating_capacity) VALUES ('P.O. Box 242, 3441 Magna Rd.',129);
INSERT INTO Rooms (location,seating_capacity) VALUES ('P.O. Box 656, 6025 Mauris St.',160);
INSERT INTO Rooms (location,seating_capacity) VALUES ('711-8257 Duis Avenue',200);
INSERT INTO Rooms (location,seating_capacity) VALUES (NULL,53);
INSERT INTO Rooms (location,seating_capacity) VALUES ('P.O. Box 718, 3543 Ligula. Rd.',NULL);


-------- Insert Course_packages

-- Positve insertions for Course_packages
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-01-15', 0, '2020-03-06', 'package 1', 402.47);
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-01-19', 1, '2021-03-18', 'package 2', 198.44);
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-03-23', 4, '2021-03-22', 'package 3', 262.46);
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-04-08', 15, '2021-05-03', 'package 4' 485.51);
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-06-03', 16, '2021-03-31', 'package 5' 391.21);
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-05-06', 13, '2020-12-13', 'package 6' 249.76);
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2021-01-30', 7, '2021-12-15', 'package 7' 190.33);
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-05-26', 13, '2021-01-20', 'package 8', 444.77);
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-01-03', 11, '2021-05-20', 'package 9', 296.48);
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-06-02', 3, '2021-05-08', 'package 10', 401.46);

-- Negative insertions for Course_packages
INSERT INTO Course_packages (sale_start_date, num_free_registrations, sale_end_date, name, price) VALUES ('2020-01-03', -1, '2021-05-20', 'Philosophy Package 3', -296.48);


-------- Insert Course_areas

-- Positve insertions for Course_areas
INSERT INTO Course_areas (name, eid) VALUES ('Computer Networking', 31);
INSERT INTO Course_areas (name, eid) VALUES ('Algorithms', 32);
INSERT INTO Course_areas (name, eid) VALUES ('Artificial Intelligence', 33);
INSERT INTO Course_areas (name, eid) VALUES ('Natural Language Processing', 34);
INSERT INTO Course_areas (name, eid) VALUES ('Database Systems', 35);
INSERT INTO Course_areas (name, eid) VALUES ('Software Engineering', 36);
INSERT INTO Course_areas (name, eid) VALUES ('Parallel Computing', 37);
INSERT INTO Course_areas (name, eid) VALUES ('Computer Vision', 38);
INSERT INTO Course_areas (name, eid) VALUES ('Machine Learning', 31);
INSERT INTO Course_areas (name, eid) VALUES ('Programming Languages', 35);

-- Negative insertions for Course_areas
INSERT INTO Course_areas (name, eid) VALUES (NULL, 36);
INSERT INTO Course_areas (name, eid) VALUES ('Computer Graphics', 37);
INSERT INTO Course_areas (name, eid) VALUES ('Computer Graphics', 39);
INSERT INTO Course_areas (name, eid) VALUES ('Robotics', NULL);
INSERT INTO Course_areas (name, eid) VALUES ('Concurrency and Distributed Computing', 50);


-------- Insert Courses

-- Positve insertions for Courses
INSERT INTO Courses (duration, description, title, name) VALUES (65, 'Course named Algorithms 01', 'Algorithms 01', 'Algorithms');
INSERT INTO Courses (duration, description, title, name) VALUES (60, 'Course named Algorithms 02', 'Algorithms 02', 'Algorithms');
INSERT INTO Courses (duration, description, title, name) VALUES (80, 'Course named Artificial Intelligence 01', 'Artificial Intelligence 01', 'Artificial Intelligence');
INSERT INTO Courses (duration, description, title, name) VALUES (75, 'Course named Artificial Intelligence 02', 'Artificial Intelligence 02', 'Artificial Intelligence');
INSERT INTO Courses (duration, description, title, name) VALUES (60, 'Course named Artificial Intelligence 03', 'Artificial Intelligence 03', 'Artificial Intelligence');
INSERT INTO Courses (duration, description, title, name) VALUES (70, 'Course named Software Engineering 01', 'Software Engineering 01', 'Software Engineering');
INSERT INTO Courses (duration, description, title, name) VALUES (65, 'Course named Software Engineering 02', 'Software Engineering 02', 'Software Engineering');
INSERT INTO Courses (duration, description, title, name) VALUES (60, 'Course named Software Engineering 03', 'Software Engineering 03', 'Software Engineering');
INSERT INTO Courses (duration, description, title, name) VALUES (65, 'Course named Machine Learning 01', 'Machine Learning 01', 'Machine Learning');
INSERT INTO Courses (duration, description, title, name) VALUES (70, 'Course named Machine Learning 02', 'Machine Learning 02', 'Machine Learning');

-- Negative insertions for Courses
INSERT INTO Courses (duration, description, title, name) VALUES (70.1, 'Course named Software Engineering 01', 'Software Engineering 01', 'Software Engineering');
INSERT INTO Courses (duration, description, title, name) VALUES (90, 'Course named Software Engineering 03', 'Software Engineering 03', 'Non-Existing Course Area');
INSERT INTO Courses (duration, description, title, name) VALUES (60, 'Course named Machine Learning 01', 'Machine Learning 01', 'Machine Learning');
INSERT INTO Courses (duration, description, title, name) VALUES (60, 'Course named Machine Learning 01', 'Machine Learning 01', 'Machine Learning');


-------- Insert Offerings

-- Positve insertions for Offerings


-- Negative insertions for Offerings

-------- Insert Sessions

-- Positve insertions for Sessions


-- Negative insertions for Sessions

-- <----------------------associations----------------------->


-------- Insert Cancels

-- Positve insertions for Cancels
-- Negative insertions for Cancels


-------- Insert Credit_cards

-- Positve insertions for Credit_cards
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (5207757125861655, 712,'21-12-21', 1676030602899);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (1449389814987739, 448,'21-01-08', 1670121565299);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (4772425519204232, 468,'21-09-28', 1602032836299);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (2238406833054283, 132,'20-12-03', 1678011764099);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (8405238874121091, 906,'21-07-18', 1655120277499);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (5404411412295264, 320,'20-06-22', 1682121904099);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (7268272469910540, 834,'22-02-27', 1681120138899);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (7531491645485563, 258,'20-09-10', 1640120779699);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (5204373474155087, 442,'20-09-09', 1625072041899);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (2065629961409359, 377,'20-05-08', 1623012646899);

-- Negative insertions for Credit_cards
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (NULL, 831,'20-08-29', 1623012623456);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (3551375609223241, 547,1623765436899);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (3551375609223241, 641,'20-08-30', 1623012609865);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (1326261219057330, 368,'21-09-17', NULL);
INSERT INTO Credit_cards (number, CVV, expiry_date, cust_id, from_date) VALUES (9612070681780448, 438,'20-12-22', 1633417626899);


-------- Insert Buys

-- Positve insertions for Buys
-- Negative insertions for Buys


-------- Insert Registers

-- Positve insertions for Registers
-- Negative insertions for Registers


-------- Insert Specializes

-- Positve insertions for Specializes
-- Negative insertions for Specializes



-------- Insert Redeems

-- Positve insertions for Redeems
-- Negative insertions for Redeems