Pack N ShipPack N Ship is a convenience based parcel assistance?ompany. Pack N Ship’s primary service offering is to pick up and drop off packages on a timely basis. Pack N Ship does this directly to a customer’s exact location. Pack N Ship?irst picks up items to be shipped from a customer’s door/office/anywhere, packs the items into boxes and drops them off at a local hub. From this hub, Pack N Ship has a partner company that takes each package to a transshipment point and then finally to a drop off hub near the package’s?inal destination. A Pack N Ship driver in that city then, picks up the package and delivers it to the package’s final destination?t a specified time.Pack N Ship drivers are independent and operate on their own schedules. Similar to Uber and Lyft, Pack N Ship drivers?re paid for each package they deliver or pick up. Allocation of drivers is done in real time by offering payments to drivers for their services and routing drivers around to customers and local pickup points accordingly.You are looking to help Pack N Ship answer a few business questions through queries.?o create this database in SAS, use this code (Step1?>?tep2). This will create the Pack N Ship database in your SAS work library.To create this database in MySQL, open?his SQL file?ith MySQL and run it in one of your server instances.There is a?hipments?able that includes:Shipment_ID (Integer) (Primary Key)Shipment_Order_Date (Integer) (In terms of?ays since Jan 1, 2016)Shipment_Delivery_Date (Integer) (In terms of days since Jan 1, 2016)Shipment_Size (Decimal) (In cubic feet)Shipment_Weight (Decimal) (In pounds)Origin_Location_ID (Integer) (Foreign Key) (References to Locations.Location_ID)Destination_Location_ID (Integer) (Foreign Key) (References to Locations.Location_ID)Shipment_Cost (Decimal) (In USD)Transshipment_Point_ID (Integer) (Foreign Key) (References to TSPs.Transshipment_Point_ID)Customer_ID (Integer) (Foreign Key) (References to Customers.Customer_ID)There is??ocations?able for all hubs that includes:Location_ID (Integer) (Primary Key)Location_City (Text)Location_State (Text)There is a?SPs?Trans-shipment points)?able that includes:Transshipment_Point_ID?Integer) (Primary Key)Transshipment_Point_Location_ID (Integer) (Foreign Key) (References to Locations.Location_ID)There is??ustomers?able for all hubs that includes:Customer_ID (Integer) (Primary Key)Customer_Name (Text)Customer_Type (Text)The?ack N Ship?artner company has multiple transshipment points located in various places?round the United States. These are placed in the TSPs table and are used to verify the?ransshipment_Point_ID in the Shipments table. At the same time, the Transshipment_Point_Location_ID is verified in the Locations Table. While this happens external to the company, Pack N Ship has found it important to monitor this to keep customers updated on any particular shipment’s progress.The senior supply chain team members at Pack N Ship have heard about your skills with SQL and all have requests for you.Part 15.0 points possible (graded, results hidden)Christopher Campbell, the executive vice president of supply chain at Pack N Ship, wants to find out which hub locations exist in the state of Indiana. (Note that ‘hub locations’ are different from ‘transshipment locations’).Select all of the locations that apply.South BendIndianapolisCarmelFishersBloomingtonHammondFort WayneGaryEvansvilleMuniceunansweredSaveSave your answerSubmitYou have used 0 of 2 attemptsSome problems have options such as save, reset, hints, or show answer. These options follow the Submit button.Part 25.0 points possible (graded, results hidden)Cindy Brown, the associate director of supply chain at Pack N Ship, wants to know which shipment_ID had the fourth highest individual Shipment_Cost?Enter the correct answer below.?unanswered?SaveSave your answerSubmitYou have used 0 of 2 attemptsSome problems have options such as save, reset, hints, or show answer. These options follow the Submit button.Part 35.0 points possible (graded, results hidden)Edward Brooks, the president of supply chain at Pack N Ship, wants to determine what is the total cost of all shipments in the database that had a shipment?estination?n Oxnard (Location_City)?Enter the correct answer below. Round to two decimal places.?unanswered?SaveSave your answerSubmitYou have used 0 of 2 attemptsSome problems have options such as save, reset, hints, or show answer. These options follow the Submit button.Part 45.0 points possible (graded, results hidden)Virginia Morgan, the deputy director of supply chain at Pack N Ship, wants to find out which Shipment?rigin?ity has a total shipment cost (sum of all shipments out) of $1195.01 to date (rounded to two decimal places)?MySQL bug: MySQL has a bug where it does not add up long columns with decimal values properly. While very close, the column summation can be off by as much as “0.0001”. Consider using a “round(GiveValueHere,2)” statement to solve this problem with MySQL.Select the correct answer.LancasterPearlandLos_AngelesMcKinneyunansweredSaveSave your answerSubmitYou have used 0 of 2 attemptsSome problems have options such as save, reset, hints, or show answer. These options follow the Submit button.Part 55.0 points possible (graded, results hidden)Ashley Powell, the VP of supply chain at Pack N Ship, wants to find out which Customer (by Name) shipped a total weight of 2277.06 pounds to date (rounded to two decimal places)?MySQL bug: MySQL has a bug where it does not add up long columns with decimal values properly. While very close, the column summation can be off by as much as “0.0001”. Consider using a “round(GiveValueHere,2)” statement to solve this problem with MySQL.Select the correct answer.ScrewyNutsNBoltsTraderJanesIronWorksNone of the AboveunansweredSaveSave your answerSubmitYou have used 0 of 2 attemptsSome problems have options such as save, reset, hints, or show answer. These options follow the Submit button.Part 65.0 points possible (graded, results hidden)Bob Loblaw, Warehouse Operations Supervisor, wants to know: In cubic feet, what is the largest shipment in the database from our customer Targot?Enter the correct answer below. Round to one decimal place.?unanswered?SaveSave your answerSubmitYou have used 0 of 2 attemptsSome problems have options such as save, reset, hints, or show answer. These options follow the Submit button.Part 75.0 points possible (graded, results hidden)With great excitement, Bob Loblaw makes a pronouncement: “I knew it!…” With respect to shipment size, which of the following statements by Bob Loblaw would be correct?Choose the best answer.Targot’s largest shipment was in the 10 smallest shipments in the pack_n_ship database.Targot’s largest shipment was in the 10 largest shipments in the pack_n_ship database.Targot’s largest shipment was the smallet shipment in the pack_n_ship database.Targot’s largest shipment was the largest shipment in the pack_n_ship database.Computer ScienceEngineering & TechnologyMYSQL ECE 109
Get a plagiarism-free order today we guarantee confidentiality and a professional paper and we will meet the deadline.