 |
VŠB - Technical University of Ostrava Faculty of Mechanical Engineering Department of Control Systems and Instrumentation |
» Czech version |
|
 |
Růčka, P. PhD. studies information support system. Ostrava: Department of Control Systems and Instrumentation, Technical University of Ostrava, 2004. 120 pages. Final thesis, Supervisor: Farana, R. The database system data structure in this thesis was designed for the information needs of the Department of Control Systems and Instrumentation – Technical University Ostrava.
The suggested database system data structure enables the storing of records for individual PhD students during their study. Furthermore it also simplifies assembling and printing individual study reports, for example exam reports, individual student’s schedule (educational plan) and his/her study results.
Client-server architecture was chosen for this database, where the user of the client version (model) was implemented in MS Access 2000 and data structure was stored on MS SQL Server 2000.
Data manipulation was secured with access rights defined by the administrator.. |
Results of work
In designing the database structure, the MS SQL Server 2000 was chosen because this SQL database comprises a number of supportive tools facilitating the work with the database and its administration. The client application was created in the MS Access 2000 environment. Regarding the fact that the potential use of the client version may also be independent, two applications were created. One of them is a client/server version, and the other is only accessible from the Access database. The database administration and access have been created by code in Visual Basic for Application and therefore it was not necessary to create user groups in MS Access. Following the thesis assignment, all required forms for the operations of this Ph.D. student information system have been designed including the necessary printed reports. The functionality of the application was verified on a test set of datafiles..
30.9.2004 © Pavel Růčka,
Department of Control Systems and Instrumentation, Technical University of Ostrava, 17. listopadu 15, 708 33 Ostrava-Poruba