This case study is about a taxi hire company, which requires a mechanism for keeping track of the main business activities. Study the case study carefully and then submit the following: 1. Draw an initial Entity-Relationship model, stating any assumptions you make. You will have to make judgements as to what level of detail is appropriate, by taking into consideration the requirements of part (3) below. (25%) 2. Normalise the Sample Contract Report (Fig 1) to arrive at third normal form entities. Show all the steps of normalisation clearly. State any assumptions. The third normal form entities are only a subset of all the entities needed. (10%) 3. Implement and submit adequate documentation for the following: (a) Create all the database tables needed for implementing the CabsOnDemand system from your ER model, and populate them with appropriate data of your choice. (b) Produce the following SQL code and output: · All the queries Q1 – Q10 – show all code and output separately and label carefully. (55%) 4. Discuss, in your view, the overall conclusion about the coursework. You should submit your own critical assessment of the coursework. The evaluation should include a discussion on how the coursework has reinforced your appreciation of the techniques and processes employed in undertaking a database project. In addition the evaluation should include a wider discussion on topics such as: · How the 'Databases' module relates to the other modules on your current course. · How the knowledge and skills taught on the module and/or course, relates to your previous experience as a student and/or employee. The appropriateness of the knowledge and skills taught on the module for future employment