Design and create a relational database schema $($called KnightHardwareDb$)$ for the sales order entry application. That is$,$ using Management Studio or script, create the above four tables in the database considering the relationships between tables.

$$ One$-$to$-$Many: Customers $--$ Orders

$$ One$-$to$-$Many: Orders $--$ OrderDetails

$$ One$-$to$-$Many: Parts $$ OrderDetails

Insert the data in the above tables into the four tables.

Export and turn in the database script, knight$\_$hardware$\_$db$.$sql

Export and turn in the database$$s E$-$R diagram, knight$\_$hardware$\_$db$.$png$/$jpg