After completing the student information management system, I was very happy. Although the student information management system has the source code, I just copied it, but this is also the first time I did the system. For the database of the student information management system, we only need to understand and understand what it means. In addition, there are no too many requirements. That's why I got the database statement parsing of the student information management system. Although I only analyzed the script statements of the database, I understood it at least and analyzed it.
The database of the data center charging system clearly tells us to analyze it by ourselves, build the database by ourselves, and frame the "Foundation" through the data center charging system process.
Process:
Starting from students:
Starting from the overall:
Starting from the function:Query-oriented
To sum up:
1. Enter the student's personal information and complete card issuance when purchasing the machine;
2: Enter the machine room with a card;
3: The on-board personnel are stuck on the card reader at the entrance for registration. You can choose one microcomputer. Enter the card number and password to complete the logon process;
4: during the use of the machine, the system regularly deducts the amount from the student account and card at the preset rate. When the amount is found to be insufficient, a deposit is prompted in advance. Once the amount in the account (in the card) is insufficient to pay the machine fee set per unit time, the system will automatically lock the machine and will not allow the operation to continue;
5: Students must use the cancellation program to exit after the computer is completed; otherwise, the card cannot be verified for settlement;
6: Go out and complete the whole machine process.
Functions of the data room Charging System
User Functions
1: average user
View: Machine Records
Recharge record machine status balance
Change: Password
2: Operator
Add: register for recharge
Change: Password
Query: the amount collected is returned to the student's Computer Information operator's work record
3: Administrator
Add: Add users
Modify: Basic Data settings
Password
Query: on-duty instructor
Bill
Delete: delete a user
To sum up:
Through multi-database and interface analysis, I think it may include the following parts:
1. Logon: ensures data security and is not changed.
2: computing function: calculates the cost of the computer by setting the basic data
3: query function: query various information that administrators and operators want to query through conditions
4: checkout function: the administrator can settle bills for individual users on a daily or weekly basis.
Create a database:
With the above analysis, we can make it clear to create a database table.
To sum up:
1: tables involved in each user's function;
2: The operator has the functions of general users, and the Administrator has the functions of general users and operators;
3: according to the function of each user on the system.
The above is a small analysis of the charging system of our data center, even a small preparation work before doing this system ~~~~~~~~