This assignment presents a comprehensive database design for an event management system. It includes an Entity-Relationship Diagram (ERD), a detailed data dictionary specifying data types and constraints for each table, and SQL create table commands to implement the design in a relational database. The rationale and assumptions behind the design choices are clearly explained, emphasizing the avoidance of data redundancy and the scalability of the design to accommodate future expansion. The database is designed to manage events (races and walks), participants, volunteers, staff, clients (sponsors), and medical locations. The design includes tables for events, participants, volunteers, staff, clients, medical locations, and relationships between them, such as event-client, event-participant, and event-volunteer relationships. The SQL commands provide a practical implementation of the design, allowing for the creation of the database and its tables.