SQL Queries, Database Design and Normalization

i, I need this assignment prepared at a distinction level (70%+), so please focus not only on correct answers but also on strong academic explanation and structure. For Assignment 1 (SQL Queries): Include the correct SQL queries. Add screenshots from MySQL Workbench showing execution and results. Provide clear explanations of why each query is written that way. Explain concepts like INNER JOIN, LEFT JOIN, multiple joins, and how they work logically and from a business perspective. For Assignment 2 (DDL & DML): Clearly justify the choice of data types (INT, VARCHAR, etc.). Explain why PRIMARY KEY is used and its importance. Explain NOT NULL constraints and how they ensure data integrity. When performing joins for PAYMENT_DETAILS, explain referential integrity and table relationships. Include screenshots of execution. For Assignment 3 (Normalization Very Important): Start with an introduction explaining normalization and its importance. Create an unnormalized library table first and explain the problems (redundancy, update anomaly, insert anomaly, delete anomaly). Then apply 1NF, 2NF, and 3NF step by step. Show before-and-after tables for each stage. Clearly explain partial dependency and transitive dependency. Include a simple ER diagram or structured relationship diagram. Add critical evaluation on how normalization improves data integrity, reduces redundancy, and enhances query performance. Also mention the trade-off of excessive normalization. Referencing: Use proper Harvard referencing style. Include 58 credible academic references (textbooks or journal articles). Avoid Wikipedia or generic websites. Formatting: Proper headings and academic tone. Logical flow and structured explanation. All screenshots must be clear and readable. Please make sure the work is analytical, not just desrptive, and written in a natural academic style. One ZIP folder containing: 1. Word document 2. SQL script file (.sql) 3. ER diagram image (if separate) 4. Any additional supporting files used