Develop a database schema on MySQL from the information givenbelow. Assign appropriate data types to all fields. Please makesure the pairs of primary and foreign keys are identified and haveidentical data types.

A store that sells household appliances wants a database totrack special orders. Most of the items ordered are large and fromhigh-end vendors so they are too expensive to stock in the displayroom. Also, customers tend to order them when they are remodelingtheir houses so they do not want the items immediately. Instead,they need to be ordered and scheduled for delivery on a specifieddate. Of course, construction delays are common so the managersalso need the ability to delay delivery by a few days or weeks whennecessary. Most of the items are ordered directly from themanufacturers and they are good at scheduling deliveries, butsometimes highly-customized items need to be tracked down otherstores across the nation.

If the item is not available from the manufacturer, the locationis specified in terms of the store and contact information.Typically, it is ordered immediately and held in storage untilneeded; because it is too hard to find a new version so safer tobuy it now.

Customer Name Address (delivery location) City, State, ZIP Order Date Desired Delivery Date Comments Salesperson Deposit Amount $ Item Manufac/Loc. ModelID Color Descrip Size Price Actual Deliv Delivery comments and changes Contact Date Item (or All) Employee Comments New Deliv. Date

Customer Name Address (delivery location) City, State, ZIP Order Date Desired Delivery Date Comments Salesperson Deposit Amount $ Item Manufac/Loc. ModelID Color Descrip Size Price Actual Deliv Delivery comments and changes Contact Date Item (or All) Employee Comments New Deliv. Date Show transcribed image text