Learning Outcomes: LO1. Learn the concepts of database and database management systems along with the concepts and approaches of database design, administration and management. LO2. Learn the principals and science behind querying the data from a database management system to use for business analytics and implement the queries to retrieve the data from MySQL. LO3. Write advanced SQL queries to manipulate, wrangle and derive insights from large database systems. Assessment Criteria: Weighting 100% 3000 words Tasks (All tasks are equally weighted): This assignment aligns with the unit's objectives of equipping learners with the skills to design a database management system using MySQL, implement basic and complex SQL queries, and apply theoretical concepts like the CAP theorem in the context of a practical database project. In this project, you will work on designing and implementing a database system for a telecommunications provider. The project will involve creating an Entity-Relationship (ER) diagram, implementing it in MySQL, and demonstrating your skills through SQL queries and theoretical discussions. Project Phases: 1. Database Design for the Telecommunications Provider: (LO1) Define the scope and objectives of the database for the telecommunications provider, considering aspects like customer information, service plans, usage data (calls, SMS, data), billing information, network elements, and potentially customer support interactions. e Create a comprehensive Entity-Relationship (ER) diagram that represents the database structure. Use appropriate entities, attributes, relationships, and cardinalities. e Provide a written explanation of your design choices and the rationale behind them, considering the specific needs of a telecommunications provider. 2. Database Implementation: (LO1) e Implement the database design for the telecommunications provider in a MySQL database management system. e Create tables, define relationships, and establish constraints (e.g., primary keys, foreign keys). * Populate the database with sample data that reflects typical telecommunications provider scenarios (e.g., customer subscriptions, plan details, call detail records, data usage sessions, monthly bills). 3. SQL Query Writing (Applying - Level 3): (LO2, LO3)