MVC Volleyball Scoring (II.)--demand analysis and database design

Requirements analysis and database design is a very important link, this link will directly affect the development process and quality of the project.

The volleyball scoring program here is an example, and its business is very simple, so here is not really a need to divide

Analysis and database design, but the volleyball scoring needs and databases listed here.

Requirements Analysis :

This project is a volleyball scoring program, its business is very simple, now described below.

1. Viewers can only view the data in the game.

2. The scorer can score each goal of the match (which player scores).

3. The scorer can score each game's innings (for example: first inning: 25:20, second inning: 25:1).

4. The scorer can record the total score of the two teams (for example: Team China vs Japan: 3:0).

5. The scorer can modify, delete, and query all the data.

The use case diagram for this project is as follows:

Database design:

Total Records table

ID int primary key, self-increment notnull

TeamA varchar (100) main squad Notnull

Teamb varchar (100) Guest squad Notnull

Gfirst varchar (20) First inning score Null

Gsecond varchar (20) Second inning score Null

Gthird varchar (20) Third inning score Null

Gfourth varchar (20) Fourth inning score Null

Gfifth varchar (20) fifth inning score Null

Gsum varchar (20) Total score Null

Detailed record sheet (Detail)

ID int first few balls Notnull

TeamA varchar (20) main squad Null

Teamb varchar (20) main squad Null

< Span style= "COLOR: #339966" > membera      varchar (20)    main party scoring team          Null

Membera varchar (20) guest scoring player Null

MVC Volleyball Scoring (II.)--demand analysis and database design