Convert the following SALE object $($file$),$ which is in $0$NF$,$ into $3$NF$.$ The following list

defines the data fields:

How to create this as an ERD? Thank you

Convert the following SALE object $($file$),$ which is in $0$NF$,$ into $3$NF$.$ The following list defines the data fields:

$-$ Date: date of sale

$-$ Invoice$\_$No: sale invoice number

$-$ Customer$\_$No: customer identification number

$-$ Name: customer name

$-$ Addr: customer address $($including city, state, zip$)$

$-$ Credit$\_$Lim: customer credit limit

$-$ Current$\_$Bal: customer current credit balance owed

$-$ Part$\_$No: inventory part identification number

$-$ Descr: inventory part description

$-$ Price: inventory part price

$-$ Qty$\_$OH: inventory part quantity on hand

$-$ Salesperson$\_$No: salesperson identification number

$-$ Sales$\_$Name: salesperson name

$-$ Comm$\_$Rate: salesperson commission rate

$-$ YTD$\_$Sales: salesperson year to date sales amount

$-$ Qty$\_$Purch: sale quantity purchase

The SALE object is represented as:

SALE$($Qty$\_$Purch,Date,Invoice$\_$No$,$Custoner$\_$No$,$Salesperson$\_$No$,$Part$\_$No$,$Price,Sales$\_$

Design an ERD and implement it as a MS ACCESS database schema $($relationships with referential integrity enforced$)$ making sure that each table satisfies INF, $2$ NF $,$ and $3$ NF $.$