The volleyball scoring program of MVC--(a) demand analysis and database design

In the actual project, requirements analysis and database design is a very important link, this link will directly affect the development process and quality of the project. In practice, this link requires not only the system analyst, software engineer and other computer experts, but also the field experts involved in the relevant fields to complete.
Requirements Analysis:
This project is a volleyball scoring program and its business is extremely simple and is now described below.
1. Any audience can play the score query, after the query is completed, the page displays the corresponding match content of the query.

2. No viewers are allowed to add or revise scores.
3. The scorer can record the match in real time, record the score in the database, make it easy for viewers to query, and pass the score.
4. The scoreboard can be used for the data to be increased and censored. Until one party wins, the game is over.

The use case diagram for this project is as follows:

Database design:
Before designing a data table, first identify and identify entities and relationships.
Through demand analysis, it can be observed that the entity of this project is: Audience, scorer . ( The audience can not modify the data, the scoreboard can modify the data );

The database tables are designed as follows:

The volleyball scoring program of MVC--(a) demand analysis and database design