Database Reference
In-Depth Information
Figure 3-33 shows typical sales data for The Queen Anne Curiosity Shop, and
Figure 3-34 shows typical purchase data.
A. Using these data, state assumptions about functional dependencies among the col-
umns of data. Justify your assumptions on the basis of these sample data and also on
the basis of what you know about retail sales.
B. Given your assumptions in part A, comment on the appropriateness of the following
designs:
1. CUSTOMER ( LastName , FirstName, Phone, Email, InvoiceDate,
InvoiceItem, Price, Tax, Total)
2. CUSTOMER ( LastName , FirstName , Phone, Email, InvoiceDate,
InvoiceItem, Price, Tax, Total)
3. CUSTOMER (LastName, FirstName, Phone , Email, InvoiceDate,
InvoiceItem, Price, Tax, Total)
4. CUSTOMER ( LastName , FirstName , Phone, Email, InvoiceDate ,
InvoiceItem, Price, Tax, Total)
5. CUSTOMER ( LastName , FirstName , Phone, Email, InvoiceDate,
InvoiceItem , Price, Tax, Total)
6. CUSTOMER ( LastName , FirstName , Phone, Email)
and:
SALE ( InvoiceDate , InvoiceItem, Price, Tax, Total)
7. CUSTOMER ( LastName , FirstName , Phone, Email, InvoiceDate )
and:
SALE ( InvoiceDate , InvoiceItem, Price, Tax, Total)
Figure 3-33
Sample Sales Data for the
Queen anne Curiosity Shop
LastName
FirstName
Phone
InvoiceDate
InvoiceItem
Price
Tax
Total
Shire
Robert
206-524-2433
14-Dec-13
Antique Desk
3,000.00
249.00
3,249.00
Shire
Robert
206-524-2433
14-Dec-13
Antique Desk Chair
500.00
41.50
541.50
Goodyear
Katherine
206-524-3544
15-Dec-13
Dining Table Linens
1,000.00
83.00
1,083.00
Bancroft
Chris
425-635-9788
15-Dec-13
Candles
50.00
4.15
54.15
Griffith
John
206-524-4655
23-Dec-13
Candles
45.00
3.74
48.74
Shire
Robert
206-524-2433
5-Jan-14
Desk Lamp
250.00
20.75
270.75
Tierney
Doris
425-635-8677
10-Jan-14
Dining Table Linens
750.00
62.25
812.25
Anderson
Donna
360-538-7566
12-Jan-14
Book Shelf
250.00
20.75
270.75
Goodyear
Katherine
206-524-3544
15-Jan-14
Antique Chair
1,250.00
103.75
1,353.75
Katherine
206-524-3544
15-Jan-14
Antique Chair
1,750.00
145.25
1,895.25
Goodyear
Tierney
Doris
425-635-8677
25-Jan-14
Antique Candle Holders
350.00
29.05
379.05
 
 
 
Search WWH ::




Custom Search