After the student information management system finished work, began to set up the computer room charge system.
With some experience in student information management systems, it is important to analyze functions and tables before starting.
Only clear the relationship between, in the system can be handy.
The following is a preliminary analysis of the table and table relationships:
Table Build:
The Student Basic information table is consistent with the registration form, that is, a student has registered a new card, card number, school number, name, sex, department and other information in the Student information table exists, and the registration card information only card number and the corresponding school number on the line, to obtain other information, according to the school number and card number, can be found in the basic student information.
In the registration card information, the card number has duplicate, if is a person registers a card, the card number is 1, in the registration card information and student basic information will have the corresponding record, this person will 1 this card number to retire, another person happened to register this 1 card number, in the registration card information will also appear the record, therefore, There may be duplicate card numbers or duplicate numbers in the registration card information, but they will not be duplicated in the student's basic information.
Card number on the machine, you can according to the basic information in the student according to the card number to find other information, in the withdrawal of the card, the same reason
On the card, back card, recharge card in the data as long as the recording function, which can have duplicates.
The Student Basic information table does not have duplicate data, the Student basic information table and the registration form, is in the registration time, simultaneously deposits the data.
Similar to the card information, the management of this piece, add users, but also in the Add User table and System user table in addition to the data, on-duty information and delete the user table is the main record of the role, can have duplication.
Inter-table diagram:
The table has a preliminary analysis and understanding of the table can be more reasonable.