ASP. NET MVC Volleyball scoring Program (iii) demand analysis and database design

Requirements Analysis:

Software Name: Volleyball Scoring Program

1, need to type the name of the competition personnel, according to the game results on the field to make timely operation, the scorer can be mistaken in the case of the revocation of the previous operation. At the end of the game, the scorer should be able to find out the goal of each team, as well as the highest score for blocking, hitting, and MVP.

2, the System interface: Two teams, each team scored, by the scorecard input data to the system, the score of the team by clicking the button to add points, every time, the score to write to the database. There should also be a minus button, each time minus points, written to the database.

System: Automatic calculation of the score of each team to achieve the success of the Bureau, if the victory in time to show the news of the Bureau victory.

Final output: Every click, the score change should give a new score after the bonus points on the scoring program interface.

1. Functional Requirements: Add points, record detailed scores, show detailed scores.

2. Performance requirements: On the ordinary home computer can run the program perfectly, so that it does not wait for a long time phenomenon.

Click the activity diagram that submitted the bonus points

Design of the database:

PersonA

ID int PRIMARY Key

Name nvarchar () null

Personb

ID int PRIMARY Key

Name nvarchar () null

Scorea

ID int self-increment

personId int NULL

Jiqiu nvarchar (() null (serve, erase, spike, etc.)

Isscore nvarchar (() Null (score)

Scoreb

ID int self-increment

personId int NULL

Jiqiu nvarchar (() null (serve, erase, spike, etc.)

Isscore nvarchar (() Null (score)

ASP. NET MVC Volleyball scoring Program (iii) demand analysis and database design