Question 2 In your new job as a backend developer for ship2europe.com - a shipping company - you are responsible for implementing a MySQL database system. Your task is to design and develop a web application allowing company workers around Europe to perform the following tasks: Create a customer profile given the following attributes: customer name, username, password, email and address. Create shipments defining cargo type, collection date, delivery date, pick-up point, destination, weight and volume Additional attributes are needed to update the shipment status based on how far through is the delivery process using a 0-5 scale i.e. O is at pickup point and 5 is at final destination. Also, in a text field to provide feedback regarding the delivery outcome e.g. cargo was damaged or missing etc. Create distribution_centres handling the shipments attributed by freight storage capacity, arrival and departure dates of shipments. The customers can have several shipments and each shipment is destined to one distribution centre. (a) For the ship2europe database, create an Entity Relationship Diagram (ERD). Entities, relationships between entities, and appropriate association types should all be included in your diagram. Use only three tables in the diagram. [9] For each table of the database you designed in phase 1(a), list the primary and foreign keys. (b) [7] (c) Create two of the tables you mentioned in your answer to part 1(a) with the appropriate SQL code. [14]