Instructions: Based on the scenario presented below about Express Logistics $($EL$)$ and the attached data file $($which is primarily intended to supplement the information provided in the scenario$),$ do the following in Lucidchart: $(1)$ Create a conceptual model that includes the correct PKS $(50$ pts$)(2)$ Transform your conceptual model to a normalized relational$/$logical model in $3$NF $($where possible$)$ that is complete with all necessary keys and constraint notations $(50$pts$)$and $(3)$ Export both diagrams into a single PDF and upload it to Canvas via the SID Note $1$: Please affix a label to each diagram to make it easier to determine which is the conceptual model and which is the logical model Note $2$: Please ensure that each diagram is restricted to a single page and that all text and symbols are clearly readable. Think professionalism first. Scenario: Express Logistics $($EL$)$ is a $3$PL that works closely with its multitude of clients to ensure on$-$time delivery of customized $,$ made$-$to$-$order goods $,$ while providing a high level of end$-$to$-$end visibilityAs a nearly full service $3$PLEL specializes in warehousing, transportation, shipping, and receiving. owns several warehouses in which it stores many of the components one of its primary clients BradSongInc. $($BSI$),$ needs to manufacture custom products for its customers. BSI is a direct to consumer company and deals with neither retailers nor wholesalers. Once BSI receives a customer order, it converts it to a sales order and passes the sales order along to EL to expedite the shipping processEL typically receives notice $48-$hours prior to the order$($s$)$ being ready for shipment. This typically leaves EL $24$ hours to fulfill the order, as BSI has a standing policy to fulfill all orders within $72$ hours of receipt. As part of the sales order data $,$ EL receives the following information from BSI: sales order #$,$ customer ID$,$ order date, estimated pick up date, and customer promised date $($estimated delivery date$).$ EL supplements this information with the date it receives the sales order from BSI $.$ Although BSI strips all product related data from the sales order before transmitting it to EL$,$ EL uses some of the sales order data to retrieve vital customer information $($i$.$e$.,$ customer name delivery address, and special delivery and handling instructions$),$ which is stored elsewhere, that would have a bearing on its fulfillment activities. Although EL has limited direct contact with the customer, it maintains a real$-$time copy of BSI's customer list $($customer ID$,$ first and last name $,$ street address, city state, and zip code$).$ EL also maintains impeccable records of its shipments including a unique shipment ID$,$ service type, number of packages loaded onto the vehicle, etc. All details are required before a shipment can be released