1.1.1 LAN Data Access Scheme
Data Access in the LAN Environment in this system adopts customer / server mode. During development, we will use the Interbase 6 database management system. On the one hand, in order to enhance the transplantability of the system, the access to the data will adopt a standard SQL language, try not to use the special functions expanded by the database management system; on the other hand, in order to improve the performance of the system, we use most database management Trigger programming supported by the system.
1.2 system structure design
1.2.1 Overall structure of the entire system
3.2.1.1 Hardware System Structure Map
database
server
touch screen
Win 98 / 2K
Ordinary PC
Win 98 / 2K
switch/
Hub
Hardware system structure
3.2.1.2
Software system processing process
3.2.1.2.1 Touch Screen Program Process (see flowchart)
3.2.1.2.2 Control Program (Console)
Mainly complete the maintenance of the basic information, test questions, users and other materials, and the statistical work of the touch screen parameters and the statistical work of the answer sheet.
N
Y
Y
Y
N
N
Y
Y
N
Y
Y
Y
N
begin
Connect to Interbase Server
Is it correct?
Enter the main interface of the program
Waiting for entering username / password
Is it correct?
Go to the selection interface, click the "Start Sesstee" button to select the title, click the "Back" button to return to the main interface
return?
Selection?
Question this month has been full?
Enter countdown
carry out an assignment?
Do you answer?
Is it correct?
Tip the answer is correct! Score
Tip the answer error! Not score
End
Want to exit the system, you must enter the correct system password!
Touch screen program processing flow chart
2 database design
2.1 Database Selection
According to the requirements analysis, the data access of the system is based on the C / S mode, requiring the target system to use a variety of database systems that support standard SQL.
During the development process, we use InterBase 6 as a database server, develop client programs with C Builder 5.0, so the client is implemented with the database through BDE and SQL Link.
