James River Jewelry Project Case Q4 - Q9) James River Jewelry is a small jewelry shop. While James River Jewelry does sell typical jewelry purchased from jewelry vendors, including such items as rings, necklaces, earrings, and watches, it specializes in hard-to-find Asian jewelry. Although some Asian jewelry is manufactured jewelry purchased from vendors in the same manner as the standard jewelry is obtained, many of the Asian jewelry pieces are often unique single items purchased directly from the artisan who created the piece (the term "manufactured" would be an inappropriate description of these pieces). Assume that James River designs a database with the following tables: - CUSTOMER (CustomeriD, LastName, FirstName, Phone, Email) - PURCHASE (InvoiceNumber, InvoiceDate, PreTaxAmount, CustomerID) - PURCHASE_ITEM (Invoice Number, ItemNumber, RetailPrice) - ITEM (ItemNumber, ItemDescription, Cost, ArtistlastName, ArtistFirstName) 4. Identify the primary key for each table (10 pts). 5. For CUSTOMER table, identify two candidate keys ( 10 pts). 6. For PURCHASE table, identify two super keys ( 10pts). 7. For PURCHASE and PURHCASE_ITEM tables, identify foreign keys ( 10pts). 8. Suggest a possible relationship between CUSTOMER and PURCHASE table. State your detailed rationales to support your suggestion (15 pts). 9. Suggest a possible relationship between PURCHASE and PUCHASE_ITEM tables. State your detailed rationales to support your suggestion (15 pts)