Question
I have put the questions in the comments-
THE QUEEN ANNE CURIOSITY SHOP PROJECT QUESTIONS()Chapter Two) Submission: A single .doc or .pdf file to Dropbox on ANGEL Note: Spelling check in Microsoft Word may block people seeing the underline for primary key. Please turn off the spelling check for your Word document or submit your answer as a PDF file. The spelling check for this Word document has already been turned off. In this assignment, you do NOT need to show the full tables in your answers. To answer Question B.4, D.4 and E, you just need to use the "relation representation" we discussed in class (use underline and italic to denote primary key and foreign key, respectively). Assume we have following SALE table and PURCHASE tables. Table 1 SALE Table Table 2 PURCHASE Table
Explanation / Answer
the appropriate primary key can be
customer name, item name.
because, based on customer name we can get the customer phone no. and address.
both customer name, item name will give the sales details, (assuming the customer can't sell the same item after some days).
if the customer can sell the item of same name after some days, the primary_key can be
customer name, item name, sale date
(assuming customer won't sale same item for different prices on same day)