Analyze a senario and design, develop and test a database in My SQL using PHPMyAdmin.

Your task is to analyze a scenario, and design, develop and test a database in MySQL using PHPMyAdmin. You are provided with the scenario (below) and supporting documents. It is your job to analyze the data requirements provided in the scenario and design and develop a relational database to meet the client needs. You will also need to add data and create SQL queries to provide results suitable for reporting. The intent of this assignment is to give you experience in design and development. It is based on a fictitious scenario. Your focus will be to:  produce a fully normalized database design, modeled in an EERD, showing business rules;  Develop entities (tables) with correct attributes included;  Demonstrate supertypes and their associated subtypes;  Demonstrate normalised relations;  Make relational joins to ensure this prototype works;  Produce evidence of correct working via database queries and screenshots of result sets