ERP on School Management System

ERP
Guided By: Shailesh Gohil
Developed By : Amit Gandhi

OVERVIEW
 Company Profile
 Introduction
 Software specification
 Analysis phase
 Design phase
 Data dictionary
 Implementation
 Limitation & future improvement
 Conclusion

COMPANY PROFILE
 TOPS Technologies is one of the largest IT Training, Outsourcing and
Placement Service provider. TOPS offer a wide array of solutions in the
IT industry, through multiple offices located in Ahmadabad, Vadodara,
Rajkot, Surat, Navsari, Mehsana, Junagadh, Indore, Bhopal, Jabalpur,
Noida, Kota, Jaipur, Nagpur, Dehradun in India and sales offices in
Chicago, IL and Mountain View,CA in USA.
 TOPS Technologies are based on the Training, Outsourcing, placement
and Services.
 TOPS Technologies have partnered with more than 1000 software
companies across Gujarat and India for placements. Our team works with
each software company on a personal level to understand their
requirements and provide them with required talent.
 The management team has 15+ years of work experience working for
companies JP Morgan, Verizon Wireless, Capegemini, US Cellular in
different verticals ranging from banking solutions to health care industry
to mobile applications.

INTRODUCTION
 ERP systems collect data and financial information from various
areas within an organisation, then stores that data centrally on a
computer.
 ERP systems are typically made up of different modules depending
on the type of organisation and its requirements. .
 This will reduce the efforts to maintain the record allocation process.
 Its all about to how to manage the student record in a master file as
well as how admin and faculty can manage the profile and keep
information about the student.
 All the information regarding student can see and edit if necessary
apart from that faculty can keep record of student and they can
manage information like student profile, exam, attendance, or other
information.

SCOPE
 Different people, place from different departments can view the
same information about Student Information.
 To enable the head and technical supporting group to access the
system from anywhere.
 To enable the Student to view as well as raise suggestion from
anywhere.
 To enable the student evolution with giving online exam and get the
result on the spot.

PURPOSE
 The project is about to handle all the information of the
student regarding course and examination. Also it manages
resources which were managed and handled by manpower
previously. The main purpose of the project is to integrate
distinct sections of the organization into consistent manner so
that complex functions can be handled smoothly by any
technical or non-technical persons.
 The project aims at the following matters:
 To manage information of student, faculty and courses.
 Consistently update information of all the students.
 Reports.
 Assistance in decision-making.

SYSTEM REQUIREMENT SPECIFICATION
 Hardware Requirement
 Processor: Any Pentium IV or compatible
 RAM: Minimum 1 GB
 Hard disk: Minimum 80 GB
 Software Requirement
 Operating System: Windows 7,ubantu
 Browser: Mozilla Firefox, Chrome, Internet Explorer
 Front End: jsp/servelet
 Back End : mysql Server

ANALYSIS PHASE
 EXISTING SYSTEM
 The existing system is manual entry of up keeping of the details of the
persons who are registered already And it is very difficult for each perso
very difficult to the students from far distance to reach the exam center.
 This system is required to prepare registration to print a lot of number
manually.
 The details of these students in a month by hand is very difficult.
 This requires quite a lot of time and wastage of money as it requires
quite lot of manpower to do that. Another factor that takes into account
that is the possibility of errors and which requires verification and
checking of data relating to various operations which is done manually.
 The limitation of existing system is that it is not all personalized. It cannot
be used for personal
 ERP System conduct the exams online without the need of going to any
physical destination.
 Even the other staff members can make quick entries if the responsible
person is not present.

ANALYSIS PHASE
 PROPOSED SYSTEM
 The modern computerized system is developed with the aim
to overcome the drawbacks of existing system.
 The new system is more personalized. It is made in such a
manner that all the new users can understand all the options in
it very easily. It is made in a quick and easy referential
manner.
 Access to all important matters are not always locked and can
be opened easily at the time of urgency.
 The advantages of proposed system are that security is
maintained in the new system.
 Securities for all important data are maintained confidentially.
 As it easily understandable and user friendly, quick entries can
be made in this system.

DESIGN PHASE
USE CASE DIAGRAM

ACTIVITY DIAGRAM
 Student module
Login
submit
validno
Successfully done
Check profile Supporting Doc
Get detail
yes
Download Document
Exam
Appear for exam
valid
login
Exam Paper
Enter user name &
password
Get Resultl
Logout

FACULTY MODULE Login
submit
valid
no
Manage students
Batches
submit
yes
Reporting
valid
login
Submit Report
Enter user name &
password
Get Mail
 Task
Task information
Successfully done Logout

TABLE NAME: STUDENT
Attribute Data Type
Constrains
DescriptionNull Key
Id Int No pri id of the student
fname varchar(20) No student firstname
lname varchar(20) No student last name
gender varchar(6) No student gender
Add varchar(50 No student address
City varchar(20) No city of the student
State varchar(20) No student state
email varchar(50) No student email
Qual varchar(10) No qualification of the student
course Int No course of the student
j_date Date No joining date of the student
mo_no Int No student mobile nu
p_no Int No student phone num
u_name varchar(30) No username of the student
Pwd varchar(30) No password of the student
status varchar(10) Yes status of the student

TABLE NAME: FACULTY_MSTR
Attribute Data Type
Constrains
Description
Is Null Key
Id Int No pri faculty id
fname varchar(20) No first name of the faculty
mname varchar(20) No middle name of the faculty
lname varchar(20) No last name of the faculty
gen varchar(6) No faculty gender
add varchar(50) No faculty address
city varchar(20) No city of the faculty
state varchar(20) No state of the facutly
email varchar(50) No faculty email detail
course varchar(25) No faculty for which course
quali varchar(10) No qualification of the faculty
exp varchar(2) No experience of the faculty
j_date Date No joining date of the faculty
m_no Int No mobile no of the faculty
u_name varchar(30) No username of the faculty
pass varchar(30) No password ot the faculty

TABLE NAME: COURSE_MSTR
Attribute Data Type
Constrains
Description
Null Key
c_id Int No pri id of the course
c_name varchar(25) No course name
b_name varchar(15) No batch name
stud_status varchar(10) No status of the student
lec_status varchar(8) No status of the lecture
f_name varchar(20) No faculty name
f_id Int No fk(faculty_mstr) id of the faculty
b_id Int No fk(batch_mstr) id of the batch

TABLE: BATCH_MSTR
Attribute Data Type
Constrains
Description
Null Key
b_id Int No pri id of the batch
b_name varchar(25) No name of the batch
b_tostud Int No total no of student in the batch
b_start Date No starting date of the batch
b_end Date No ending date of the batch
b_duration varchar(12) No time of the batch
b_progress varchar(8) No progress of the batch
b_days varchar(4) No days of the batch
b_stutus varchar(10) No batch status

IMPLEMENTATION
 Student Module
 Faculty Module
 Admin Module

VIEW, UPDATE, AND REMOVE STUDENT

ADD NEW QUESTIONS , OPTIONS AND CORRECT
ANSWER

LIMITATIONS AND FUTURE IMPROVEMENT
 The limitation of the application is more improve in online
examination. Limited questions had been stored and need more
updation and maintenance of the application.
 Storage capacity too small so that it cannot be stored large amount
of data so take back up is necessary for the future requirement. So
limited amount of data can be stored.
 A Print of the result cannot print out in this application.
 Future improvement
o Make online exam more effective, efficient and more dynamic so
that it helps to get a good support from the student.
o It has been marking while this application open in other
browser due to designing support. Its more support to Mozilla
as compare to other browser.

 Online result printing and more user interaction functionality
and features needs to be developed.
 Needs to improve more security for the purpose of the safety.

CONCLUSION
 The system has been developed with simple user
interaction, efficient and less time consuming.
 ERP has been developed and the system will
tested with proper data. The system results in
regular timing preparation of the required output to
comparison with the manual system.

ERP on School Management System

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to ERP on School Management System

Similar to ERP on School Management System (20)

More from Amit Gandhi

More from Amit Gandhi (20)

Recently uploaded

Recently uploaded (20)

ERP on School Management System