Database System Design: 24 Hour Challenge Company Database System

This report provides a comprehensive database system design for the 'Burn 24 Hour Challenge Company,' covering essential aspects such as fan traps, chasm traps, and redundant relationships. It delves into database normalization, explaining 1NF, 2NF, and 3NF with practical examples related to movie rental records. The design includes diagrams illustrating supertype and subtype relationships and table diagrams for subtype implementation. The report specifies table attributes, primary and foreign keys, and relationships within the database, accompanied by sample records for various tables like TEAMS, RACES, RIDERS, and LAPS. This detailed design aims to create an efficient and well-structured database system for the company.