The Queen Anne Curiosity Shop project questions in Chapter 3 asked you to create a set of relations to organize and link the Queen Anne Curiosity Shop typical sales data shown in Figure 3-33 and the typical purchase data shown in Figure 3-34. The set of relations may look like the following:

CUSTOMER (CustomerID, LastName, FirstName, Phone, Email)

SALE (SaleID, CustomerID, InvoiceDate, PreTaxTotal, Tax, Total)

SALE_ITEM (SaleID, SaleItemID, PurchaseID, SalePrice)

PURCHASE (PurchaseID, PurchaseItem, PurchasePrice, PurchaseDate, VendorID)

VENDOR (VendorID, Vendor, Phone)

Use these relations and the data in Figures 3-33 and 3-34 to answer the following questions.

A. Follow the procedure shown in Figure 4-1 to assess these data.

1. List all functional dependencies.

2. List any multivalued dependencies.

3. List all candidate keys.

4. List all primary keys

5. List all foreign keys.

6. State any assumptions you make as you list these components.

B. List questions you would ask the owners of the Queen Anne Curiosity Shop to verify your assumptions. C. If there are any multivalued dependencies, create the tables needed to eliminate these dependencies. D. Do these data have the multivalue, multicolumn problem? If so, how will you deal with it?

E. Do these data have the inconsistent data problem? If so, how will you deal with it?

F. Do these data have a null value data problem? If so, how will you deal with it?

G. Do these data have the general-purpose remarks problem? If so, how will you deal with it