Web Based Application for Registering Degree Projects LEONIDAS FRAGIDIS, ACHILLEAS MICHAILIDIS, VASSILIOS MARDIRIS AND VASSILIOS CHATZIS Information Management Department Technological Institute of Kavala GR-65404 Kavala, GREECE Abstract: The purpose of this paper is to present the web-based application “e-project” accessing a relational database through internet. The tools that have been used to build this application are MySQL as a relational database system for the database design, TCL as a computer language for the development of the application, JavaScript language scripts has been included in source code and HTML for the internet user interface programming. The aim of the application is to provide easy access to the submitted projects and dissertations of the Information Management Department of the Technological Institute of Kavala, Greece to each authorized user. The users are separated to three different groups, the administrator, the professors and the regular users which are the students of the department. Key-words: Web Based Application, Open Source Software, Degree Projects, TCL, MYSQL, Database 1. Introduction Web-based application “e-project” is relied on open source software (OSS) which can be modified by changing the source code. The “e-project” has been developed as an internet based application in order to give access to the submitted projects and dissertations of the Information Management department in Technological Institute of Kavala, Greece. Through “e-project” is given the ability to upload the developed applications to all authorized students of the department. The application separates its users to three different groups. The first group and the less functional is “students” having the ability of searching and uploading their own project and thesis. The second group of users is “professors” which have the ability to upload projects and thesis as files to the application database, to edit or delete those entries. Finally, the third group is the “administrator” which has the exclusive privilege to modify or delete all the uploaded files and entries from the database. As it is mentioned above, “e-project” has been developed with the use of open source software (OSS) tools. The OSS tools that have been used are MySQL for the database part of the application, TCL as the programming language, JavaScript as a designing part of application and HTML for the internet user interface programming. The Operating System in which the OSS tools operate is Unix Solaris 10 installed in a SUN Fire Server. 2. MySQL and Database Architecture MySQL uses the Structure Query Language standard giving a great deal of control over a relational database system [3]. However, unlike most relational database systems, MySQL is freely available, and because it operates on Unix systems, it integrates very well with scripting languages such as Tcl. 2.1 The Database structure The database of the “e-project” application is composed of six tables which are illustrated in figure 1. As it is shown below five tables are linked to the main table ‘degrees’. Since it is the central table, it holds all the appropriate information in relation to each project submitted to the database. 12th WSEAS International Conference on COMPUTERS, Heraklion, Greece, July 23-25, 2008 ISSN: 1790-5109 567 ISBN: 978-960-6766-85-5