Question: Using SQL Developer, Engineer a relational schema from the ER diagram (Logical Model). Using all the Data from the Invoice below: ***** Invoice******** CHICAGO HARLEY-DAVIDSON,
Using SQL Developer, Engineer a relational schema from the ER diagram (Logical Model). Using all the Data from the Invoice below:
***** Invoice********
CHICAGO HARLEY-DAVIDSON, INC Invoice Number: 34622
16868 N. WESTERN AVE DATE: 10/11/2003 TIME: 12:31 PM
CHICAGO, IL 60645 Console: 010 Sold By: RPF
Phone: (773) 3389-6868 FAX: (773) 338-8868 Tax ID: IL RATE:.087500
------------------------------------------------------------------------------------------------------------------------------------------
Customer Number: 30086
SPEED RACER 243 S. WABASH AVE
CHICAGO, IL 60604
Phone: (312) 555-1212 Work (000) 000-0000 Ext:
Fax: (000) 000-0000 Tax Exempt: N
P.O. Number Tax Number:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Item Number Description Del SO Retail DCT Desc Extended Qty Qty Price Price Amount
69112-95B HORN KIT, CHROM 1.00 79.95 15.99 63.96
------------------------------------------------------------------------------------------------------------------------------------------
Deposit Down Pmt: 0.00 Total Amount Due 69.96
Deposit Pmts Applied 0.00 =========
Layaway Pmt Made: 0.00 Cash 0.00
Layaway Pmt Applied 0.00 Ck No: 0 Check: 0.00
SO/Layaway Balance Due: 0.00 Type: MC EWxp 11/04 Credit Card: 69.96
(Including Applicable Taxes) XXXX-XXXX-XXXX-0866 Gift Certificate: 0.00
Item Total: 63.96 Total Received: 69.96
Shipping Charge: 0.00 Less Change: 0.00
Flat Charge: 0.00 On Account: 0.00
Discount(s): 15.99 Total: 69.96
Deductible(s): 0.00 ============
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
