SQL Queries: Participant, Register, Event Database Implementation

This assignment presents a comprehensive SQL database solution for an event management system. It begins with the creation of multiple tables, including Participant, Register, EventSupplier, Supplier, EventPlanner, Client, LandOwner, LocalAuthorityEvent, LocalAuthority, and Event, detailing their attributes and relationships. The solution includes SQL queries to create these tables, insert sample data, and perform various data retrieval operations. The queries cover a range of functionalities, from simple data selection based on specific criteria (e.g., clients from London, participants paying over a certain amount) to more complex queries involving joins and aggregations (e.g., counting suppliers from Manchester, displaying land owner cities and event counts, sorting land owners by name, calculating total amounts collected per city). Screenshots of the SQL queries and their results are provided, illustrating practical database management and data analysis techniques. This assignment showcases the fundamentals of SQL database design, data manipulation, and query optimization within the context of an event management scenario.