Development-of-a-Football-Club-Database

1.

Development of a Football
Club Database
Presented by Taberkhan Ali, IS-21

2.

Project Objectives and Goals
Efficient Database
Manage club operations effectively.
Goals
Analyze subject area, design ER model, SQL
implementation, optimize data structure.

3.

Subject Area Overview
Key Entities
Economic Role
Players, teams, coaches,
Revenue from tickets,
match schedules, fan
merchandise, and
interactions.
sponsorships.
Social Role
Uniting fans and promoting youth engagement.

4.

System Requirements
Store Data
Players, teams, matches, fan interactions.
Analyze Statistics
Track player performance and team progress.
Track Fans
Engagement through surveys, social media, ticketing.

5.

Entity-R elationship (ER) Model
1
2
3
Entities
Relationships
Attributes

6.

Data Normalization
1NF
1
Eliminate repeating groups.
2NF
2
Remove partial dependencies.
3NF
3
Remove transitive dependencies.

7.

SQL Implementation
CREATE TABLE Player ( Player\_ID INT PRIMARY KEY,
First\_Name VARCHAR(50), Last\_Name VARCHAR(50),
Position VARCHAR(20), Team\_ID INT, FOREIGN KEY
(Team\_ID) REFERENCES Team(Team\_ID) );

8.

Advanced SQL Queries
1
Red Lions
List of players from the "Red Lions" team.
2
High Score
Matches with a total score greater than 3 goals.
3
Fan Attendance
Fans attending high-scoring matches.

9.

Innovations & F uture
Directions
1
Mobile App Integration
2
Advanced Analytics
3
CRM Tools
4
Cloud-based Solutions

10.

Conclusion
1
Robust Database
2
Next Steps
Successfully developed a
Expand analytical features,
database for a football
integrate with external
club.
systems.

11.

Thank you for your attention!