Database Reference
In-Depth Information
ItemID
ItemDescription
PurchaseDate
ItemCost
ItemPrice
VendorID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Antique Desk
Antique Desk Chair
Dining Table Linens
Candles
Candles
Desk Lamp
Dining Table Linens
Book Shelf
Antique Chair
Antique Chair
Antique Candle Holders
Antique Desk
Antique Desk
Antique Desk Chair
Antique Desk Chair
Desk Lamp
Desk Lamp
Desk Lamp
Antique Dining Table
Antique Sideboard
Dining Table Chairs
Dining Table Linens
Dining Table Linens
Candles
Candles
2012-11-07
2012-11-10
2012-11-14
2012-11-14
2012-11-14
2012-11-14
2012-11-14
2012-11-21
2012-11-21
2012-11-21
2012-11-28
2013-01-05
2013-01-05
2013-01-06
2013-01-06
2013-01-06
2013-01-06
2013-01-06
2013-01-10
2013-01-11
2013-01-11
2013-01-12
2013-01-12
2013-01-17
2013-01-17
$1,800.00
$300.00
$600.00
$30.00
$27.00
$150.00
$450.00
$150.00
$750.00
$1,050.00
$210.00
$1,920.00
$2,100.00
$285.00
$339.00
$150.00
$150.00
$144.00
$3,000.00
$2,700.00
$5,100.00
$450.00
$480.00
$30.00
$36.00
$3,000.00
$500.00
$1,000.00
$50.00
$45.00
$250.00
$750.00
$250.00
$1,250.00
$1,750.00
$350.00
$3,200.00
$3,500.00
$475.00
$565.00
$250.00
$250.00
$240.00
$5,000.00
$4,500.00
$8,500.00
$750.00
$800.00
$50.00
$60.00
2
4
1
1
1
3
1
5
6
6
2
2
2
9
9
10
10
3
7
8
9
1
1
1
1
Figure 7-46
Sample Data for the
QaCS ItEM table
SaleID
CustomerID
EmployeeID
SaleDate
SubTotal
Tax
Total
$3,790.50
$1,083.00
$54.15
$48.74
$270.75
$812.25
$270.75
$3,249.00
$379.05
$15,432.75
$270.75
$54.15
$4,873.50
$3,980.03
$866.40
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
1
2
3
4
1
5
6
2
5
7
8
5
9
10
2
1
1
1
3
5
5
4
1
5
1
5
4
2
3
2
2012-12-14
2012-12-15
2012-12-15
2012-12-23
2013-01-05
2013-01-10
2013-01-12
2013-01-15
2013-01-25
2013-02-04
2013-02-04
2013-02-07
2013-02-07
2013-02-11
2013-02-11
$3,500.00
$100.00
$50.00
$45.00
$250.00
$750.00
$250.00
$3,000.00
$350.00
$14,250.00
$250.00
$50.00
$4,500.00
$3,675.00
$800.00
$290.50
$83.00
$4.15
$3.74
$20.75
$62.25
$20.75
$249.00
$29.05
$1,182.75
$20.75
$4.15
$373.50
$305.03
$66.40
Figure 7-47
Sample Data for the
QaCS SaLE table
Search WWH ::
Custom Search