6 Final-Fall 2017 Pags Background Super Cy Sleds sells sleds and supplies throug

Question

6 Final-Fall 2017 Pags Background Super Cy Sleds sells sleds and supplies throughout the Midwest. can be used to race slide down the hill Cy Sleds uses this informat near the Knoll. Super Cy Sleds uses the expenditure database shown Table Attributes ProductWeight, ReorderPoint,ProductNumber,Description UnitCost, UnitPrice, QuantityOnHand BankID, Balance, OrderAmount, EmployceNumber, Terms PurchaseOrderNumber, OrderDate, VendorNumber Inventory Cash PurchaseOrder ReceiveGoods CashDisbursement Employee Number VendorNumber, Receipt Number. urchaseOrderNumber, ReceiptDate, ReceiptTotal VendorNumber, EmployeeNumber, AccountNumber Di DisbursementAmount EmployeeName, Datelired, BirthDate, EmployeeNumber Salary, ManagerNumber, EmployeeCity VendorName, Vendorstreet, VendrCity, Vendorstate. VendorZip, VendorNumber, VendorPhone Employee Vendor Inventory-PurchaseOrder OrderQuantity, ProductNumber, PurchaseOrderNumber Inventory-ReceiveioodsQuantity Shipped, Produst Number. ReceiptNumber Total Received, Receipt Number, DisbursementNumber ReceiveCGoods- CashDisbursement

Explanation / Answer

A. Primary key is the one that is unique and can be used to distinguish between the record.

Receive goods cash disbursement - Disbursement number

Cash - Account number

Employee - employee number

Purchase order - purchase order number

Inventory purchase order - purchase order number

Receive goods - receipt number

B. Foreign key is the one that is used to identify the relationship between the two tables

Vendor - Vendor number

Receive goods - receipt number

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.