AHREND TRUCKING, INC.

1
AHREND TRUCKING, INC.

• ERIK GANO
• CHEN OU
• JANA ROWE
• CHRIS TURAN

2
Sample Input Inventory

• Inventory_ID Make Transmission Year
  Mileage
• 0001 Peterbilt 12-speed
  1998 65,000
• 0002 Mercedes 15-speed
  1999 40,000

3
Sample Input Customers

• Customer_ID Name Street City
  State ZIP Phone
• C0001 Trucks R Us 123 Baker Rd
  Norman OK 73069 405-321-9080
• C0002 Semi, Inc. 948 Car
  Way Tulsa OK 76145 918-674-3561

4
Sample Input Suppliers

• Supplier_ID Name Street City
  State ZIP Phone
• S0001 Insure Co. 13 Casualty
  St. Norman OK 73019 405-4476010
• S0002 Tow Co. 121 Ripoff
  Ave. Tulsa OK 76113 918-616-9871

5
Sample Output Invoice

• Customer_ID C001 Date 6/25/1999
• Inventory_ID 0001 Amount 75,000.00

6
Mileage
Year
Transmission
Customer_ID
Name
Make
City
INVENTORY
CUSTOMER
Inventory_ID
State
ZIP
Supplier_ID
Phone
SUPPLIER
Phone
Name
ZIP
State
City