Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Customer Table
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Carter', 'Steven', '235 Shanendoa Drive Lafayette IN 47905',
- '765-366-7485', 'Scarter235@netscape.net');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Johnson', 'keven', '4777 First Street Kansas City Kansas 67473',
- '848-938-7241', 'Babyboy3@aol.com');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('McKinny', 'Jennifer', '4839 Back Ave Jermin PA 18736',
- '894-923-9891', 'Jen238@hotmail.com');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Smith', 'Zachary', '148 Cramer Street Seattle WA 93876',
- '498-473-0384', 'zachman@hotmail.com');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Underwood', 'Mary', '12888 Main Street Brooklyn NY 08648',
- '477-958-3488', 'marywood@aol.com');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Lambuth', 'Kim', '687 Logan Court Miami FL 38848',
- '680-446-6713', 'lambgirl@aol.com');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Alison', 'Robbert', '15 Cherrycreek Rd Newport RI 48372',
- '247-686-3929', 'lambgirl@aol.com');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Martin', 'Judy', '4i34 RR 382 Jupitor OK 43939',
- '972-345-3789', 'JMartin@MSN.com');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Thomas', 'Sally', '3132 James Street Marion MD 42984',
- '342-246-7403', 'Catsitter10@aol.com');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Bartin', 'Berry', '576 Blackhawk Place Jeffersonville IW 39238',
- '746-192-5367', 'Baker@netscape.net');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Krammer', 'John', '332 Front Street Hangoverville GA 48573',
- '883-943-9846', 'Baker@netscape.net');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('William', 'Russell', '602 Feet Street Smelltown KS 83746',
- '343-804-8746', 'Badboy@hotmail.com');
- INSERT INTO Customer (LastName, FirstName, Address, Phone, Email)
- VALUES('Edwards', 'Carrie', '7832 Blackman Street Dallas TX 56473',
- '827-580-7421', 'downtowner@hotmail.com');
- -- Employee Table
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Williams', 'Willie', '3843 Happy Ave, Chilitown TX', '800-555-5932',
- 1, '1997-03-13', 42, 'wackywillie@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Sven', 'Harper', '54 Lord Lane, Ravenholm MI', '907-871-0602',
- 3, '1997-06-17', 25, 'SuperSven@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Grahm', 'Matthew', '583 Jackton ave, Yaklaba MD', '607-426-8168',
- 2, '1998-01-11', 30, 'GrahmMat@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Lambert', 'Daniel', '4358 Pine Tree Lane Silver Spring, MD', '240-417-4843',
- 2, '1998-03-31', 53, 'DannieLamb@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Gatlin', 'Lucille', '254 Roguski Road Marksville, LA', '318-240-3030',
- 2, '1998-05-03', 32, 'LuckyLucille@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Cummings', 'Ralph', '4663 Backwordsville, GA 19283', '695-555-9275',
- 4, '1999-11-09', 42, 'Bumperpool@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Bannor', 'David', '8675 Comic Lane Hulkville, GA 19283', '658-548-5848',
- 2, '2001-05-29', 37, 'thehulk@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Wayne', 'Bruce', '8675 Cave Road Gathom, NY 27374', '986-836-4809',
- 3, '2003-09-19', 27, 'batman@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Henderson', 'Katherine', '2656 Pennsylvania Avenue Edison, NJ 08817', '732-393-6564',
- 5, '2003-12-19', 40, 'Katherine@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Partin', 'Clement', '2804 Wetzel Lane Traverse City, MI 49686', '231-360-1811',
- 4, '2004-03-03', 26, 'Clementine@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Musselman', 'Lily', ' 1128 Short Street Austin, TX 78741 ', '512-874-8677',
- 5, '2005-07-13', 23, 'Lilypadd@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Land', 'Angela', '4772 Richards Avenue Los Banos, CA 93635', '209-826-8641',
- 5, '2007-07-13', 21, 'AngelLand@herbiesballonland.com');
- INSERT INTO Employee(LastName, FirstName, Address, Phone, POSITION_ID, HireDate, Age, Email)
- VALUES('Jones', 'Katherine', '3409 Norma Lane Shreveport, LA 71101', '318-588-7908',
- 2, '2009-07-13', 23, 'KatieJones@herbiesballonland.com');
- -- Product Table
- INSERT INTO Product (Name, Price) VALUES('260 Animal Balloon', 7.35);
- INSERT INTO Product (Name, Price) VALUES('160 Animal Balloon' , 9.35);
- INSERT INTO Product (Name, Price) VALUES('Dart Balloon', 7.35);
- INSERT INTO Product (Name, Price) VALUES('6in. round Balloon' , 11.95);
- INSERT INTO Product (Name, Price) VALUES('9in. round Balloon' , 13.95);
- INSERT INTO Product (Name, Price) VALUES('13in. round Balloon' , 16.95);
- INSERT INTO Product (Name, Price) VALUES('9in. square Balloon' , 11.95);
- INSERT INTO Product (Name, Price) VALUES('6in. square Balloon' , 8.95);
- INSERT INTO Product (Name, Price) VALUES('6in. Mylar Balloon' , 12.95);
- INSERT INTO Product (Name, Price) VALUES('9in. Mylar Balloon' , 15.95);
- INSERT INTO Product (Name, Price) VALUES('14in. Mylar Balloon', 17.95);
- INSERT INTO Product (Name, Price) VALUES('6in. Heart Balloon', 5.95);
- INSERT INTO Product (Name, Price) VALUES('9in. Heart Balloon', 7.95);
- -- Transaction Table
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES(1, 10, '2010-10-05');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 3, 6, '2010-09-14');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 7, 13, '2010-04-17');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 2, 4, '2010-01-23');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 3, 8, '2010-01-23');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 9, 4, '2010-07-19');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 12, 11, '2010-03-04');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 8, 7, '2010-06-09');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 5, 7, '2010-12-10');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 10, 7, '2010-11-11');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES( 4, 9, '2010-07-16');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES(12, 3, '2010-02-12');
- INSERT INTO Transaction (EMPLOYEE_ID, CUSTOMER_ID, TransactionDate) VALUES(8, 1, '2010-05-14');
- -- Position Table Entries
- INSERT INTO Position (Title, PayRate) VALUES('CEO', 25.00);
- INSERT INTO Position (Title, PayRate) VALUES('Phone Operator', 10.25);
- INSERT INTO Position (Title, PayRate) VALUES('Warehouse Manager', 15.75);
- INSERT INTO Position (Title, PayRate) VALUES('Office Manager', 15.25);
- INSERT INTO Position (Title, PayRate) VALUES('Order Picker', 8.50);
- -- LineItem Table Entries
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(3, 3 * (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 3), 1, 3);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(2, 2 * (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 5), 1, 5);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(1, 1* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 7), 2, 7);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(10, 10* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 4), 3, 4);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(4, 4* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 5), 3, 5);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(100, 100* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 2), 4, 2);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(1, 1* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 3), 5, 3);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(99, 99* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 4), 6, 4);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(200, 200* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 6), 7, 6);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(30, 30* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 12), 8, 12);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(10, 10* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 4), 9, 4);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(1, 1* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 4), 10, 4);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(10, 10* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 10), 11, 10);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(10, 10* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 5), 11, 5);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(100, 100* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 4), 12, 4);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(50, 50* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 5), 12, 5);
- INSERT INTO LineItem(Quantity, Cost, ORDER_ID, PRODUCT_ID)
- VALUES(10000, 10000* (SELECT Product.Price FROM Product
- WHERE Product.PRODUCT_ID = 5), 13, 5);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement