Databases

Use Cases

use cases are

• register and login user
• CRUD operations on
  • players
  • teams
  • matches
• view stats of individual players
• four buttons in match view to change current score of the match
  • 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)

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.