ASSESSMENT DESCRIPTION:This assessment is an individual Project. You will use the following scenario to work on and complete all of the required tasks.SCENARIO: Sparkling CoSparkling Co provides...

ASSESSMENT DESCRIPTION:This assessment is an individual Project. You will use the following scenario to work on and complete all of the required tasks.SCENARIO: Sparkling CoSparkling Co provides home/office cleaning services. The company manages information about customers in an excel sheet that contains customer number, customer number and address. For every customer, they store information about service provided, that includes yearly clean, monthly clean, or weekly clean. The customers can be one-time customers or can be regular customers that requires services repeatedly. One time customer is charged instantly but for permanent customers, the billing is carried out once in a month. The charges for yearly clean, monthly clean and weekly clean are different. The number of hours that an employee spent on clean also varies from property to property.The data that manger stores is as followsSample data about properties and services collected by the Lawn Mowing Pro is shown in Figure 1 below.Figure 1 shows data about Sparkling Co customers, employees and services.Rather than using a spreadsheet, the manager has asked you to design and develop a database for the company, using the sample data to get started with and the following basic business rules to be maintained. The rules are limited to given below. Use your knowledge of businesses in general to develop the system. A customer can receive many services. Each property can have more than one type of services. One type of service can be provided to many properties. An employee can do zero or many services Each service is done by one employee.Tasks to be completed:Assessment Brief Version 2: 21st March 2022Page 2 of 5Kent Institute Australia Pty. Ltd.ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 TEQSA Provider Number: PRV12051 a. Create a dependency diagram using Figure 1. The dependency diagram must have proper labels for all functional, partial and/or transitive dependencies, if there are any.b. Break up the dependency diagram you drew in (a) to produce dependency diagrams that are in 3 NF and also write the relational schemas for the table in 3NF. Make sure the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure that there are no multivalued attributes, that the naming conventions are met, and so on.c. Develop an E-R diagram based on the task done in (b). Use crow-foot style and specify entities, attributes, relationships, and multiplicity. Justify the decisions you make regarding minimum and maximum cardinality.d. Identify different type of entities and relationships, for instance, strong and weak entities/relationships. Specify how you have represented them in ER diagram created in c.e. Create a database using MySQL, with primary keys, foreign keys, and other attributes mentioned for each table developed in (d) using proper constraints. In your report mention any specific constraints and implementation details.f. Create SQL statements to satisfy the following:1. Write SQL statements to insert at least 7 rows of data into each of the table created in task (e).You may use the sample data provided in Figure 1 for this task.2. Write SQL statements to list all columns of all tables.3. Write SQL statements to list the name and mobile phone for all employees.4. Write SQL statements to list the name and address for all owners.5. Write SQL statements to list properties in NSW and services they received.6. Write SQL statements to determine how many times a service was received at post code 2762.7. Write SQL statements to list name of employees who have provided weekly service to anyproperty.8. Write SQL statement to list total service charge amounts for Brian Cooper. Use somemathematical functions.ASSESSMENT SUBMISSION:You need to submit three things: a) the report, b) The ERD, the normalisation and the dependency diag