Question: D. Identify the tables and fields that would be a database that stores information for the purchase order form shown in the Figure below. (Note:
D. Identify the tables and fields that would be a database that stores information for the purchase order form shown in the Figure below. (Note: Extended is the extended cost, or quantity multiplied by cost.) Draw a sketch showing how these tables might relate to one another.

PURCHASE ORDER FORM Date: 11/3/2014 PO No.: 12548 Vendor ID: 87459 Bithlo Books Name: Address: 27 E. SR 50 Bithlo, FL 32158 Title Qty Extended ISBN Cost Database Modeling & Design 10.00 1-55860-294-1 5 50.00 Guide to the Outback 3-12368-998-2 7 12.00 84.00 Sports Heroes of the 1700's 32.50 2-78912-437-5 2 16,25 166.50 TOTAL COST PURCHASE ORDER FORM Date: 11/3/2014 PO No.: 12548 Vendor ID: 87459 Bithlo Books Name: Address: 27 E. SR 50 Bithlo, FL 32158 Title Qty Extended ISBN Cost Database Modeling & Design 10.00 1-55860-294-1 5 50.00 Guide to the Outback 3-12368-998-2 7 12.00 84.00 Sports Heroes of the 1700's 32.50 2-78912-437-5 2 16,25 166.50 TOTAL COST
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
