17.2 Populate VRG Database

17.2.1 Populate CUSTOMER Table

Firstly, run the following script to remove all the rows in the CUSTOMER table:

set foreign_key_checks=0;
truncate table customer;
set foreign_key_checks=1;
select count(*) from customer;

Then run the following script to insert all the customer rows in a single INSERT INTO statement:

INSERT INTO CUSTOMER
    (CustomerID, LastName,  FirstName, EmailAddress, EncryptedPassword,
     Street, City, State, ZIPorPostalCode, Country,
     AreaCode, PhoneNumber)
    VALUES 
    (1000, 'Janes', 'Jeffrey', 'Jeffrey.Janes@somewhere.com', DES_ENCRYPT('new'),'123 W. Elm St', 'Renton', 'WA', '98055', 'USA',
    '425', '543-2345'),
    (1001, 'Smith', 'David', 'David.Smith@somewhere.com', DES_ENCRYPT('new'), '813 Tumbleweed Lane', 'Loveland', 'CO', '81201', 'USA',
    '970', '654-9876'),
    (1015, 'Twilight', 'Tiffany', 'Tiffany.Twilight@somewhere.com', DES_ENCRYPT('new'), '88 1st Avenue', 'Langley', 'WA', '98260', 'USA',
     '360', '765-5566'),
     (1033, 'Smathers', 'Fred', 'Fred.Smathers@somewhere.com', DES_ENCRYPT('new'), '10899 88th Ave', 'Bainbridge Island', 'WA', '98110', 'USA',
     '206', '876-9911'),
     (1034, 'Frederickson', 'Mary Beth', 'MaryBeth.Frederickson@somewhere.com', DES_ENCRYPT('new'), '25 South Lafayette', 'Denver', 'CO', '80201', 'USA',
    '303', '513-8822'),
    (1036, 'Warning', 'Selma', 'Selma.Warning@somewhere.com', 'CAe3Gh98', '205 Burnaby', 'Vancouver', 'BC', 'V6Z 1W2', 'Canada',
    '604', '988-0512'),
    (1037, 'Wu', 'Susan', 'Susan.Wu@somewhere.com', DES_ENCRYPT('new'),'105 Locust Ave', 'Atlanta', 'GA', '30322', 'USA',
    '404', '653-3465'),
    (1040, 'Gray', 'Donald','Donald.Gray@somewhere.com', NULL,'55 Bodega Ave', 'Bodega Bay', 'CA', '94923', 'USA',
    '707', '568-4839'),
    (1041, 'Johnson', 'Lynda', NULL, NULL, '117 C Street', 'Washington', 'DC', '20003', 'USA',
    '202', '438-5498'),
    (1051, 'Wilkens', 'Chris', 'Chris.Wilkens@somewhere.com', DES_ENCRYPT('new'),'87 Highland Drive', 'Olympia', 'WA', '98508', 'USA',
    '360', '876-8822'); 

Now, run the following query to find the total customers after data insertion:

select count(*) from customer;  

17.2.2 Populate ARTIST Table

Firstly, run the following script to remove all the rows in the ARTIST table:

set foreign_key_checks=0;
truncate table artist;
set foreign_key_checks=1;
select count(*) from artist;

Then run the following script to insert all the ARTIST rows in a single INSERT INTO statement:

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

Now, run the following query to find the total artists after data insertion:

select count(*) from artist;  

17.2.3 Populate CUSTOMER_ARTIST_INT Table

Firstly, run the following script to remove all the rows in the CUSTOMER_ARTIST_INT table:

set foreign_key_checks=0;
truncate table CUSTOMER_ARTIST_INT;
set foreign_key_checks=1;
select count(*) from artist;

Then run the following script to insert all the CUSTOMER_ARTIST_INT rows in a single INSERT INTO statement:

--  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);

Now, run the following query to find the total rows after data insertion:

select count(*) from CUSTOMER_ARTIST_INT;  

17.2.4 Populate WORK Table

Firstly, run the following script to remove all the rows in the WORK table:

set foreign_key_checks=0;
truncate table work;
set foreign_key_checks=1;
select count(*) from work;

Then run the following script to insert all the WORK rows in a single INSERT INTO statement:

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

Now, run the following query to find the total artists after data insertion:

select count(*) from work;  

17.2.5 Populate TRANS Table

Firstly, run the following script to remove all the rows in the TRANS table:

set foreign_key_checks=0;
truncate table trans;
set foreign_key_checks=1;
select count(*) from trans;

Then run the following script to insert all the TRANS rows in a single INSERT INTO statement:

--  INSERT data for TRANS
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (100, '2011-11-04', 30000.00, 45000.00, '2011-12-14', 42500.00, 1000, 500);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (101, '2011-11-07', 250.00, 500.00, '2011-12-19', 500.00,    1015, 511);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (102, '2011-11-17', 125.00, 250.00, '2012-01-18', 200.00, 1001, 521);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (103, '2011-11-17', 250.00, 500.00, '2012-12-12', 400.00, 1034, 522);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (104, '2011-11-17', 250.00, 250.00, '2012-01-18', 200.00, 1001, 523);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (105, '2011-11-17', 200.00, 500.00, '2012-12-12', 400.00, 1034, 524);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (115, '2012-03-03', 1500.00, 3000.00, '2012-06-07', 2750.00, 1033, 537);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (121, '2012-09-21', 15000.00, 30000.00, '2012-11-28', 27500.00,  1015, 548);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (125, '2012-11-21', 125.00, 250.00, '2012-12-18', 200.00, 1001, 551);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (126, '2012-11-21', 200.00, 400.00, 552);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (127, '2012-11-21', 125.00, 500.00, '2012-12-22', 400.00, 1034, 553);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (128, '2012-11-21', 125.00, 250.00, '2013-03-16', 225.00, 1036, 554);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (129, '2012-11-21', 125.00, 250.00, '2013-03-16', 225.00, 1036, 555);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (151, '2013-05-07', 10000.00, 20000.00, '2013-06-28', 17500.00, 1036, 561);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (152, '2013-05-18', 125.00, 250.00, '2013-08-15', 225.00, 1001, 562);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (153, '2013-05-18', 200.00, 400.00, '2013-08-15', 350.00, 1001, 563);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (154, '2013-05-18', 250.00, 500.00, '2013-09-28', 400.00, 1040, 564);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (155, '2013-05-18', 250.00, 500.00, 565);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (156, '2013-05-18', 250.00, 500.00, '2013-09-27', 400.00, 1040, 566);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (161, '2013-06-28', 7500.00, 15000.00, '2013-09-29', 13750.00, 1033, 570);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (171, '2013-08-23', 35000.00, 60000.00, '2013-09-29', 55000.00, 1000, 571);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (175, '2013-08-23', 40000.00, 75000.00, '2013-12-18', 72500.00, 1036, 500);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (181, '2013-10-11', 250.00, 500.00, 578);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (201, '2014-02-28', 2000.00, 3500.00, '2014-04-26', 3250.00, 1040, 580);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (202, '2014-02-28', 2000.00, 3500.00, '2014-04-26', 3250.00, 1040, 581);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (225, '2014-06-08', 125.00, 250.00, '2014-09-27', 225.00, 1051, 585);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (226, '2014-06-08', 200.00, 400.00, 586);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (227, '2014-06-08', 250.00, 500.00, '2014-09-27', 475.00, 1051, 587);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (228, '2014-06-08', 250.00, 500.00, 588);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (229, '2014-06-08', 250.00, 500.00, 589);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
    VALUES (241, '2014-08-29', 2500.00, 5000.00, '2014-09-27', 4750.00, 1015, 590);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (251, '2014-10-25', 25000.00, 50000.00, 593);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (252, '2014-10-27', 250.00, 500.00, 594);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (253, '2014-10-27', 250.00, 500.00, 595);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
    AskingPrice, WorkID)
    VALUES (254, '2014-10-27', 250.00, 500.00, 596);

Now, run the following query to find the total transactions after data insertion:

select count(*) from trans;