/******************************************************************************/
/*																						                                */
/*	Kroenke, Auer, Vandenberg, and Yoder			*/
/*   Database Processing (15th Edition) Chapter 10B			    */
/*																						                                */
/*	The View Ridge Gallery (VRG) Database - Insert Data							          */
/*																						                                */
/*	These are the Oracle Database SQL code solutions		                      */
/*																						                                */
/******************************************************************************/
/*																						                                */
/*	This file contains the initial data for the each table.							      */
/*																						                                */
/*	We will create the surrogate key sequences after we have inserted			    */
/*	this data																				                          */
/*																						                                */
/******************************************************************************/

/*	INSERT data for CUSTOMER															*/

INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, EmailAddress, EncryptedPassword,
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
	1000, 'Janes', 'Jeffrey', 'Jeffrey.Janes@somewhere.com', 'ng76tG9E',
	'123 W. Elm St', 'Renton', 'WA', '98055', 'USA', '425', '543-2345');

INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, EmailAddress, EncryptedPassword,
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
 	1001, 'Smith', 'David', 'David.Smith@somewhere.com', 'ttr67i23',
	'813 Tumbleweed Lane', 'Loveland', 'CO', '81201', 'USA', '970', '654-9876');

INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, EmailAddress,
	EncryptedPassword, 
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
	1015, 'Twilight', 'Tiffany', 'Tiffany.Twilight@somewhere.com', 'gr44t5uz', 
	'88 1st Avenue', 'Langley', 'WA', '98260', 'USA', '360', '765-5566');
  
INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, EmailAddress,
	EncryptedPassword,
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
	1033, 'Smathers', 'Fred', 'Fred.Smathers@somewhere.com',
	'mnF3D00Q', '10899 88th Ave', 'Bainbridge Island', 'WA', '98110', 'USA', '206', '876-9911');

INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, EmailAddress, EncryptedPassword,
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
	1034, 'Frederickson', 'Mary Beth', 'MaryBeth.Frederickson@somewhere.com', 'Nd5qr4Tv',
	'25 South Lafayette', 'Denver', 'CO', '80201', 'USA', '303', '513-8822');

INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, EmailAddress, EncryptedPassword,
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
	1036, 'Warning', 'Selma', 'Selma.Warning@somewhere.com', 'CAe3Gh98',
	'205 Burnaby', 'Vancouver', 'BC', 'V6Z 1W2', 'Canada', '604', '988-0512');


INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, EmailAddress,
	EncryptedPassword,
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
	1037, 'Wu', 'Susan', 'Susan.Wu@somewhere.com', 'Ues3thQ2',
	'105 Locust Ave', 'Atlanta', 'GA', '30322', 'USA', '404', '653-3465');

INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, EmailAddress, 
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
	1040, 'Gray', 'Donald','Donald.Gray@somewhere.com', 
	'55 Bodega Ave', 'Bodega Bay', 'CA', '94923', 'USA', '707', '568-4839');

INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, 
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
	1041, 'Johnson', 'Lynda',
	'117 C Street', 'Washington', 'DC', '20003', 'USA', '202', '438-5498');

INSERT INTO CUSTOMER
	(CustomerID, LastName, FirstName, EmailAddress, EncryptedPassword,
	 Street, City, State, ZIPorPostalCode, Country, AreaCode, PhoneNumber)
	VALUES (
	1051, 'Wilkens', 'Chris', 'Chris.Wilkens@somewhere.com', '45QZjx59',
	'87 Highland Drive', 'Olympia', 'WA', '98508', 'USA', '360', '876-8822'); 

/*	CREATE the CUSTOMER surrogate key sequence seqCID 							*/

CREATE SEQUENCE seqCID INCREMENT BY 1 START WITH 1052;

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

/*	INSERT data for ARTIST																*/

INSERT INTO ARTIST VALUES(
	1, 'Miro', 'Joan', 'Spanish', 1893, 1983);
INSERT INTO ARTIST VALUES(
	2, 'Kandinsky', 'Wassily', 'Russian', 1866, 1944);
INSERT INTO ARTIST VALUES(
	3, 'Klee', 'Paul', 'German', 1879, 1940);
INSERT INTO ARTIST VALUES(
	4, 'Matisse', 'Henri', 'French', 1869, 1954);
INSERT INTO ARTIST VALUES(
	5, 'Chagall', 'Marc', 'French', 1887, 1985);
INSERT INTO ARTIST VALUES(
	11, 'Sargent', 'John Singer', 'United States', 1856, 1925);
INSERT INTO ARTIST VALUES(
	17, 'Tobey', 'Mark', 'United States', 1890, 1976);
INSERT INTO ARTIST VALUES(
	18, 'Horiuchi', 'Paul', 'United States', 1906, 1999);
INSERT INTO ARTIST VALUES(
	19, 'Graves', 'Morris', 'United States', 1920, 2001);

/*	CREATE the CUSTOMER surrogate key sequence seqCID 							*/

CREATE SEQUENCE seqAID INCREMENT BY 1 START WITH 20;

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

/*	INSERT data for CUSTOMER_ARTIST_INT											*/

INSERT INTO CUSTOMER_ARTIST_INT VALUES (1, 1001);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (1, 1034);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (2, 1001);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (2, 1034);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (4, 1001);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (4, 1034);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (5, 1001);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (5, 1034);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (5, 1036);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (11, 1001);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (11, 1015);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (11, 1036);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (17, 1000);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (17, 1015);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (17, 1033);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (17, 1040);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (17, 1051);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (18, 1000);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (18, 1015);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (18, 1033);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (18, 1040);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (18, 1051);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (19, 1000);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (19, 1015);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (19, 1033);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (19, 1036);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (19, 1040);
INSERT INTO CUSTOMER_ARTIST_INT VALUES (19, 1051);

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

/*	INSERT data for WORK														*/

INSERT INTO WORK VALUES(
	500, 'Memories IV', 'Unique', 'Casein rice paper collage', '31 x 24.8 in.', 18);
INSERT INTO WORK VALUES(
	511, 'Surf and Bird', '142/500', 'High Quality Limited Print',
	'Northwest School Expressionist style', 19);
INSERT INTO WORK VALUES(
	521, 'The Tilled Field', '788/1000', 'High Quality Limited Print',
	'Early Surrealist style', 1);
INSERT INTO WORK VALUES(
	522, 'La Lecon de Ski', '353/500', 'High Quality Limited Print',
	'Surrealist style', 1);
INSERT INTO WORK VALUES(
	523, 'On White II', '435/500', 'High Quality Limited Print',
	'Bauhaus style of Kandinsky', 2);
INSERT INTO WORK VALUES(
	524, 'Woman with a Hat', '596/750', 'High Quality Limited Print',
	'A very colorful Impressionist piece', 4);
INSERT INTO WORK VALUES(
	537, 'The Woven World', '17/750', 'Color lithograph', 'Signed', 17);
INSERT INTO WORK VALUES(
	548, 'Night Bird', 'Unique', 'Watercolor on Paper',
	'50 x 72.5 cm. - Signed', 19);
INSERT INTO WORK VALUES(
	551, 'Der Blaue Reiter', '236/1000', 'High Quality Limited Print',
	'The Blue Rider-Early Pointilism influence', 2);
INSERT INTO WORK VALUES(
	552, 'Angelus Novus', '659/750', 'High Quality Limited Print',
	'Bauhaus style of Klee', 3);
INSERT INTO WORK VALUES(
	553, 'The Dance', '734/1000', 'High Quality Limited Print',
	'An Impressionist masterpiece', 4);
INSERT INTO WORK VALUES(
	554, 'I and the Village', '834/1000', 'High Quality Limited Print',
	'Shows Belarusian folk-life themes and symbology', 5);
INSERT INTO WORK VALUES(
	555, 'Claude Monet Painting', '684/1000', 'High Quality Limited Print',
	'Shows French Impressionist influence of Monet', 11);
INSERT INTO WORK VALUES(
	561, 'Sunflower', 'Unique', 'Watercolor and ink',
	'33.3 x 16.1 cm. - Signed', 19);
INSERT INTO WORK VALUES(
	562, 'The Fiddler', '251/1000', 'High Quality Limited Print',
	'Shows Belarusian folk-life themes and symbology', 5);
INSERT INTO WORK VALUES(
	563, 'Spanish Dancer', '583/750', 'High Quality Limited Print',
	'American realist style - From work in Spain', 11);
INSERT INTO WORK VALUES(
	564, 'Farmer''s Market #2',	'267/500', 'High Quality Limited Print',
	'Northwest School Abstract Expressionist style', 17);
INSERT INTO WORK VALUES(
	565, 'Farmer''s Market #2',	'268/500', 'High Quality Limited Print',
	 'Northwest School Abstract Expressionist style', 17);
INSERT INTO WORK VALUES(
	566, 'Into Time', '323/500', 'High Quality Limited Print',
	'Northwest School Abstract Expressionist style', 18);
INSERT INTO WORK VALUES(
	570, 'Untitled Number 1', 'Unique', 'Monotype with tempera',
	'4.3 x 6.1 in. Signed', 17);
INSERT INTO WORK VALUES(
	571, 'Yellow Covers Blue', 'Unique', 'Oil and collage',
	'71 x 78 in. - Signed', 18);
INSERT INTO WORK VALUES(
	578, 'Mid-Century Hibernation', '362/500', 'High Quality Limited Print',
	'Northwest School Expressionist style', 19);
INSERT INTO WORK VALUES(
	580, 'Forms in Progress I', 'Unique', 'Color aquatint',
	'19.3 x 24.4 in. - Signed', 17);
INSERT INTO WORK VALUES(
	581, 'Forms in Progress II', 'Unique', 'Color aquatint',
	'19.3 x 24.4 in. - Signed', 17);
INSERT INTO WORK VALUES(
	585, 'The Fiddler', '252/1000', 'High Quality Limited Print',
	'Shows Belarusian folk-life themes and symbology', 5);
INSERT INTO WORK VALUES(
	586, 'Spanish Dancer', '588/750', 'High Quality Limited Print',
	'American Realist style - From work in Spain', 11);
INSERT INTO WORK VALUES(
	587, 'Broadway Boggie', '433/500', 'High Quality Limited Print',
	'Northwest School Abstract Expressionist style', 17);
INSERT INTO WORK VALUES(
	588, 'Universal Field', '114/500', 'High Quality Limited Print',
	'Northwest School Abstract Expressionist style', 17);
INSERT INTO WORK VALUES(
	589, 'Color Floating in Time', '487/500', 'High Quality Limited Print',
	'Northwest School Abstract Expressionist style', 18);
INSERT INTO WORK VALUES(
	590, 'Blue Interior', 'Unique', 'Tempera on card', '43.9 x 28 in.', 17);
INSERT INTO WORK VALUES(
	593, 'Surf and Bird', 'Unique', 'Gouache', '26.5 x 29.75 in. - Signed', 19);
INSERT INTO WORK VALUES(
	594, 'Surf and Bird', '362/500', 'High Quality Limited Print',
	'Northwest School Expressionist style', 19);
INSERT INTO WORK VALUES(
	595, 'Surf and Bird', '365/500', 'High Quality Limited Print',
	'Northwest School Expressionist style', 19);
INSERT INTO WORK VALUES(
	596, 'Surf and Bird', '366/500', 'High Quality Limited Print',
	'Northwest School Expressionist style', 19);

/*	CREATE the WORK surrogate key sequence seqWID 							*/

CREATE SEQUENCE seqWID INCREMENT BY 1 START WITH 597;

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

/*	INSERT data for TRANS														*/

INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	100, TO_DATE('11/04/2014','MM/DD/YYYY'), 30000.00, 45000.00,
	TO_DATE('12/14/2014','MM/DD/YYYY'), 42500.00, 1000, 500);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	101, TO_DATE('11/07/2014','MM/DD/YYYY'), 250.00, 500.00,
	TO_DATE('12/19/2014','MM/DD/YYYY'), 500.00,	1015, 511);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	102, TO_DATE('11/17/2014','MM/DD/YYYY'), 125.00, 250.00,
	TO_DATE('01/18/2015','MM/DD/YYYY'), 200.00, 1001, 521);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	103, TO_DATE('11/17/2014','MM/DD/YYYY'), 250.00, 500.00,
	TO_DATE('12/12/2015','MM/DD/YYYY'), 400.00, 1034, 522);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	104, TO_DATE('11/17/2014','MM/DD/YYYY'), 250.00, 250.00,
	TO_DATE('01/18/2015','MM/DD/YYYY'), 200.00, 1001, 523);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	105, TO_DATE('11/17/2014','MM/DD/YYYY'), 200.00, 500.00,
	TO_DATE('12/12/2015','MM/DD/YYYY'), 400.00, 1034, 524);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	115, TO_DATE('03/03/2015','MM/DD/YYYY'), 1500.00, 3000.00,
	TO_DATE('06/07/2015','MM/DD/YYYY'), 2750.00, 1033, 537);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	121, TO_DATE('09/21/2015','MM/DD/YYYY'), 15000.00, 30000.00,
	TO_DATE('11/28/2015','MM/DD/YYYY'), 27500.00,	1015, 548);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	125, TO_DATE('11/21/2015','MM/DD/YYYY'), 125.00, 250.00,
	TO_DATE('12/18/2015','MM/DD/YYYY'), 200.00, 1001, 551);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES (
	126, TO_DATE('11/21/2015','MM/DD/YYYY'), 200.00, 400.00, 552);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	127, TO_DATE('11/21/2015','MM/DD/YYYY'), 125.00, 500.00,
	TO_DATE('12/22/2015','MM/DD/YYYY'), 400.00, 1034, 553);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	128, TO_DATE('11/21/2015','MM/DD/YYYY'), 125.00, 250.00,
	TO_DATE('03/16/2016','MM/DD/YYYY'), 225.00, 1036, 554);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	129, TO_DATE('11/21/2015','MM/DD/YYYY'), 125.00, 250.00,
	TO_DATE('03/16/2016','MM/DD/YYYY'), 225.00, 1036, 555);
 
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	151, TO_DATE('05/07/2016','MM/DD/YYYY'), 10000.00, 20000.00,
	TO_DATE('06/28/2016','MM/DD/YYYY'), 17500.00, 1036, 561);

INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	152, TO_DATE('05/18/2016','MM/DD/YYYY'), 125.00, 250.00,
	TO_DATE('08/15/2016','MM/DD/YYYY'), 225.00, 1001, 562);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 	
	153, TO_DATE('05/18/2016','MM/DD/YYYY'), 200.00, 400.00,
	TO_DATE('08/15/2016','MM/DD/YYYY'), 350.00, 1001, 563);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 	
	154, TO_DATE('05/18/2016','MM/DD/YYYY'), 250.00, 500.00,
	TO_DATE('09/28/2016','MM/DD/YYYY'), 400.00, 1040, 564);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES (
	155, TO_DATE('05/18/2016','MM/DD/YYYY'), 250.00, 500.00, 565);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES (
	156, TO_DATE('05/18/2016','MM/DD/YYYY'), 250.00, 500.00,
	TO_DATE('09/27/2016','MM/DD/YYYY'), 400.00, 1040, 566);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 	
	161, TO_DATE('06/28/2016','MM/DD/YYYY'), 7500.00, 15000.00,
	TO_DATE('09/29/2016','MM/DD/YYYY'), 13750.00, 1033, 570);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 	
	171, TO_DATE('08/23/2016','MM/DD/YYYY'), 35000.00, 60000.00,
	TO_DATE('09/29/2016','MM/DD/YYYY'), 55000.00, 1000, 571);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 	
	175, TO_DATE('09/29/2016','MM/DD/YYYY'), 40000.00, 75000.00,
	TO_DATE('12/18/2016','MM/DD/YYYY'), 72500.00, 1036, 500);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES ( 	
	181, TO_DATE('10/11/2016','MM/DD/YYYY'), 250.00, 500.00, 578);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 	
	201, TO_DATE('02/28/2017','MM/DD/YYYY'), 2000.00, 3500.00,
	TO_DATE('04/26/2017','MM/DD/YYYY'), 3250.00,	1040, 580);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 	
	202, TO_DATE('02/28/2017','MM/DD/YYYY'), 2000.00, 3500.00,
	TO_DATE('04/26/2017','MM/DD/YYYY'), 3250.00, 1040, 581);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 
	225, TO_DATE('06/08/2017','MM/DD/YYYY'), 125.00, 250.00,
	TO_DATE('09/27/2017','MM/DD/YYYY'), 225.00, 1051, 585);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES ( 	
	226, TO_DATE('06/08/2017','MM/DD/YYYY'), 200.00, 400.00, 586);
 
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 	
	227, TO_DATE('06/08/2017','MM/DD/YYYY'), 250.00, 500.00,
	TO_DATE('09/27/2017','MM/DD/YYYY'), 475.00, 1051, 587);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES ( 	
	228, TO_DATE('06/08/2017','MM/DD/YYYY'), 250.00, 500.00, 588);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES ( 	
	229, TO_DATE('06/08/2017','MM/DD/YYYY'), 250.00, 500.00, 589);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
	VALUES ( 	
	241, TO_DATE('08/29/2017','MM/DD/YYYY'), 2500.00, 5000.00,
	TO_DATE('09/27/2017','MM/DD/YYYY'), 4750.00,	1015, 590);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES ( 	
	251, TO_DATE('10/25/2017','MM/DD/YYYY'), 25000.00, 50000.00, 593);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES ( 	
	252, TO_DATE('10/27/2017','MM/DD/YYYY'), 250.00, 500.00, 594);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES ( 	
	253, TO_DATE('10/27/2017','MM/DD/YYYY'), 250.00, 500.00, 595);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
	AskingPrice, WorkID)
	VALUES ( 	
	254, TO_DATE('10/27/2017','MM/DD/YYYY'), 250.00, 500.00, 596);

/*	CREATE the TRANS surrogate key sequence seqTID 							*/

CREATE SEQUENCE seqTID INCREMENT BY 1 START WITH 255;

/*	COMMIT the transaction															*/

COMMIT;

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