The sales department for an auto parts company uses a database to contain information about customers, items, and orders. The

following relations are used in the database:

Customer: Customer number $($unique$),$ Mailing address, Balance, Credit limit$,$ Discount

Order: Customer number $($unique$),$ Order number $($unique$),$ Ship to addresses $($one per order$),$ Date of order, Item number $($several

per order$),$ Quantity ordered $($one for each ordered item$)$

Item: Item number $($unique$),$ Manufacturing format $($several per item$),$ Quantity on hand for each format, Stock danger level for each

format, Item description

The following functional dependencies apply:

customer$\_$no $$ mail$\_$address

customer$\_$no $$ balance

customer$\_$no $$ credit$\_$limit

customer$\_$no $$ discount

customer$\_$no dots order$\_$no

order$\_$no $$ ship$\_$address

order$\_$no $$ date$\_$order

order$\_$no $$ item$\_$no

order$\_$no$,$ item$\_$no$\}$ quantity$\_$ordered

item$\_$no $$ description

item$\_$no dots manufacturing$\_$format

$\{$item$\_$no$,$ manufacturing format$\}$ dots quantity$\_$on$\_$hand

$\{$item$\_$no$,$ manufacturing$\_$format$\}$ dots stock$\_$danger

Transform these relations into $3$NF$.$ For your answer, list only the $3$NF relations. You don't need to show the transformation steps do

to get the $3$ NF result. The sales department for an

following relations are used in the database:

auto parts company uses a database to contain information about customers, items, and orders. The

$*$ Customer: Customer number $($unique$),$ Mailing address, Balance, Credit limit$,$ Discount

$*$ Order: Customer number $($unique$),$ Order number $($unique$),$ Ship to addresses $($one per order$),$ Date of order, Item number $($several per order$),$ Quantity ordered $($one for each ordered item$)$

$*$ Item: Item number $($unique$),$ Manufacturing format $($several per item$),$ Quantity on hand for each format, Stock danger level for each format, Item description

The following functional dependencies apply:

customer$\_$no $->$ mail address customer$\_$no $>$ balance customer$\_$no $->$ credit$\_$limit customer$\_$no $->$ discount customer$\_$no $->>$ order$\_$no order$\_$no $->>$ ship$\_$address order$\_$no $->>$ date

order

order no $->>$ item$\_$no $($order$\_$no$,$ item$\_$no$)->$ quantity$\_$ordered item$\_$no $->>$ description item$\_$no $->>$ manufacturing format $($item$\_$no$,$ manufacturing$\_$format$)->$ quantity$\_$on $\_$hand $($item $\_$no$,$ manufacturing$\_$format$)->$ stock$\_$danger

Transform these relations into $3$NF$.$ For your answer, list only the $3$NF relations. You don't need to show the transformation steps done to get the $3$NF result.