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