Personally speaking, presented by Teacher Wen, Database System is one of the most well-organized and intriguing course I've ever taken during my study at Nankai University.
Final Project: A minor Database Management System matching all the requirements
My Project: Premier League Database Management System with all corresponding funcitons:
- FA Mode(The Football Association):
- Viewing all games, clubs, coaches, referees
- Viewing all info of forward players and goalkeepers
- Relegation on specific Premier League clubs
- Club Coach Mode:
- Viewing top goal scorers of Premier League Season 2022-2023
- Club Manager Mode:
- Purchase players for your own club
- Sell out specific player belonging to your club
- Query on all players belonging to your club
- Update on position and transfer value of your club players
- Intelligent Part(2024.1 - 2024.4 update):
- Predict players' future performance based on their historical data
- Chatbot interaction to give specific advice on many aspects of the game
- Help the club coach and manager to make more comprehensive decisions
- Front-End: JAVA GUI
- Back-End: JDBC MySQL
- Data Source: Official Premier League Website(https://www.premierleague.com/)
- Simple DEMO:
- Relationship Diagram
- Code Structure:
/project-root
├── /python
│ ├── data_preprocessing.py
│ ├── performance_prediction.py
│ └── player_clustering.py
│
├── /java
│ ├── PerformancePredictor.java
│ ├── PlayerClustering.java
│ |── DecisionSupport.java
│ |── Chatbot.java
│ └── ...
Continue to update......
All the modifications in the near future will be specific.
Feel free to contact me on ErwinZhou@outlook.com
不多说了，懂的都懂，计网最神的课之一。优秀且合理的课程安排，答疑和全面的习题，视频讲解和丰富的课程资源。龙龙耐心的讲解，上机考试+期末大作业。
在这里提供了2022年的网络安全学院数据库系统课程期末大作业。
我基于Java语言的前端和SQL语言的后端，使用Eclipse作为IDE，选择了英格兰足球超级联赛作为主题。
部分球员和俱乐部数据来源于https://www.premierleague.com/。即英超官方网站。
实现了英足总模式+俱乐部经理+教练模式三种不同玩法，包括购买球员，出售球员，修改球员位置身价，降级俱乐部，积分榜和射手榜查询等多种功能。更详细的介绍可以阅读我的课程报告。
于后期慢慢完成了智能部分，包括根据球员历史数据预测未来表现，聊天机器人(OpenAI接口)提供建议，帮助俱乐部教练和经理做出更全面的决策。
作为我大学至今最满意的课程作业之一，对实现了自己所热爱的东西的感觉十分开心。
内容会持续更新
任何有改进的内容都可以联系我，