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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!