Sample Database Dummy Data
Create
/********************************************************************************/
/* */
/* Kroenke and Auer - Database Processing (14th Edition) Chapters 10A */
/* */
/* The View Ridge Gallery (VRG_CH10A_PQ) - Create Tables */
/* */
/* These are the Microsoft SQL Server 2012/2014 SQL code solutions */
/* */
/********************************************************************************/
USE VRG_CH10A_PQ
GO
CREATE TABLE ARTIST (
ArtistID Int NOT NULL IDENTITY(1,1),
LastName Char(25) NOT NULL,
FirstName Char(25) NOT NULL,
Nationality Char(30) NULL,
DateOfBirth Numeric(4) NULL,
DateDeceased Numeric(4) NULL,
CONSTRAINT ArtistPK PRIMARY KEY(ArtistID),
CONSTRAINT ArtistAK1 UNIQUE(LastName, FirstName),
/* CONSTRAINT NationalityValues CHECK
(Nationality IN ('Canadian', 'English', 'French',
'German', 'Mexican', 'Russian', 'Spanish',
'United States')), */
CONSTRAINT BirthValuesCheck CHECK (DateOfBirth < DateDeceased),
CONSTRAINT ValidBirthYear CHECK
(DateOfBirth LIKE '[1-2][0-9][0-9][0-9]'),
CONSTRAINT ValidDeathYear CHECK
(DateDeceased LIKE '[1-2][0-9][0-9][0-9]')
);
CREATE TABLE WORK (
WorkID Int NOT NULL IDENTITY(500,1),
Title Char(35) NOT NULL,
Copy Char(12) NOT NULL,
Medium Char(35) NULL,
[Description] Varchar(1000) NULL DEFAULT 'Unknown provenance',
ArtistID Int NOT NULL,
CONSTRAINT WorkPK PRIMARY KEY(WorkID),
CONSTRAINT WorkAK1 UNIQUE(Title, Copy),
CONSTRAINT ArtistFK FOREIGN KEY(ArtistID)
REFERENCES ARTIST(ArtistID)
ON UPDATE NO ACTION
ON DELETE NO ACTION
);
CREATE TABLE CUSTOMER (
CustomerID Int NOT NULL IDENTITY(1000,1),
LastName Char(25) NOT NULL,
FirstName Char(25) NOT NULL,
EmailAddress Varchar(100) NULL,
EncryptedPassword Varchar(50) NULL,
Street Char(30) NULL,
City Char(35) NULL,
[State] Char(2) NULL,
ZIPorPostalCode Char(9) NULL,
Country Char(50) NULL,
AreaCode Char(3) NULL,
PhoneNumber Char(8) NULL,
CONSTRAINT CustomerPK PRIMARY KEY(CustomerID),
CONSTRAINT EmailAK1 UNIQUE(EmailAddress)
);
CREATE TABLE TRANS (
TransactionID Int NOT NULL IDENTITY(100,1),
DateAcquired Date NOT NULL,
AcquisitionPrice Numeric(8,2) NOT NULL,
AskingPrice Numeric(8,2) NULL,
DateSold Date NULL,
SalesPrice Numeric(8,2) NULL,
CustomerID Int NULL,
WorkID Int NOT NULL,
CONSTRAINT TransPK PRIMARY KEY(TransactionID),
CONSTRAINT TransWorkFK FOREIGN KEY(WorkID)
REFERENCES WORK(WorkID)
ON UPDATE NO ACTION
ON DELETE NO ACTION,
CONSTRAINT TransCustomerFK FOREIGN KEY(CustomerID)
REFERENCES CUSTOMER(CustomerID)
ON UPDATE NO ACTION
ON DELETE NO ACTION,
CONSTRAINT SalesPriceRange CHECK
((SalesPrice > 0) AND (SalesPrice <=500000)),
CONSTRAINT ValidTransDate CHECK (DateAcquired <= DateSold)
);
CREATE TABLE CUSTOMER_ARTIST_INT(
ArtistID Int NOT NULL,
CustomerID Int NOT NULL,
CONSTRAINT CAIntPK PRIMARY KEY(ArtistID, CustomerID),
CONSTRAINT CAInt_ArtistFK FOREIGN KEY(ArtistID)
REFERENCES ARTIST(ArtistID)
ON UPDATE NO ACTION
ON DELETE CASCADE,
CONSTRAINT CAInt_CustomerFK FOREIGN KEY(CustomerID)
REFERENCES CUSTOMER(CustomerID)
ON UPDATE NO ACTION
ON DELETE CASCADE
);
Insert
/********************************************************************************/
/* */
/* Kroenke and Auer - Database Processing (14th Edition) Chapters 10A */
/* */
/* The View Ridge Gallery (VRG_CH10A_PQ) Database - Insert Data */
/* */
/* These are the Microsoft SQL Server 2012/2014 SQL code solutions */
/* */
/********************************************************************************/
/* */
/* This file contains the initial data for each table. */
/* */
/* NOTE: We will have a problem entering the surrogate key values shown in */
/* the text. */
/* */
/* The database table structure was set up using the SQL Server T-SQL */
/* keyword IDENTITY to create surrogate keys. This means that by default */
/* we cannot enter values into any column defined with INDENTITY. */
/* */
/* But that means we cannot enter the primary key values as shown. */
/* To work around this, we will use the T-SQL command IDENTITY_INSERT. */
/* */
/* When IDENTITY_INSERT is set to OFF (the default), only the DBMS */
/* can enter data into the controlled column in the table. */
/* */
/* When IDENTITY_INSERT is set to ON, values can be input into the */
/* controlled column in the table. However, IDENTITY_INSERT can only be set */
/* to ON for only one table at a time. Futher, IDENTITY_INSERT requires */
/* the use of a column list containing the name of the surrogate key in each */
/* INSERT command. */
/* */
/********************************************************************************/
USE VRG_CH10A_PQ
GO
/* Be sure IDENTITY_INSERT is OFF for all tables. */
SET IDENTITY_INSERT dbo.CUSTOMER OFF
SET IDENTITY_INSERT dbo.ARTIST OFF
SET IDENTITY_INSERT dbo.WORK OFF
SET IDENTITY_INSERT dbo.TRANS OFF
/********************************************************************************/
/* INSERT data for CUSTOMER */
/* Set IDENTITY_INSERT to ON for CUSTOMER. */
/* reset it to OFF after CUSTOMER data is inserted. */
SET IDENTITY_INSERT dbo.CUSTOMER ON
INSERT INTO CUSTOMER
(CustomerID, LastName, FirstName, EmailAddress, EncryptedPassword,
Street, City, [State], ZIPorPostalCode, Country,
AreaCode, PhoneNumber)
VALUES (
1000, 'Janes', 'Jeffrey', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', 'Ues3thQ2','105 Locust Ave', 'Atlanta', 'GA', '30322', 'USA',
'404', '653-3465');
INSERT INTO CUSTOMER
(CustomerID, LastName, FirstName, EmailAddress, EncryptedPassword,
Street, City, [State], ZIPorPostalCode, Country,
AreaCode, PhoneNumber)
VALUES (
1040, 'Gray', 'Donald','[email protected]', NULL,'55 Bodega Ave', 'Bodega Bay', 'CA', '94923', 'USA',
'707', '568-4839');
INSERT INTO CUSTOMER
(CustomerID, LastName, FirstName, EmailAddress, EncryptedPassword,
Street, City, [State], ZIPorPostalCode, Country,
AreaCode, PhoneNumber)
VALUES (
1041, 'Johnson', 'Lynda', NULL, NULL, '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', '[email protected]', '45QZjx59','87 Highland Drive', 'Olympia', 'WA', '98508', 'USA',
'360', '876-8822');
SET IDENTITY_INSERT dbo.CUSTOMER OFF
/********************************************************************************/
/* INSERT data for ARTIST */
/* Set IDENTITY_INSERT to ON for ARTIST. */
/* reset it to OFF after ARTIST data is inserted. */
SET IDENTITY_INSERT dbo.ARTIST ON
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);
SET IDENTITY_INSERT dbo.ARTIST OFF
/********************************************************************************/
/* INSERT data for CUSTOMER_ARTIST_INT */
/* IDENTITY_INSERT OFF is NOT needed for CUSTOMER_ARTIST_INT. */
/* There are NO surrogate keys in 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 */
/* Set IDENTITY_INSERT to ON for WORK. */
/* reset it to OFF after WORK data is inserted. */
SET IDENTITY_INSERT dbo.WORK ON
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);
SET IDENTITY_INSERT dbo.WORK OFF
/********************************************************************************/
/* INSERT data for TRANS */
/* Set IDENTITY_INSERT to ON for TRANS. */
/* reset it to OFF after TRANS data is inserted. */
SET IDENTITY_INSERT dbo.TRANS ON
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
100, '11/4/2011', 30000.00, 45000.00, '12/14/2011', 42500.00, 1000, 500);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
101, '11/7/2011', 250.00, 500.00, '12/19/2011', 500.00, 1015, 511);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
102, '11/17/2011', 125.00, 250.00, '01/18/2012', 200.00, 1001, 521);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
103, '11/17/2011', 250.00, 500.00, '12/12/2012', 400.00, 1034, 522);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
104, '11/17/2011', 250.00, 250.00, '01/18/2012', 200.00, 1001, 523);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
105, '11/17/2011', 200.00, 500.00, '12/12/2012', 400.00, 1034, 524);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
115, '03/03/2012', 1500.00, 3000.00, '06/07/2012', 2750.00, 1033, 537);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
121, '09/21/2012', 15000.00, 30000.00, '11/28/2012', 27500.00, 1015, 548);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
125, '11/21/2012', 125.00, 250.00, '12/18/2012', 200.00, 1001, 551);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
126, '11/21/2012', 200.00, 400.00, 552)
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
127, '11/21/2012', 125.00, 500.00, '12/22/2012', 400.00, 1034, 553);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
128, '11/21/2012', 125.00, 250.00, '03/16/2013', 225.00, 1036, 554);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
129, '11/21/2012', 125.00, 250.00, '03/16/2013', 225.00, 1036, 555);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
151, '05/7/2013', 10000.00, 20000.00, '06/28/2013', 17500.00, 1036, 561);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
152, '05/18/2013', 125.00, 250.00, '08/15/2013', 225.00, 1001, 562);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
153, '05/18/2013', 200.00, 400.00, '08/15/2013', 350.00, 1001, 563);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
154, '05/18/2013', 250.00, 500.00, '09/28/2013', 400.00, 1040, 564);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
155, '05/18/2013', 250.00, 500.00, 565);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
156, '05/18/2013', 250.00, 500.00, '09/27/2013', 400.00, 1040, 566);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
161, '06/28/2013', 7500.00, 15000.00, '09/29/2013', 13750.00, 1033, 570);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
171, '08/23/2013', 35000.00, 60000.00, '09/29/2013', 55000.00, 1000, 571);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
175, '09/29/2013', 40000.00, 75000.00, '12/18/2013', 72500.00, 1036, 500);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
181, '10/11/2013', 250.00, 500.00, 578);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
201, '02/28/2014', 2000.00, 3500.00, '04/26/2014', 3250.00, 1040, 580);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
202, '02/28/2014', 2000.00, 3500.00, '04/26/2014', 3250.00, 1040, 581);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
225, '06/8/2014', 125.00, 250.00, '09/27/2014', 225.00, 1051, 585);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
226, '06/8/2014', 200.00, 400.00, 586);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
227, '06/8/2014', 250.00, 500.00, '09/27/2014', 475.00, 1051, 587);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
228, '06/8/2014', 250.00, 500.00, 588)
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
229, '06/8/2014', 250.00, 500.00, 589)
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, DateSold, SalesPrice, CustomerID, WorkID)
VALUES (
241, '08/29/2014', 2500.00, 5000.00, '09/27/2014', 4750.00, 1015, 590)
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
251, '10/25/2014', 25000.00, 50000.00, 593);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
252, '10/27/2014', 250.00, 500.00, 594);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
253, '10/27/2014', 250.00, 500.00, 595);
INSERT INTO TRANS (TransactionID, DateAcquired, AcquisitionPrice,
AskingPrice, WorkID)
VALUES (
254, '10/27/2014', 250.00, 500.00, 596);
SET IDENTITY_INSERT dbo.TRANS OFF
/********************************************************************************/
No Comments