please answer #4. i already have everything else.

ERD can be drawn by hand. However, it must be scanned and uploaded to a digital file (Words, PPT, PDF, or JPEG only). FedEx wants to develop a company-wide information system. Shipped items are the heart of the FedEx product tracking information system. Shipped items can be characterized by item number, weight, dimensions, insurance amount, destination city, and final delivery date. Shipped items are received into the FedEx system at a single retail center. There are multiple retail centers in big cities such as LA NY, etc. Each of the retail centers has one of the four types: FedEx office, FedEx Ship Center, Otfice Depot, and FedEx Authorized Ship Center. Shipped items make their way to their destination via one or more standard UPS transportation events (ex. Flights, ships, truck deliveries). These transportation events are characterized by schedule, a type (eg. flight, truck, ship), and a dellivery route. 1. Please create an Entity-Relationship diagram that captures this information about the FedEx system. - Please identify primary keys, foreign keys, and cardinality constraints. - Please solve many-to-many relationship problems if you have any here. - If you have any assumptions, please identify those assumptions (User-defined constraints). HINT) To do this homework, you should have AT LEAST three entities: Retail Center, Shipped items, and Transportation Event. Please think carefully As I described above, one shipped item belongs to only one retail center. However, the shipped item can have many transportation events Think about the real situation. In the case of international carga the cargo travels across the continent using ships or airplanes and then the cargo travels by ground transportation) 2. After you finish your ERD, please create ER Data Model with ten records in each of the all entities (Be careful, some of the information has been provided already in the text - eg. retail center type: FedEx office. FedEx ship Center, Otfice Depot, and FedEx Authorized Ship Center). 3. Create a Relational Schema for this ERD. 4. If FedEx wants to track the total insurance amount, destination, type of the retailer center, and location of the retailer center where the destination city is LA, how will you as an employee in FedEx write the 5QL code? 1. \begin{tabular}{|l|l|l|} \hline Shipped Item & Retail Center Item Number PK Weight Dimensions Insurance Amount Destination City Final Delivery Date & City PK Type Item Number FK Schedule ID FK \\ \hline \end{tabular} 2. \begin{tabular}{|l|l|l|l|l|l|} \hline Item Number & Weight & Dimensions & Insurance Amount & Destination City & Final Delivery Date \\ \hline IN001 & 9.1oz & 181618 & 0.00 & NY & 10/28/22 \\ IN002 & 10oz & 181618 & 3.24 & LA & 10/30/22 \\ IN003 & 11.6oz & 181824 & 4.34 & NY & 10/21/22 \\ IN004 & 7oz & 181618 & 0.00 & NY & 10/28/22 \\ IN005 & 8.9oz & 181618 & 0.00 & NY & 10/29/22 \\ IN006 & 13oz & 181824 & 5.34 & LA & 10/23/22 \\ IN007 & 1.2lbs & 181824 & 6.70 & LA & 10/22/22 \\ IN008 & 6.4oz & 181618 & 0.00 & NY & 10/29/22 \\ IN009 & 12oz & 181824 & 0.00 & LA & 10/26/22 \\ IN010 & 9.2oz & 181618 & 5.43 & NY & 10/30/22 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline Shipped Item ID & City & Type & Item Number & Schedule ID \\ \hline \end{tabular} 3. Shipped item \begin{tabular}{|l|l|l|l|l|l|} \hline Item Number PK & Weight & Dimensions & Insurance Amt & Destination City & Final Delivery Date \\ \hline \end{tabular} Retail Center \begin{tabular}{|l|l|l|l|l|} \hline Shipped Item ID PK & City & Type & Item Number FK & Schedule ID FK \\ \hline \end{tabular} Transportation Event \begin{tabular}{|l|l|l|} \hline Schedule ID PK & Type & Delivery Route \\ \hline \end{tabular} 4. SELECT SUM (insurance amount), Destination City. Type, and City FROM Shipped ttem, Retail Center WHERE Destination City = LA