Consider the following file structure of a database.

$(1)$ Discuss the data redundancy and data anomalies exhibited by the file structure. $5$pts

$(2)$ How many tables would you use to eliminate the problems? Draw the table structures you would

recommend. In addition, show the example records in new tables. $20$pts

You may add more attributes to your new tables, as appropriate.

Orders

Order$\_$

ID

Order$\_$

Date

PartID Part$\_$desc QtySold ListPrice SoldPrice$1$ CusId CusLN

$124899/23/22$ AX$12$ Iron $1115\mathrm{.}00$ $$15\mathrm{.}00101$ Wang

$124914/23/22$ BT$04$ Gas Grill $1150\mathrm{.}00$ $$139\mathrm{.}99201$ Smith

$124914/23/22$ BZ$66$ Washer $11000\mathrm{.}00$ $$989\mathrm{.}99201$ Smith

$124945/12/22$ CB$03$ Bike $4300\mathrm{.}00$ $$279\mathrm{.}99301$ Abadi

$124955/15/22$ CX$11$ Blender $222\mathrm{.}95$ $$22\mathrm{.}95401$ Kumar

$1249812/6/22$ AZ$52$ Dartboard $214\mathrm{.}00$ $$12\mathrm{.}95501$ Harking

$1249812/6/22$ BA$74$ Basketball $426\mathrm{.}50$ $$24\mathrm{.}95501$ Harking

$125001/6/23$ CX$11$ Blender $122\mathrm{.}95$ $$19\mathrm{.}95601$ Pearson

$125001/6/23$ BT$04$ Gas Grill $1150\mathrm{.}00$ $$129\mathrm{.}99601$ Pearson

$125043/6/23$ CZ$81$ Treadmill $2450\mathrm{.}00$ $$325\mathrm{.}99101$ Wang

$1$ SoldPrice is the price after a discount.