SQL for Database Construction and Application Processing - Database Processing: Fundamentals, Design, and Implementation - page 306

TransactionID DateAcquired AcquisitionPrice AskingPrice DateSoldID SalesPrice CustomerID WorkID

100 11/4/2009 $30,000.00 $45,000.00 12/14/2009 $42,500.00 1000 500

101 11/7/2009 $250.00 $500.00 12/19/2009 $500.00 1015 511

11/17/2009 $125.00 $250.00 1/18/2010 $200.00 1001 521

102

$500.00 12/12/2010 $400.00 1034 522

103 11/17/2009 $250.00

1/18/2010 $200.00 1001 523

104 11/17/2009 $250.00 $250.00

524

105 11/17/2009 $200.00 $500.00 12/12/2010 $400.00 1034

115 3/3/2010 $1,500.00 $3,000.00 6/7/2010 $2,750.00 1033 537

121 9/21/2010 $15,000.00 $30,000.00 11/28/2010 $27,500.00 1015 548

11/21/2010 $125.00 $250.00 12/18/2010 $200.00 1001 551

125

$400.00 NULL NULL NULL 552

126 11/21/2010 $200.00

$400.00 1034 553

127 11/21/2010 $125.00 $500.00 12/22/2010

128 11/21/2010 $125.00 $250.00 3/16/2011 $225.00 1036 554

129 11/21/2010 $125.00 $250.00 3/16/2011 $225.00 1036 555

151 5/7/2011 $10,000.00 $20,000.00 6/28/2011 $17,500.00 1036 561

$125.00 $250.00 8/15/2011 $225.00 1001 562

152 5/18/2011

$400.00 8/15/2011 $350.00 1001 563

153 5/18/2011 $200.00

$400.00 1040 564

154 5/18/2011 $250.00 $500.00 9/28/2011

155 5/18/2011 $250.00 $500.00 NULL NULL NULL 565

156 5/18/2011 $250.00 $500.00 9/27/2011 $400.00 1040 566

161 6/28/2011 $7,500.00 $15,000.00 9/29/2011 $13,750.00 1033 570

$35,000.00 $60,000.00 9/29/2011 $55,000.00 1000 571

171 8/23/2011

$75,000.00 12/18/2011 $72,500.00 1036 500

175 9/29/2011 $40,000.00

NULL NULL NULL 578

181 10/11/2011 $250.00 $500.00

201 2/28/2012 $2,000.00 $3,500.00 4/26/2012 $3,250.00 1040 580

202 2/28/2012 $2,000.00 $3,500.00 4/26/2012 $3,250.00 1040 581

6/8/2012 $125.00 $250.00 9/27/2012 $225.00 1051 585

225

$200.00 $400.00 NULL NULL NULL 586

226 6/8/2012

9/27/2012 $475.00 1051 587

227 6/8/2012 $250.00 $500.00

NULL NULL NULL 588

228 6/8/2012 $250.00 $500.00

NULL NULL NULL

229 6/8/2012 $250.00 $500.00 589

241 8/29/2012 $2,500.00 $5,000.00 9/27/2012 $4,750.00 1015 590

10/25/2012 $25,000.00 $50,000.00 NULL NULL NULL 593

251

$500.00 NULL NULL NULL 594

252 10/27/2012 $250.00

NULL NULL NULL 595

253 10/27/2012 $250.00 $500.00

NULL NULL NULL 596

254 10/27/2012 $250.00 $500.00

(e) TRANS Table Data

Figure 7-16
Continued