Project: Database Design for Burn 24hour Challenge System

This project details the design and implementation of a relational database system for the Burn 24hour Challenge, a mountain bike race event. The assignment begins by listing new attributes and grouping them into existing or new entities, including Staff, Captain, Volunteer, Team, and Rider. It then presents an Entity Relationship Diagram (ERD) to visualize the relationships between these entities and their attributes. The project further illustrates the database tables, including Captain, Staff, Team, Rider, and Volunteer, along with their respective records and primary/foreign keys. SQL queries and a data modeler design are also included to demonstrate the practical application of the database. Finally, the project concludes with the creation of tables using DDL commands, providing a comprehensive overview of the database design process.