Skip to content

Databases

Laurin-Notemann edited this page Nov 16, 2023 · 15 revisions

Introduction

The purpose of my wy web-app "Tennis-Analysis" (working title) is to keep track of regional matches. Every input is user based, which means every user has to create their own players, teams and matches they want to keep track of.

The idea is to be able to have stats of individual Players or Teams and see how they perform, but also how they were able to perform in their matches. It's more for users who watch tennis games rather than people who are actually playing.

Use Cases

The use cases are:

  • register and login user (implemented)
  • CRUD operations on
    • players (implemented)
    • teams (implemented)
    • matches (missing)
  • view stats of individual players (missing)
  • four buttons in match view to change current score of the match (missing)
    • server scores
    • receiver scores
    • double fault (server hits into the net twice receiver gets point)
    • ace (server gets point without the receiver touching the ball)
image

Er Diagrams

Initial Diagram

Final Diagram

Reason for Relation changes:

  • Removal of winner from games, matches and sets tables because the winner can get deduced through the points table.
  • Addition of stats table to get more information about the match and get more insights
  • Addition of Refresh Token to store the session of each user

Contribution

Since I have been working by myself on this project I have done all the contributions.

Clone this wiki locally