Chapter 10 page 453
c. Tables, Keys and Attributes for ACF.
Table Name
Inventory-
Order Link
Inventory-
Ship Link
Primary Key Attributes
Item Number
Order Number
Quantity Ordered
Item Number
Invoice Number
Quantity Shipped, Actual Price
Linking Tables
Table Name Primary Key Foreign Key(s) Attributes
Inventory Item Number Description, Warehouse Location, Quantity on
Hand, Reorder Point, On-Order Quantity, Available
for Sale, Supplier Number, Unit Cost, Retail Price
Cash Account
Number
Take Order
Ship Product
Receive Cash
Invoice Amount, Shipped Date, Due Date, Close
Date,
Invoice
Number
Order Number
Customer Number
Employee Number
Order
Number
Inquiry Number
Customer Number
Employee Number
Order Date, Promised Date, Terms Of Trade,
Remittance
Number
Customer Number
Employee number
Account Number
Customer Check Number, Date, Amount
Balance
Supplier
Customer
Employee
Customer Number
Name, Address, Line of credit, Available Credit,
Current Balance, Last Payment Date,
Employee Number SSN, Name, Address, Date of Birth, Job Title,
Data Hired, Pay Rate, Vacation Time Accrued
Supplier Number
Name, Address, Terms of Trade, Vendor lead
time, Carrier used, On-time delivery record,
Incomplete shipments record, Damaged shipments
record, Price disputes record