UPS prides itself on having up-to-date information on the processing of current location of shipped item. To do this, UPS relies on a company-wide information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination and final delivery date. Shipped items are received into the UPS system., at a single retail center. Retail centers are characterized by their type (store, drop off box, etc..), unique lD, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck delivery). These transportation events are characterized by a unique schedule Number, a type (e.g, flight, truck) and a delivery Route. Create a Crow foot diagram that captures this information about the UPS system. Be certain to indicate keys and cardinality constraints. Convert it into a relational database schema taking care of resolving any design issue. Write the SQL definition of the relations corresponding to your design on 2 and answer the following queries: Retrieve the item numbers of items whose insurance is above $100 and destination is "Houston" Retrieve the delivery date and delivery route of item number: 123 Retrieve the retail centers and delivery date for every item whose weight is less than 3lbs. Retrieve the destination of all items received by retailer center 45 and the type of transportation event. Create a view in which a person can enter their item number and locate its delivery route. Draw the query trees for the above queries