A B S T R A C T I. INTRODUCTION

(1)

Online College ERP System

1 Sonawane Kavita S.2Mitkari Priyanka S.3Waman Prajakta P.4 Tavhare Rahul B. Dept. of Computer Engineering, SVCET Rajuri, Pune Maharashtra

[email protected]@[email protected] 4 [email protected]

A B S T R A C T

It is total end to end solution for all engineering colleges for maintaining the records of students in their institute. In effect , we maintain an updated database of all details like all branches, all subjects, all students information, Fee details, Hostel details, library details. Also it will maintain the entire database. Also this system takes the online student registration. Its purpose is to automate and centralise whole system of department. We are attempting to improve our existing system that runs on pen and paper. It is basically we design this for reduction of workload of all our head of the department who act as a central user or administrator of this project. We try to offer a range of facilities in a software that will maintain the all student records, fee details of each student in a much more efficient way with much less hassle. Also we generating all the reports of the modules that we are developing on the system. It provides faster response to the user. No work is handled manually, so through automation efficiency is increase. The major criteria are taken in consideration while developing OCERPS (Online College ERP System) is user satisfaction.

The existing system is the manual one. They Have different file for different purpose, Like separate file for record and separate file for report etc. so to overcome this problem we develop this project to solution for this manual work.

Keywords:-JSP, XML, Apatche tomcat 4.0, OCAS, css. I. INTRODUCTION

Online College ERP System which is a web based System that enables an college to utilize a team of incorporated interrelated modules to manage the management of college effectively. Online College ERP System is becoming a really essential component of the education and learning system in this modern-day age and gathers all the useful information needed to the management in a few clicks. In the Online College ERP system, there are various stakeholders of the education domain which are interconnected on the single platform. With the role based access rights to different users, there may be n number of logins created in the ERP system for different users according to their role. Users of various divisions get the access to Online College ERP software and work simultaneously.Number of reports present in different modules of ERP helps Administrator to keep an eye on the resources and work of different departments of college and plan them efficien to. Getting good information and transforming it quickly into products than consumers want to buy is the essential key to staying in business and this all is done nowadays using Computers and Application Software.

The software helps Managers to plan and control the organizational operations and to respond to changing market conditions. It provides a regular ﬂow ofinformation for managerial decision-making and control. There is growing concernabout the apparent widespread failure of Application Software and information technology (IT) to deliver real organizational and business beneﬁts. Several

(2)

2 | © 2015, IJAFRSE and JCON 2015 All Rights Reserved www.ijafrse.org high proﬁlecomputer system failures in the public domain have highlighted this problem. A lackof understanding about the impact of ERPS and IT on employees and organizationshas compounded the problem. Historically, the majority of Application software hasbeen developed using a predominantly technical perspective. System developershaveattempted to minimize the complexity surrounding organizational change by concentrating primarily on a technical agenda.ntly. Browser-based College Management Software can be easily accessed from public web.So this project helps to store those type of information using computerized system.The impact of computers on our lives today is probably much more than we are actually known to. Getting good information and transforming it quickly into products than consumers want to buy is the essential key to staying in business and this all is done nowadays using Computers and Application Software.

The software helps Managers to plan and control the organizational operations and to respond to changing market conditions. It provides a regular flow ofinformation for managerial decision-making and control. There is growing concern about the apparent widespread failure of Application Software and information technology (IT) to deliver real organizational and business benefits. Several high profilecomputer system failures in the public domain have highlighted this problem. A lackof understanding about the impact of ERPS and IT on employees and organizations has compounded the problem. Historically, the majority of Application software hasbeen developed using a predominantly technical perspective. System developers have attempted to minimize the complexity surrounding organizational change by concentrating primarily on a technical agenda.

1.1 Project Objective

This project aim is to automate the system, pre-checking the inclusion of all re-quired material and automatically generate each students report of fee details,training and placement information,library details for effective management. The data used by the system is stored in a database that will be the centre of all information held about students and the base for the remainder of the process after the initial application has been made.This enables things to be simplified and considerably quickend, making the jobs of the people involved easier. It supports the current process but centralizes it and makes it possible for decisions to be made earlier and easier way. It is also designed to calculate the attendance of the students. Specific reports will also be generated regarding the students.

II . PROBLEM DEFINITION

This project aim is to automate the system, pre checking the inclusion of all required material and automatically generate each students report of fee details,training and placement information,library details for effective management.

III . LITERATURE SURVEY 3.1 Working Of Existing System

The present system is the mannualone. Hence all the information about the Student details maintained in the file. They have different-different files for different purpose, Like separate file for student details, separate file for report etc. In the present system all work is done on paper. The whole session Record is stored in register and at the end of the session the reports are generated. They are not interested in generating report in the middle of the session or as per the requirement because it takes more time in

(3)

3.1.1 Disadvantages of Existing working system

1. Not User Friendly: The existing system is not user friendly because the retrieval of is very slow and data is not maintained efficiently.

2. Difficulty in report generating: We require more calculations to generate the report so it is generated at the end of the session. And the student not get a single chance to improve their attendance.

3. Manual control: All calculations to generate report are done manually so there is greater chance of errors.

4. Lots of paperwork: Existing system requires lot of paper work. Loss of even a single register/record led to difficult situation because all the papers are needed to generate the reports.

5. Time consuming: it requires more time. 3.2 Proposed System

We have developed new system, which is based on computer in which the student used to give test on the computer by simply clicking the answers. It is most reliable time saving system while conducting some entrances test.

3.2.1 Characteristics of the proposed system

1. User Friendly: - The proposed system is user friendly because the retrieval and storing of data is fast and data is maintained efficiently. Moreover the graphical user interface is provided in the proposed system, which provides user to deal with the system very easily.

2. Reports are easily generated: reports can be easily generated in the proposed system so user can generate the report as per the requirement (monthly) or in the middle of the session. User can give the notice to the students so he/she become regular.

3. Very less paper work:The proposed system requires very less paper work. All the data is feted into the computer immediately and reports can be generated through computers. Moreover work becomes very easy because there is no need to keep data on papers.

4. Computer operator control: Computer operator control will be there so no chance of errors. Moreover storing and retrieving of information is easy. So work can be done speedily and in time.

(4)

Online College ERP System include student registration, fee details, hostel information, library details, certificate generation, student, report of different database.All that modules are interact with Online college ERP system with particular work.

3.4 Mathematical Model for College ERP System A = geti(ic, i);

Here CA represent the college automation system. The function geti was used to get the proper list of inputs, the function passes two variables ic which means input content to File System and i which contains inputs.

I (C,A, S);

Here I represents the College Automation System,

C represents the content of systems, A represents the Admin Provider Information And S represents the Student information.

Initial Condition

1. The user must have an active Internet connection. Set Theory Analysis A] Identify the Authority

A= a1, a2, a3.

Where A is main set of Authority Users like a1, a2, a3 B] Identify the Attribute

AT= at1, at2, at3.

Where AT is main set of registered Attribute like at1, at2, at3 C] Identify the User requested For Another Attribute

RAA= raa1, raa2, raa3

Where RAA is main set of Request for another Attribute raa1, raa2, raa3

D] Identify the User Requested All Attribute In Emergency. RAE= rae1, rae2, rae3. Where RAE is main set of requested all attribute in emergency rae1, rae2, rae3 E] Identify Secrete Key of New User. SK= sk1, sk2, sk3.

Where SK is main set of secrete key of users sk1, sk2, sk3 F] Identify Attribute Key of New User

(5)

G] Identify the processes as P. P= Set of processes P = P1, P2, P3,P4

P1 =e1,e2,e3 Where

e1= upload data on server

e2= make the entry in database using different User e3= get new attribute after request H] Identify failure cases as FL Failure occurs when FL=F1,F2,F3

a) F1= = f—f if error in uploading due to interrupted Internet connection I] Identify success case SS:- Success is defined as-

SS= S1,S2,S3,S4

a) S1=s— s if fast and no interrupted Internet connection b) S2=s— s if data is added into database Many to many relationship

J] Initial conditions as I0

a) User have good internet connection

b) Admin have good internet connection. K] 1.User may have multiple attributes. Attribute may assign to multiple users.

IV.ADVANTAGES

1. This project can be highly feasible for computerization 2. Manual errors are highly reduced

3. The ease of operation makes any user to carry out the required operation 4. The degree of accuracy and precision are very high

5. Time saving process

6. Reduces the work load of the user. V.APPLICATION

1.This project will be used by Sahyadri Valley College Of Engg and Technology Institute and other engg Institute.

VI.CONCLUSION

With the limited span of time we have successfully completed. Thus we conclude that by accomplishment such a system, we have developed a good knowledge of the software. The System created by us is user friendly and well adopted to the needs of the users. The system is easy to be worked on. We had many ups and downs while designing the system but finally, which we think is a milestone in our career. Patience and courage were the keywords of our success. As we know human beings needs are never fulfilled, infuture we would like to add some more facilities such as maintaining the various detailed information in our project. While testing of software the errors encountered were rectified and the software was tested again for verification. To the best of our knowledge the software is error free and working satisfactorily. We conclude that our software is working as per the project guidelines.

(6)

development technologies.

[2] Send Text Messages via our SMS API Gateway Very simple scripts to send SMS texts from your own systems and software http://www.textlocal.com/simple-developer-sms-api

[3] David Booth, W3C Fellow/Hewlett-Packard Hugo Haas, W3C Web Services Architecture W3C Working Group Note11February 2004 http://www.w3.org/TR/ws-arch/

[4] Mr. Chrisbowler Create Your Own Intranet App on August 28th 2009 http://web.appstorm.net/how-to/create-your- own- intranet-app/

[5] By Michelle Mista, How to Set Up an Intranet Web Server, eHow Contributor set-up-intranet-serverhtml

[6] Alan Brown by Object-Oriented Databases and Their Applications to Software Engineering.

[7] Mike Snell, Glenn Johnson, Tony Northup by Microsoft .NetFramework 3.5-ASP.NET Application Development. [8] JSF 2.0 Cookbook. Sketchy quality overall,

[9] JSF The Complete Reference. Co-authored by the JSF specification lead, Ed Burns. My second-favorite.

[10] Java for the Web with Servlets, JSP, and EJB: A Developer’s Guide to J2EE Solutions by Budi Kurniawan, this is a very old book most probably not available in market but I found it very interesting.

[11] New Riders - Java for the Web with Servlets, JSP, and EJB