To analyse and comprehend a provided ER diagram and Database Schema To implement a database based on the provided ER diagram and Database Schema To manipulate the data in the database To write required SQL statements to query the database. A. Understanding and Implementation of the Database Using the supplied schema file, create the database for CQR. The supplied file populates all tables to reflect the content of the artefacts provided in Assignment 1 and is a cut-down version of the practice at the close of business on 15th September 2014. . At this stage, you are to imagine what the state of the database would be at the close of business on the next day, subject to the requirements of this task, and all subsequent tasks. Write queries to find out the following: • Find the unused structures e.g. there is one Superannuation client but no Partnership clients on the starter database. • Find the unused sectors; • Find the unrequested services; • Find the unused billing cost types; • Find domains for which there is none or only one current employee with that expertise; • Find the minimum billing rate for each employee type for the most recent billing rate effective date