SwiftCo. is a delivery company. The employees are paid percentages of the delivery fee based on their rating. You are asked to  application for the SwiftCo. , and you are in charge of database design and implementation. They want to track the number of packages delivered per day by each employee and the number and weight of the packages delivered for customers. The company wants to generate the employee paychecks as well. Business Rules: 1. The application should store the first name, last name, job rating, employee ID, address and phone number for each employee. 2. Your design should store weight and delivery date for each package. 3. The address of customers is saved in the system, and the packages will be delivered just for the customers. 4. The number of packages delivered per day by each staff must be calculated. 5. The number of packages delivered for each customer per day must be calculated. 6. Each employee has a rating (there are four ratings : Level 1, 2, 3, and 4) 7. An employee will be paid for each delivery based on his/her rating. For example, if an employee's rating is level 1, he/she will be paid 2% of the delivery fee for each delivery. Level 2, 3 and 4 will be paid 3%, 4% and 5% respectively. These percentages are saved as PayRate. 8. A package must have only one Delivery associated with it. A. Normalization (50 Points) • Currently the Urban company is keeping track oftheir data in a spread sheet file. Here is the name of the columns: ‐ CustID (Customer ID) ‐ CustName (Customer Name) ‐ CustAddress (Customer Address) ‐ CustPhone (Customer Phone number) ‐ DeliveryDate ‐ Weight (Weight of the related delivery) ‐ Fee (Delivery fee) ‐ EmpID (Employee ID) ‐ EmpName (Employee Name) ‐ EmpAddress (Employee Address) ‐ EmpPhone (Employee Phone number) ‐ EmpRating (Employee's rating) ‐ PayRate (Pay rate associated with the employee's rating) • Verifying that you have separated all columns into the smallest unit of data • Identifying the Functional Dependencies to separate the attributes into related Entities as necessary. • Assigning each resulting Table, a Primary Key • Including Foreign Keys in the related tables and indicating referential integrity • For your assignment in this step, you should clearly define the dependencies then 1NF, 2NF and 3NF B. ERD (25 Points) • Using your normalized tables (3NF), create the corresponding E-R Diagram in Drawio (Crow's Foot) • Specify the primary keys • Specify the Connectivity, and Cardinality • For this section of the assignment insert the exported JPEG image of your ERD in the word document C. Schema Design (25 points) • Draw schema for your ERD (All the tables with attribute names). • Schema should include all the attributes and primary key should be underlined. • For each table specify the foreign key. D. DDL (50 Points) •  schema (database) in MySQL and insert some data. (Some random data would be fine) • Reverse engineer your schema in MySql and compared it with your ERD (Watch the video in final project folder). Note: In the tutorial video the file was exported as PDF, but you should export it as a PNG file. A PNG file is an image file, so, you can insert it in your  word document. • You should copy and paste all the script used for creating the tables and inserting the data in your word document. DML (50 Points) • query to calculate the paycheck for each employee. •  query to retrieve the total weight of the packages that delivered to each customer. • Copy and paste the text of the query. • Screen shot of the result table.