Answered step by step
Verified Expert Solution
Question
1 Approved Answer
James River Jewelry Project Case Q4 - Q9) James River Jewelry is a small jewelry shop. While James River Jewelry does sell typical jewelry purchased
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started