text: 
  
  ---------------------------------------------------------------------------INSERT SQL COMMANDS---------------------------------------------------------------------------
  
  
  
  ------------------------------------------------------------Customer------------------------------------------------------------
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10001, 'Aristotle Bradley', 'Prime','10', '842-7950 Egestas. Av.', 'Boston', 'MA', 'USA', 171781, 588281779);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10002, 'Cullen Guy', 'Prime','10', 'P.O. Box 602 1772 Ligula. Avenue', 'Los Angeles', 'CA','USA', 989321, 164969646);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10003, 'Drake Swanson', 'Prime', '10','P.O. Box 948 8527 Sit Road', 'Austin', 'TX', 'USA', 629186, 594166815);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10004, 'Jerome Jackson', 'Prime', '10','Ap 561-6041 Ac Ave', 'Los Angeles', 'CA', 'USA', 897781, 884139197);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10005, 'Geoffrey Sutton', 'Prime','10', '6276 In Av.', 'Austin', 'TX', 'USA', 665513, 946674954);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10006, 'Omar Roy', 'Prime', '10','6469 Arcu Road', 'Miami', 'FL', 'USA', 735214, 947788720);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10007, 'Acton Marks', 'Prime','10', '657 At Road', 'NewYork', 'NY', 'USA', 585316, 695550993);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10008, 'Matthew Vaughan', 'NonPrime', '10','P.O. Box 231,2329 Aliquet Street', 'SanFrancisco', 'CA', 'USA', 780755, 666430511);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10009, 'Davis Tillman', 'NonPrime', '10','Ap 868-7746 Non Avenue', 'SanFrancisco', 'CA', 'USA', 604114, 583699614);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10010, 'Arsenio Atkinson', 'NonPrime','10', '7192 Venenatis Ave', 'Boston', 'MA', 'USA', 471293, 917651735);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10011, 'Elijah Boone', 'NonPrime', '10','P.O. Box 511, 9917 Nam Avenue', 'Miami', 'FL', 'USA', 290754, 187390623);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10012, 'Leonard Heath', 'NonPrime','10', '5503 Natoque Av.', 'Chicago', 'IL', 'USA', 772320, 431505223);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10013, 'Jared Moran', 'NonPrime','10', 'P.O. Box 216, 6898 Risus Ave', 'Los Angeles', 'CA', 'USA', 561410, 180492958);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10014, 'Graham Hays', 'NonPrime','10', 'Ap 644-4717 Ante Av.', 'Chicago', 'IL', 'USA', 297315, 150305466);
  
  
  INSERT INTO Customer(Cust_ID, Cust_Name, Cust_Type, Cust_DiscountPercentage, Cust_Addr, Cust_City, Cust_State, Cust_Country, Cust_ZipCode, Cust_PhoneNo)
  VALUES(10015, 'Armando Walker', 'NonPrime','10', '2241 Ut,Av.', 'NewYork', 'NY', 'USA', 399013, 115449573);
  
  
  ------------------------------------------------------------Department------------------------------------------------------------
  
  
  INSERT INTO Department(Dept_ID, Dept_Name, Dept_Type, Dept_Descr)
  VALUES(111, 'Laptops', 'Computer', 'You can find different laptop models here');
  
  
  INSERT INTO Department(Dept_ID, Dept_Name, Dept_Type, Dept_Descr)
  VALUES(222, 'Headphones', 'Music', 'You can find different Headphones here');
  
  
  INSERT INTO Department(Dept_ID, Dept_Name, Dept_Type, Dept_Descr)
  VALUES(333, 'Smartphones', 'Mobile', 'You can find different Smartphones here');
  
  
  INSERT INTO Department(Dept_ID, Dept_Name, Dept_Type, Dept_Descr)
  VALUES(444, 'TV', 'Electronics', 'You can find different TV models here');
  
  
  INSERT INTO Department(Dept_ID, Dept_Name, Dept_Type, Dept_Descr)
  VALUES(555, 'Accessories', 'Add-Ons', 'You can find different computer accessories here');
  
  -------------------------------------------------------------Employee-------------------------------------------------------------
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7001, 111, 'Luke', 'Burt', 'Mid Level', '06/21/1993', '03/26/2015', 'P.O. Box 599, 9899 Ligula. Avenue', 'Los Angeles', 'CA', 'USA', 784458, 610196456, 284071, 'Active', 7013, 75000);
  
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7002, 222, 'Melvin', 'Valentine', 'Senior', '11/06/1982', '02/12/2002', '3888 Lacus. Rd','Austin', 'TX', 'USA', '413680', 327598842, 881915, 'Active', 7014, 100000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7003, 333, 'Avram', 'Lott', 'Mid Level', '01/25/1992', '04/26/2016', 'Ap 849-3095 At Ave', 'Miami', 'FL', 'USA', 145630, 782314069, 555707, 'Active', 7015, 75000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7004, 444, 'Kato', 'Luna', 'Senior', '08/06/1977', '10/31/1998', '844 Ac Rd.', 'NewYork', 'NY', 'USA', '602604', 381237156, 138453, 'Active', 7016, 100000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7005, 555, 'Alan', 'Fowler', 'Junior', '10/17/1995', '11/14/2017', '1810 Laoreet Street', 'Los Angeles', 'CA', 'USA', '238087', 657730285, 662867, 'Active', 7017, 50000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7006, 333, 'Nasim', 'Frye', 'Mid Level', '04/27/1991', '05/18/2013', 'P.O. Box 583, 9275 Molestie. St.', 'Austin', 'TX', 'USA', 448889, 557741354, 115131, 'Active', 7018, 75000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7007, 111, 'Curran', 'Wallace', 'Senior', '01/11/1981', '05/12/2005', '7118 Orci. Rd.', 'Miami', 'FL', 'USA', '166952', 544208440, 460064, 'Active', 7013, 100000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7008, 222, 'Zena', 'Haley', 'Mid Level', '06/15/1990', '10/22/2014', 'Ap 530-5082 Feugiat St.', 'NewYork', 'NY', 'USA', '197024', 850418255, 882389, 'Active', 7014, 75000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7009, 333, 'Thomas', 'Walton', 'Mid Level', '08/10/1992', '11/30/2015', 'P.O. Box 550, 6960 Mauris Av.', 'Los Angeles', 'CA', 'USA', 288534, 435750241, 627913, 'Active', 7015, 75000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7010, 444, 'Lillith', 'Santos', 'Junior', '03/04/1996', '01/16/2018', '409-6521 Sed Rd.', 'Austin', 'TX', 'USA', '584124', 168246023, 786865, 'Active', 7016, 50000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7011, 555, 'Brendan', 'Miranda', 'Junior', '08/02/1997', '06/29/2019', 'Ap 208-4283 In Rd.', 'Miami', 'FL', 'USA', '926964', 965739981, 605378, 'Active', 7017, 50000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7012, 111, 'Latifah', 'Ward', 'Mid Level', '10/03/1993', '12/08/2015', '171-1104 Nunc St.', 'NewYork', 'NY', 'USA', '739270', 442694971, 296896, 'Active', 7018, 75000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7013, 222, 'Inez', 'Berg', 'Manager', '09/26/1990', '07/22/1992', '1777 Aenean Ave', 'Los Angeles', 'CA', 'USA', '441327', 100798294, 543362, 'Active', '', 150000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7014, 333, 'Germaine', 'Zamora', 'Manager', '06/22/1984', '02/22/1999', '7482 Erat Av.', 'Austin', 'TX', 'USA', '231035', 107714836, 947190, 'Active', '', 150000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7015, 444, 'Macey', 'Gross', 'Manager', '05/06/1983', '11/22/2012', 'P.O. Box 300, 7783 Elit Av.', 'Miami', 'FL', 'USA', 341519, 479870132, 515694, 'Active', '', 150000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7016, 333, 'Victor', 'Barber', 'Manager', '07/18/1950', '03/01/1990', '4530 Adipiscing St.', 'NewYork', 'NY', 'USA', 333029, 583574426, 227513, 'Active', '', 150000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7017, 444, 'Amber', 'Francis', 'Manager', '11/27/1970', '02/22/2009', 'P.O. Box 277, 9403 Integer Avenue', 'Los Angeles', 'CA', 'USA', 417072, 901895779, 668453, 'Active', '', 150000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7018, 555, 'Oscar', 'Hayes', 'Manager', '11/09/1984', '12/16/1995', 'P.O. Box 804, 7339 Aliquam Street', 'Austin', 'TX', 'USA', 587881, 606462075, 713420, 'Active', '', 150000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7019, 111, 'Darryl', 'Moore', 'Manager', '05/02/1963', '10/26/2503', '1455 Eu Avenue', 'Miami', 'FL', 'USA', '300152', 400160210, 308117, 'Inactive', '', 150000);
  
  
  INSERT INTO Employee(Emp_ID, Dept_ID, Emp_FName, Emp_LName, Emp_Type, Emp_DOB, Emp_DOH, Emp_Addr, Emp_City, Emp_State, Emp_Country, Emp_ZipCode, Emp_PhoneNo, Emp_SSN, Emp_Status, Emp_ManID, Emp_Salary)
  VALUES(7020, 444, 'Shelby', 'Savage', 'Mid Level', '07/19/1991', '01/25/2015', '7997 Enim, Av.', 'NewYork', 'NY', 'USA', 829875, 834896543, 729536, 'Inactive', '', 75000);
  
  
  
  --------------------------------------------------------------Order--------------------------------------------------------------
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000001, 10001, 7001, 3);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000101, 10002, 7002, 2);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000201, 10003, 7003, 20);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000301, 10004, 7004, 2);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000401, 10005, 7005, 1);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000501, 10006, 7006, 15);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000601, 10007, 7007, 6);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000701, 10008, 7008, 7);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000801, 10009, 7009, 1);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9000901, 10010, 7010, 28);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001001, 10011, 7011, 8);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001101, 10012, 7012, 2);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001201, 10001, 7001, 50);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001301, 10002, 7002, 25);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001401, 10003, 7003, 9);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001501, 10001, 7001, 7);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001601, 10002, 7002, 12);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001701, 10003, 7003, 52);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001801, 10004, 7004, 30);
  
  
  INSERT INTO [Order](Order_ID, Cust_ID, Emp_ID, Qty)
  VALUES(9001901, 10005, 7005, 45);
  
  -------------------------------------------------------------Product--------------------------------------------------------------
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5000001, 111, 'HP Spectre Laptop', 'Laptops', 'Buy this amazing laptop on sale', 1300);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5001001, 222, 'SkullCandy Headphones', 'Headphones', 'Bass Boosted Bonus', 100);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5002001, 333, 'Redmi Note 8', 'Mobile', 'Discounted Price. Grab Soon', 150);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5003001, 444, 'Sony Bravia', 'TV', 'Feel the moment', 499);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5004001, 555, 'ASC Mouse', 'Accessories', 'Smooth Handling', 10);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5005001, 444, 'LG 4K', 'TV', 'Relive', 699);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5006001, 111, 'Macbook Pro 2018', 'Laptops', 'Buy this amazing laptop on sale', 1500);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5007001, 222, 'Bose Headphones', 'Headphones', 'Bass Boosted Bonus', 150);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5008001, 333, 'Samsung S10', 'Mobile', 'Display is everything', 999);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5009001, 444, 'Videocon V12 UHD TV', 'TV', 'Sale Price on product', 299);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5010001, 555, 'USB A-type Cable', 'Accessories', 'A-Type', 7);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5011001, 222, 'Apple Airpods', 'Headphones', 'Noise Cancellation', 150);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5012001, 333, 'iPhone 11', 'Mobile', 'Premium', 1999);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5013001, 444, 'TLC FHD TV', 'TV', 'Cheap TV', 199);
  
  
  INSERT INTO Product(Prod_ID, Dept_ID, Product_Name, Product_Type, Product_Descr, Unit_Price)
  VALUES(5014001, 555, 'Screen Guard', 'Accessories', 'Crack Proof', 15);
  
  
  -----------------------------------------------------------Order Details-----------------------------------------------------------
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000001, 5000001, '01/13/2020', '01/18/2020', 90000015000001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000101, 5001001, '06/06/2019', '06/11/2019', 90001015001001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000201, 5002001, '11/22/2019', '11/27/2019', 90002015002001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000301, 5003001, '04/13/2019', '04/18/2019', 90003015003001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000401, 5004001, '06/09/2019', '06/14/2019', 90004015004001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000501, 5005001, '09/03/2019', '09/08/2019', 90005015005001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000601, 5006001, '05/03/2019', '05/08/2019', 90006015006001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000701, 5007001, '04/23/2019', '04/28/2019', 90007015007001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000801, 5008001, '06/18/2019', '06/23/2019', 90008015008001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9000901, 5009001, '10/27/2019', '11/06/2019', 90009015009001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001001, 5010001, '02/04/2020', '02/14/2020', 90010015010001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001101, 5011001, '06/13/2019', '06/23/2019', 90011015011001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001201, 5012001, '06/29/2019', '07/04/2019', 90012015012001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001301, 5013001, '09/09/2019', '09/14/2019', 90013015013001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001401, 5000001, '11/22/2019', '11/27/2019', 90014015000001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001501, 5000001, '07/12/2019', '07/17/2019', 90015015000001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001601, 5000001, '08/27/2019', '09/01/2019', 90016015000001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001701, 5000001, '05/25/2019', '05/30/2019', 90017015000001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001801, 5001001, '03/13/2020', '03/18/2020', 90018015001001);
  
  
  INSERT INTO Order_Details(Order_ID, Prod_ID, Order_Date, Delivery_Date, Invoice_ID)
  VALUES(9001901, 5002001, '01/17/2020', '01/22/2020', 90019015002001);
  
  ------------------------------------------------------------Warehouse------------------------------------------------------------
  
  
  INSERT INTO Warehouse(WH_ID, WH_Name, WH_Loc, WH_Capacity)
  VALUES(10, 'BO15', 'Boston', '10000 units');
  
  
  INSERT INTO Warehouse(WH_ID, WH_Name, WH_Loc, WH_Capacity)
  VALUES(11, 'LA26', 'Los Angeles', '25000 units');
  
  
  INSERT INTO Warehouse(WH_ID, WH_Name, WH_Loc, WH_Capacity)
  VALUES(12, 'DA19', 'Dallas', '27905 units');
  
  
  INSERT INTO Warehouse(WH_ID, WH_Name, WH_Loc, WH_Capacity)
  VALUES(13, 'NY75', 'New York', '35000 units');
  
  
  INSERT INTO Warehouse(WH_ID, WH_Name, WH_Loc, WH_Capacity)
  VALUES(14, 'CO55', 'Colorado', '44075 units');
  
  
  
  ------------------------------------------------------------Carriers------------------------------------------------------------
  
  
  INSERT INTO Carriers(Carrier_ID, Carrier_Company, Carrier_Type, Carrier_Contact, Carrier_PhoneNo)
  VALUES(100, 'UPS', 'Air', 'Tyler Forbes', 626880514);
  
  
  INSERT INTO Carriers(Carrier_ID, Carrier_Company, Carrier_Type, Carrier_Contact, Carrier_PhoneNo)
  VALUES(101, 'FedEx Corp', 'Ground', 'Coby Tyler', 613388558);
  
  
  INSERT INTO Carriers(Carrier_ID, Carrier_Company, Carrier_Type, Carrier_Contact, Carrier_PhoneNo)
  VALUES(102, 'DHL Express', 'Air', 'Graham Petty', 692341775);
  
  
  INSERT INTO Carriers(Carrier_ID, Carrier_Company, Carrier_Type, Carrier_Contact, Carrier_PhoneNo)
  VALUES(103, 'TNT Express', 'Ground', 'Cadman Morris', 775807641);
  
  
  INSERT INTO Carriers(Carrier_ID, Carrier_Company, Carrier_Type, Carrier_Contact, Carrier_PhoneNo)
  VALUES(104, 'Blue Dart', 'Air', 'Steel Douglas', 976447917);
  
  
  ------------------------------------------------------------Supplier------------------------------------------------------------
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(500, 'Alvin Bender', 'Samsung', 'Retail', 'Apt604-3722 Nullam St.', 'Newark', 'DE', 'United States', 51272, 347255775);
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(510, 'Ezekiel Mercer', 'Apple', 'Retail', 'Apt946-3082 Imperdiet Avenue', 'Newark', 'DE', 'United States', 50552, 223160442);
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(520, 'Melvin Norman', 'LG', 'Wholesale', 'Apt632-3496 Imperdiet Av.', 'Baton Rouge', 'LA', 'United States', 85298, 216153463);
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(530, 'Adrian Robinson', 'Panasonic', 'Retail', 'Apt135-2407 Tempor Road', 'Allentown', 'PA', 'United States', 49859, 174365277);
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(540, 'Marsden Peck', 'HP', 'Wholesale', '7664 Enim Road', 'Essex', 'VT', 'United States', 49572, 833044011);
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(550, 'Orson Vinson', 'Lenovo', 'Wholesale', 'Apt454-1370 Gravida Avenue', 'Evansville', 'IN', 'United States', 37995, 452237596);
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(560, 'Elmo Carlson', 'Skull Candy', 'Retail', '5065 Mi Av.', 'Newark', 'DE', 'United States', 65307, 859955791);
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(570, 'Hiram Ramirez', 'Bose', 'Retail', 'Apt414-7751 Dolor Avenue', 'Lakewood', 'CO', 'United States', 17380, 692341775);
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(580, 'Thane Taylor', 'Sony', 'Wholesale', '864-4097 Nam Rd.', 'Allentown', 'PA', 'United States', 74050, 775807641);
  
  
  INSERT INTO Supplier(Supp_ID, Supp_Contact, Supp_Company, Supp_Type, Supp_Addr, Supp_City, Supp_State, Supp_Country, Supp_ZipCode, Supp_PhoneNo)
  VALUES(590, 'Nicholas Tillman', 'Asus', 'Wholesale', '598-8816 Vel St.', 'Fort Worth', 'TX', 'United States', 81289, 976447917);
  
  
  -------------------------------------------------------------Shipment-------------------------------------------------------------
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(200001, 100, 10, 500, 'Delivered', 3, '01/16/2020', 90000015000001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(201001, 101, 11, 510, 'Shipped', 2, '06/09/2019', 90001015001001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(202001, 102, 12, 520, 'Ordered', 20, '11/25/2019', 90002015002001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(203001, 103, 13, 530, 'Delivered', 2, '04/16/2019', 90003015003001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(204001, 104, 14, 540, 'Shipped', 1, '06/12/2019', 90004015004001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(205001, 100, 10, 550, 'Ordered', 15, '09/06/2019', 90005015005001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(206001, 101, 11, 560, 'Delivered', 6, '05/06/2019', 90006015006001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(207001, 102, 12, 570, 'Shipped', 7, '04/26/2019', 90007015007001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(208001, 103, 13, 580, 'Ordered', 1, '06/21/2019', 90008015008001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(209001, 104, 14, 590, 'Delivered', 28, '10/30/2019', 90009015009001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(210001, 100, 10, 500, 'Shipped', 8, '02/07/2020', 90010015010001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(211001, 101, 11, 510, 'Ordered', 2, '06/16/2019', 90011015011001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(212001, 102, 12, 520, 'Delivered', 50, '07/02/2019', 90012015012001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(213001, 103, 13, 530, 'Shipped', 25, '09/12/2019', 90013015013001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(214001, 104, 14, 540, 'Ordered', 9, '11/25/2019', 90014015000001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(215001, 100, 10, 550, 'Delivered', 7, '07/15/2019', 90015015000001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(216001, 101, 11, 560, 'Shipped', 12, '08/30/2019', 90016015000001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(217001, 102, 12, 570, 'Ordered', 52, '05/28/2019', 90017015000001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(218001, 103, 13, 580, 'Delivered', 30, '03/16/2020', 90018015001001);
  
  
  INSERT INTO Shipment(Ship_ID, Carrier_ID, WH_ID, Supp_ID, Ship_Status, Ship_Qty, Supp_Date, Invoice_ID)
  VALUES(219001, 104, 14, 590, 'Shipped', 45, '01/20/2020', 90019015002001);
  
  
  
  --------------------------------------------------------------------------------THE END--------------------------------------------------------------------------------
  
  
  
  