Part$1$: Database design Consider the following Supply Chain information system description. The system should support a collaborative supply chain composed of suppliers, manufacturers, shippers and end customers. ltems of different kinds are being moved in the the supply chain. Manufacturers use ltems of materials to manufacture ltems of products for customers. Suppliers supply ltems of materials to manufacturers; they also supply Items directly to Customers. Shippers $($e$.$g$.,$ UPS, Fedex etc$)$ move items from one business entity $($supplier$,$ manufacturer, customer etc$)$ to another. ltems have a unique id and weight. Every business entity $($suppliers$,$ manufacturers, customers etc.$)$ is identified by its id$,$ and has a shipping location $($to be used by Shippers for shipping orders$)$ address, phone, web location, and contact information Every product item $($e$.$g$.,$ a table$)$ has a number of associated material$/$part items in certain quantities necessary to produce $1$ unit of the product item. For example, a table product item, requires $1$ table top item, $4$ leg items and $8$ screw items. Suppliers supply ltems, using price per unit, which may vary among different Suppliers for the same ltem uppliers have volume discount applied on the dollar amount computed based on price per unit. Volume discount is described by a percentage of deduction for amount above a predetermined bound Manufacturers produce product ltems; this production has an associated setUpCost and product cost per unit.Manufacturers may offer volume discounts to customers applied the same way suppliers apply volume discounts. Shippers price shipping services per pairs of $($source$,$ destination$)$ pairs, where sources and destinations are shipping locations of business entities. The pricing of each shipper is based on the total weight of shipment from source to destination, using price per lb$,$ and a volume discount applied on the total dollar amount.. Customers have demand quantity for certain ltems. The orders are recorded separately for shipping, manufacturing and supply Shipping orders capture information about a shipper, sender$,$ and receipient $($who are business entities$)$ and the ltem being shipped, and record the quantity of the ltem shipped Manufacturing orders capture information about a manufacturer, a manufactured ltem and the ordered quantity; and Supply orders capture information about a supplier, Item and the quantity supplied. $1.$ Create an ER diagram, and specify all integrity constraints. If some information is missing, suggest additional assumptions and briefly explain their rationale. $2.$ Translate the ER design into CREATE TABLE definitions using SQL$,$ and add CHECK constraints as necessary