write my assignment 4281

Consider the following and create schema for 0NF to 3NF:

0NF:

1NF:

2NF:

3NF:

Each order has a virtual id number and can have many line items.A customer can receive a discount that is put in his or her record, but they might not have adiscount.Customers can place many orders and products can be ordered by many customers.ORDER FORMDATE:21 APRIL 2013ORDER # 889520R & J’s GrillSHIPPING ADDRESS:17 THOMPOSON LANE228 HIGH STREETKELLOGG, IOWA 50135KELLOGG, IA50135PHONE #: (641) 526-3184CUSTOMER DISCOUNT: 5%ITEM # PRODUCT CODE_DESCRIPTIONQTYBACKORDEREDFILLED PRICE/UNITAMOUNTAB155STAINLESS REFRIDGERATOR824.001648.00CB235GAS RANGE GRATE2N120.00240.00ZT351BENCH SEATINGN15150.00300.00TOTAL2188.00DISCOUNT109.40AMOUNT OWED 2078.60