/******************************************************************************/
/*									                                                        	*/
/*					                                    */
/*	Kroenke, Auer, Vandeberg, and Yoder 				*/
/*	Database Concepts (8th Edition) Chapters 06, 07, 08		*/
/*										                                                        */
/*	The Marcia's Dry Cleaing (MDC) Database - Insert Data
*/
/*							                                                              */
/*	These are the Oracle Express 11gR2 SQL code solutions	                    */
/*								                                                            */
/******************************************************************************/

INSERT INTO CUSTOMER VALUES(
	seqCID.NextVal, 'Nikki', 'Kaccaton', '723-543-1233',
	'Nikki.Kaccaton@somewhere.com');
INSERT INTO CUSTOMER VALUES(
	seqCID.NextVal, 'Brenda', 'Catnazaro', '723-543-2344',
	'Brenda.Catnazaro@somewhere.com');
INSERT INTO CUSTOMER VALUES(
	seqCID.NextVal, 'Bruce', 'LeCat', '723-543-3455',
	'Bruce.LeCat@somewhere.com');
INSERT INTO CUSTOMER VALUES(
	seqCID.NextVal, 'Betsy', 'Miller', '723-654-3211',
	'Betsy.Miller@somewhere.com');
INSERT INTO CUSTOMER VALUES(
	seqCID.NextVal, 'George', 'Miller', '723-654-4322',
	'George.Miller@somewhere.com');
INSERT INTO CUSTOMER VALUES(
	seqCID.NextVal, 'Kathy', 'Miller', '723-514-9877',
	'Kathy.Miller@somewhere.com');
INSERT INTO CUSTOMER VALUES(
	seqCID.NextVal, 'Betsy', 'Miller', '723-514-8766',
	'Betsy.Miller@elsewhere.com');
  
COMMIT;

INSERT INTO SERVICE VALUES(10, 'Men''s Shirt', 1.50);
INSERT INTO SERVICE VALUES(11, 'Dress Shirt', 2.50);
INSERT INTO SERVICE VALUES(15, 'Women''s Shirt', 1.50);
INSERT INTO SERVICE VALUES(16, 'Blouse', 3.50);
INSERT INTO SERVICE VALUES(20, 'Slacks–Men''s', 5.00);
INSERT INTO SERVICE VALUES(25, 'Slacks–Women''s', 6.00);
INSERT INTO SERVICE VALUES(30, 'Skirt', 5.00);
INSERT INTO SERVICE VALUES(31, 'Dress Skirt', 6.00);
INSERT INTO SERVICE VALUES(40, 'Suit–Men''s', 9.00);
INSERT INTO SERVICE VALUES(45, 'Suit–Women''s', 8.50);
INSERT INTO SERVICE VALUES(50, 'Tuxedo', 10.00);
INSERT INTO SERVICE VALUES(60, 'Formal Gown', 10.00);

COMMIT;

INSERT INTO INVOICE VALUES(
		2017001, 100,
		TO_DATE('10/04/17', 'MM/DD/YY'),
		TO_DATE('10/06/17', 'MM/DD/YY'),
		158.50, 12.52, 171.02);
INSERT INTO INVOICE VALUES(
		2017002, 105,
		TO_DATE('10/04/17', 'MM/DD/YY'),
		TO_DATE('10/06/17', 'MM/DD/YY'),
		25.00, 1.98, 26.98);
INSERT INTO INVOICE VALUES(
		2017003, 100,
		TO_DATE('10/06/17', 'MM/DD/YY'),
		TO_DATE('10/08/17', 'MM/DD/YY'),
		49.00, 3.87, 52.87);
INSERT INTO INVOICE VALUES(
		2017004, 115,
		TO_DATE('10/06/17', 'MM/DD/YY'),
		TO_DATE('10/08/17', 'MM/DD/YY'),
		17.50, 1.38, 18.88);
INSERT INTO INVOICE VALUES(
		2017005, 125,
		TO_DATE('10/07/17', 'MM/DD/YY'),
		TO_DATE('10/11/17', 'MM/DD/YY'),
		12.00, 0.95, 12.95);
INSERT INTO INVOICE VALUES(
		2017006, 110,
		TO_DATE('10/11/17', 'MM/DD/YY'),
		TO_DATE('10/13/17', 'MM/DD/YY'),
		152.50, 12.05, 164.55);
INSERT INTO INVOICE VALUES(
		2017007, 110,
		TO_DATE('10/11/17', 'MM/DD/YY'),
		TO_DATE('10/13/17', 'MM/DD/YY'),
		7.00, 0.55, 7.55);
INSERT INTO INVOICE VALUES(
		2017008, 130,
		TO_DATE('10/12/17', 'MM/DD/YY'),
		TO_DATE('10/14/17', 'MM/DD/YY'),
		140.50, 11.10, 151.60);
INSERT INTO INVOICE VALUES(
		2017009, 120,
		TO_DATE('10/12/17', 'MM/DD/YY'),
		TO_DATE('10/14/17', 'MM/DD/YY'),
		27.00, 2.13, 29.13);
    
COMMIT;

INSERT INTO INVOICE_ITEM VALUES(2017001, 1, 16, 2, 3.50, 7.00);
INSERT INTO INVOICE_ITEM VALUES(2017001, 2, 11, 5, 2.50, 12.50);
INSERT INTO INVOICE_ITEM VALUES(2017001, 3, 50, 2, 10.00, 20.00);
INSERT INTO INVOICE_ITEM VALUES(2017001, 4, 20, 10, 5.00, 50.00);
INSERT INTO INVOICE_ITEM VALUES(2017001, 5, 25, 10, 6.00, 60.00);
INSERT INTO INVOICE_ITEM VALUES(2017001, 6, 40, 1, 9.00, 9.00);
INSERT INTO INVOICE_ITEM VALUES(2017002, 1, 11, 10, 2.50, 25.00);
INSERT INTO INVOICE_ITEM VALUES(2017003, 1, 20, 5, 5.00, 25.00);
INSERT INTO INVOICE_ITEM VALUES(2017003, 2, 25, 4, 6.00, 24.00);
INSERT INTO INVOICE_ITEM VALUES(2017004, 1, 11, 7, 2.50, 17.50);
INSERT INTO INVOICE_ITEM VALUES(2017005, 1, 16, 2, 3.50, 7.00);
INSERT INTO INVOICE_ITEM VALUES(2017005, 2, 11, 2, 2.50, 5.00);
INSERT INTO INVOICE_ITEM VALUES(2017006, 1, 16, 5, 3.50, 17.50);
INSERT INTO INVOICE_ITEM VALUES(2017006, 2, 11, 10, 2.50, 25.00);
INSERT INTO INVOICE_ITEM VALUES(2017006, 3, 20, 10, 5.00, 50.00);
INSERT INTO INVOICE_ITEM VALUES(2017006, 4, 25, 10, 6.00, 60.00);
INSERT INTO INVOICE_ITEM VALUES(2017007, 1, 16, 2, 3.50, 7.00);
INSERT INTO INVOICE_ITEM VALUES(2017008, 1, 16, 3, 3.50, 10.50);
INSERT INTO INVOICE_ITEM VALUES(2017008, 2, 11, 12, 2.50, 30.00);
INSERT INTO INVOICE_ITEM VALUES(2017008, 3, 20, 8, 5.00, 40.00);
INSERT INTO INVOICE_ITEM VALUES(2017008, 4, 25, 10, 6.00, 60.00);
INSERT INTO INVOICE_ITEM VALUES(2017009, 1, 40, 3, 9.00, 27.00);

COMMIT;











