In this project, we designed and implemented a small-scale client/server database application program called ASEP (Assignment Submission and Evaluation Project). The initial aim of this project was to automate the submission and evaluation of students’ assignment files in an effective and flexible way. The project has almost reached to its aim. The students are now able to submit their assignment files easily from anywhere by using ASP client. Moreover they can learn their grades and view the attached feedback files. Collecting assignments, evaluating and grading them, giving new assignments are now easier for assistants or instructors. All the data about students, assignments, grades are being kept in a more organized and efficient way. The powerful client/server architecture, the rich database features, the simple and easy to use interface and the easiness in deployment makes ASEP a valuable and unique program that deserves more work and enhancements to make it a better program. It requires more work because it has some deficiencies.

The main deficiency of ASEP is that the lack of a general control mechanism. The two programs ASP and AEP act as clients both for ASEP server and ORACLE database server. This causes some problems. For example there may be some inconsistencies in the database. This effects the stability of the programs and decreases the reliability.

The general control of the programs must be directed from a single point. The database operations must be done as database transactions where rollbacks and commits are used to provide consistency in the database.

Another point is that, all the programs should be re-implemented considering the performance issues to increase the efficiency. Beside this, a new and more reliable file transmission protocol should be designed.

If the ASEP will be used in a real university or another school environment the ASEPDB should be designed and implemented in a more realistic way considering all the details related to courses, assignments and students.

Another important issue is the automating the evaluation process. We think that if some common standards are developed in giving assignments and evaluating them, evaluation can be done more easily and effectively which will save a lot of time.

Despite the above deficiencies, we think ASEP as a successful project. We hope this project will go on in the next years and eventually will be used in a real school environment.