/********************************************************************************/
/*																				*/
/*	Kroenke, Auer, Vandenberg, and Yoder 					*/
/*	Database Concepts (8th Edition) Chapter 03 	       		*/
/*																				*/
/*  Garden Glory Database Data													*/
/*																				*/
/*	These are the Oracle Express 11GR2 SQL code solutions				*/
/*																				*/
/********************************************************************************/

/*****   OWNER DATA   ***********************************************************/

INSERT INTO OWNER VALUES(seqOID.nextVal,
	'Mary Jones', 'Mary.Jones@somewhere.com', 'Individual');
INSERT INTO OWNER VALUES(seqOID.nextVal,
	'DT Enterprises', 'DTE@dte.com', 'Corporation');
INSERT INTO OWNER VALUES(seqOID.nextVal,
	'Sam Douglas', 'Sam.Douglas@somewhere.com', 'Individual');
INSERT INTO OWNER VALUES(seqOID.nextVal,
	'UNY Enterprises', 'UNYE@unye.com', 'Corporation');
INSERT INTO OWNER VALUES(seqOID.nextVal,
	'Doug Samuels', 'Doug.Samuels@somewhere.com', 'Individual');

-- SELECT * FROM OWNER;

/*****   PROPERTY   *************************************************************/

INSERT INTO OWNED_PROPERTY VALUES(seqOPID.nextVal,
	'Eastlake Building', 'Office', '123 Eastlake', 'Seattle', 'WA', '98119', 2);
INSERT INTO OWNED_PROPERTY VALUES(seqOPID.nextVal,
	'Elm St Apts', 'Apartments', '4 East Elm', 'Lynwood', 'WA', '98223', 1);
INSERT INTO OWNED_PROPERTY VALUES(seqOPID.nextVal,
	'Jefferson Hill', 'Office', '42 West 7th St', 'Bellevue', 'WA', '98007', 2);
INSERT INTO OWNED_PROPERTY VALUES(seqOPID.nextVal,
	'Lake View Apts', 'Apartments', '1265 32nd Avenue', 'Redmond', 'WA', '98052', 3);
INSERT INTO OWNED_PROPERTY VALUES(seqOPID.nextVal,
	'Kodak Heights Apts', 'Apartments', '65 32nd Avenue', 'Redmond', 'WA', '98052', 4);
INSERT INTO OWNED_PROPERTY VALUES(seqOPID.nextVal,
	'Jones House', 'Private Residence', '1456 48th St', 'Bellevue', 'WA', '98007', 1);
INSERT INTO OWNED_PROPERTY VALUES(seqOPID.nextVal,
	'Douglas House', 'Private Residence', '1567 51st St', 'Bellevue', 'WA', '98007', 3);
INSERT INTO OWNED_PROPERTY VALUES(seqOPID.nextVal,
	'Samuels House', 'Private Residence', '567 151st St', 'Redmond', 'WA', '98052', 5);


-- SELECT * FROM OWNED_PROPERTY;

/*****   EMPLOYEE   *************************************************************/

INSERT INTO EMPLOYEE VALUES(seqEID.nextVal,
	'Smith', 'Sam', '206-254-1234', 'Master');
INSERT INTO EMPLOYEE VALUES(seqEID.nextVal,
	'Evanston', 'John','206-254-2345', 'Senior');
INSERT INTO EMPLOYEE VALUES(seqEID.nextVal,
	'Murray', 'Dale', '206-254-3456', 'Junior');
INSERT INTO EMPLOYEE VALUES(seqEID.nextVal,
	'Murphy', 'Jerry', '585-545-8765', 'Master');
INSERT INTO EMPLOYEE VALUES(seqEID.nextVal,
	'Fontaine', 'Joan', '206-254-4567', 'Senior');

-- SELECT * FROM EMPLOYEE;

/*****   GG_SERVICE   **************************************************************/

INSERT INTO GG_SERVICE VALUES(seqGGSID.nextVal, 'Mow Lawn', 25.00);
INSERT INTO GG_SERVICE VALUES(seqGGSID.nextVal, 'Plant Annuals', 25.00);
INSERT INTO GG_SERVICE VALUES(seqGGSID.nextVal, 'Weed Garden', 30.00);
INSERT INTO GG_SERVICE VALUES(seqGGSID.nextVal, 'Trim Hedge', 45.00);
INSERT INTO GG_SERVICE VALUES(seqGGSID.nextVal, 'Prune Small Tree', 60.00);
INSERT INTO GG_SERVICE VALUES(seqGGSID.nextVal, 'Trim Medium Tree',100.00);
INSERT INTO GG_SERVICE VALUES(seqGGSID.nextVal, 'Trim Large Tree', 125.00);


-- SELECT * FROM GG_SERVICE;

/*****   PROPERTY_SERVICE   **************************************************************/

INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 1, 2, TO_DATE('05-MAY-17', 'DD-MON-YY'), 1, 4.50);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 3, 2, TO_DATE('08-MAY-17', 'DD-MON-YY'), 3, 4.50);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 2, 1, TO_DATE('08-MAY-17', 'DD-MON-YY'), 2, 2.75);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 6, 1, TO_DATE('10-MAY-17', 'DD-MON-YY'), 5, 2.50);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 5, 4, TO_DATE('12-MAY-17', 'DD-MON-YY'), 4, 7.50);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 8, 1, TO_DATE('15-MAY-17', 'DD-MON-YY'), 4, 2.75);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 4, 4, TO_DATE('19-MAY-17', 'DD-MON-YY'), 1, 1.00);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 7, 1, TO_DATE('21-MAY-17', 'DD-MON-YY'), 2, 2.50);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 6, 3, TO_DATE('03-JUN-17', 'DD-MON-YY'), 5, 2.50);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 5, 7, TO_DATE('08-JUN-17', 'DD-MON-YY'), 4, 10.50);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 8, 3, TO_DATE('12-JUN-17', 'DD-MON-YY'), 4, 2.75);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 4, 5, TO_DATE('15-JUN-17', 'DD-MON-YY'), 1, 5.00);
INSERT INTO PROPERTY_SERVICE VALUES(seqPSID.nextVal, 7, 3, TO_DATE('19-JUN-17', 'DD-MON-YY'), 2, 4.00);




-- SELECT * FROM PROPERTY_SERVICE;







/****************************************************************************************/

