数据库习题3-19答案.docx

ANSWERS TO JAMES RIVER JEWELRY PROJECT QUESTIONS数据库JAMES_RIVER_JEWELRY.包括下述4张表:CUSTOMER (CustomerID, LastName, FirstName, Phone, Email)PURCHASE (InvoiceNumber, Date, PreTaxAmount, CustomerID)PURCHASE_ITEM (InvoiceNumber, ItemNumber, RetailPrice)ITEM (ItemNumber, Description, Cost, ArtistName)其中参照完整性约束如下：CustomerID in PURCHASE must exist in CustomerID in CUSTOMERInvoiceNumber in PURCHASE_ITEM must exist in InvoiceNumberin PURCHASEItemNumber in PURCHASE_ITEM must exist in ItemNumber in ITEM假设CustomerID of CUSTOMER, ItemNumber of ITEM, InvoiceNumber of PURCHASE, and ItemNumber of PURCHASE_ITEM 都是