ABSTRACT
College administration led by the administrator works with students, academic and support staff to ensure the effective administration of all matters of students’ admission, fee details, contact details, transfer of students.
The administrator assigns different userids and passwords to clerk and accountant so that he shares his work These are the people responsible for entering and making changes to the entered data.so,the username and password are highly secured.
The administrator have all rights over the system. clerk is responsible for contact details and transfer of students modules. He can update the contact details and checks the availability for transfer of students in the beginning of second year.
Accountant is responsible for fee module. He enters the fee details into the database. It is easy for the college administration to know the student’s dues and send particular notice to them.
Existing System
The current college administration system has single user environment.and it uses the Microsoft access database for storing purpose.
Problems with this system
Becauseof the single user environment burden on the single person is more.The process is time consuming to maintain the database by the single person.
Microsoft access database is os dependent and it cant store large amount of data.And also the database response is slow.
Proposed Solution
One of the solutions that we are going to discuss here to speedup the database response by using oracle database and to reduce the time complexity by using multiuser environment. Because of this multi user environment we can reduce the burden on single person also.
SOFTWARE REQUIREMENTS:
• Web Technologies : HTML, CSS, JS. JSP
• Programming Language : Java
• Database Connectivity : JDBC
• Backend Database : MySQL
• Operating System : Windows 08/10
HARDWARE REQUIREMENTS:
• Pentium processor : Core I3
• RAM Capacity : 2GB
• Hard Disk : 250GB
• Monitor : 15’’ Color Monitor