Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 COSTStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started