Abstract: The following is an applied database scenario based on a single season in the FIA Formula One (F1) World Championship of auto racing. This scenario builds database understanding and skills through data modeling, data acquisition, creation of a database through a database management system, query construction, and report creation. In the United States, Formula One falls squarely in the realm of “niche” sport, yet is regarded as one of the largest and most popular sports world wide. Various agencies have measure world television viewership of F1 to be the largest for a seasonal sporting league and only surpassed by quadrennial events such as the World Cup of Soccer and the Olympic Games. This dynamic allows for a great opportunity for undergraduate students. While most students will not be familiar with F1, they will have a basic understanding of racing in general. Also, while not in the consciousness of most Americans, the amount of sources of data for F1 abound worldwide. This creates a fertile environment abundant of data and the opportunity for easy entry to understanding of the environment by the novice.
Keywords: Data modeling, Database Reporting, ER Diagram, Relational database
Download this article: ISEDJ - V16 N2 Page 34.pdf
Recommended Citation: Serapiglia, A. (2018). Formula One – a database project from start to finish. Information Systems Education Journal, 16(2) pp 34-39. http://isedj.org/2018-16/ ISSN: 1545-679X. (A preliminary version appears in The Proceedings of EDSIGCON 2017)