Database Development and ER diagram

I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10 must choose Scenario 10. If you work on a different scenario, your assignment will not be marked. Your database should provide a comprehensive solution that allows for efficient data retrieval, updates, and integrity. Deliverables: a. Entity-Relationship Diagram (ERD): Construct a detailed ERD that represents the scenario. Your ERD should include all necessary entities, relationships, attributes, and primary keys. Use appropriate notation to indicate relationships, cardinality, and participation constraints clearly. b. Normalization: Provide a detailed explanation of how you applied normalization techniques to ensure that your database design is free of redundancy and update anomalies. Your submission should include: The process of normalizing your database design to at least 3NF (Third Normal Form). Identification of any potential issues you encountered during normalization and how you resolved them. c. SQL Schema: - Create an SQL schema that includes defined entities. - Define primary keys, foreign keys, and appropriate constraints. - Ensure that the database schema enforces referential integrity. You need to create all of the above things from one of them (I will specify in chat): Scenario 3: Public Library Management Create a database for a public library to manage books, members, loans, and fines. The database should handle book reservations, track overdue items, and support queries for book availability and member activity. Scenario 15: Music Festival Organization Design a database for organizing music festivals, including artists, stages, schedules, and ticket sales. The system should facilitate lineup planning, manage artist contracts, and handle ticketing logistics Scenario 4: University Accommodation Service Design a database system for a university's accommodation service that manages student housing, room allocations, maintenance requests, and payments. The system should accommodate different housing options and prioritize allocations based on specific criteria