6 Final-Fall 2017 Pags Background Super Cy Sleds sells sleds and supplies throug
ID: 2593962 • Letter: 6
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- CashDisbursementExplanation / 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