Fall 2023 Term 1 Project - Drug Testing in MLB

Project Details:

Goals: This project is designed to help students:

• Learn the process of conducting a research project in the field of sports analytics. • Develop technical skills required to design and implement a prototype relational database system. • Perform data analysis on sports-related data using SQL and/or other statistical and data visualization tools.

Objectives: By the end of this project, students should be able to:

• Understand the research project lifecycle in the context of sports analytics. • Apply database design principles including normalization and Entity-Relationship Modeling (ERD) to create a relational database for storing sports data. • Implement a relational database system and import relevant sports data. • Perform exploratory data analysis and draw insights from the sports data. • Manage and present their project effectively.

Project Overview

As enthusiasts of sports analytics, you are aware of the immense potential it holds in various sports. You recently came across an older movie Moneyball that emphasized the need for advanced analytics in sports, prompting you to take on the challenge of improving sports performance through data-driven insights. With guidance from your instructor, you have formed teams and outlined the essential tasks to achieve this goal.