International Journal of Scientific Research in Computer Science, Engineering and Information Technology

ISSN : 2456-3307 (www.ijsrcseit.com)

doi : https://doi.org/10.32628/CSEIT217337
College ERP Using MERN Stack
Shubham Patil, Saurav Daware, Ameya Bhagat, Prof. Jayant Sawarkar
Department of Computer Engineering, Datta Meghe College of Engineering, Airoli, Navi Mumbai, Maharashtra, India

ABSTRACT

Article Info This paper is aimed at developing an Online College Management System that is
Volume 7, Issue 3 of importance to the educational institute or college. This system is named
Page Number : 190-196 College ERP using MERN stack. This system may be used to monitor college
students and their various activities. This application is being developed for an
Publication Issue : engineering college to maintain and facilitate ease of access to information. For
May-June-2021 this the users must be registered with the system. College ERP is an Internet
based application that aims at providing information to all levels of management
Article History within an organization. This system is used as an information management
Accepted : 10 May 2021 system for the college. For a given student and staff (technical and non-
Published : 16 May 2021 technical) can access the system to either upload and access some information
from the database.
Keywords : MERN, ERP, MongoDB

I. INTRODUCTION based on MongoDB whereas Mongoose will help

Node.js communicate with the database.
The title of the project is “College ERP using MERN
stack”. College ERP is defined as an application based II. PROBLEM DEFINITION
on ternet that aims at all levels of management
providing information within an organization. This The existing system which we are using in our
system can be used as an information management college is a traditional process and is a complete
system for the college. manual process. Now-a-days, education is playing a
very significant role in society. Day-by-day, the
For a given student/staff (Technical / Non-technical) percentage of illiterates are decreasing and the
theAdministrator creates a login id & password, using percentage of literates is increasing. Education will
these students/ staff (Technical / Non-technical) can change society in all aspects and everyone wants to
access the system to either upload or download some study higher professional degrees. Admissions are
information from the database. increasing day by day so the ratio of establishment of
new colleges and schools are also increasing. But the
The front end will be a React Based javascript actual challenge is starting from now. Most of the
application whereas the server will run on Node.js schools and colleges maintain student information in
using Express.js. The database side of things will be records.

Copyright: © the author(s), publisher and licensee Technoscience Academy. This is an open-access article distributed under the 190
terms of the Creative Commons Attribution Non-Commercial License, which permits unrestricted non-commercial use,
distribution, and reproduction in any medium, provided the original work is properly cited
 Shubham Patil et al Int. J. Sci. Res. Comput. Sci. Eng. Inf. Technol, May-June - 2021, 7 (3) : 190-196

When the number of records increased, it was are also increasing. But the actual challenge is
difficult to maintain the information of each student starting from now. Most of the schools and colleges
in the old manual system. Maintaining the records maintain student information in records.
manually leads to error prone and requires more man
power and it consumes more time for processing the When the number of records increased, it was
records. difficult to maintain the information of each student
in the old manual system.
III. Aim and Objective
Maintaining the records manually leads to error
The main objective of developing the current project prone and requires more man power and it consumes
entitled “College ERP using MERN stack” is to build more time for processing the records.
an effective system which is fast, accurate, consistent,
reliable and flexible enough so that it can incorporate V. Requirement Analysis
any future enhancements.
Software Requirements
By automating the system using computers,
sophisticated technology can be used for making the We need the following software to accomplish our
information more flexible, accurate, and secure and project.
user friendly.
1. Writing Code (Sublime Text)
Time and manpower can be more effectively utilized 2. MERN Stack
and online information can be easily available to the a. MongoDB: A cross-platform
user and at the same time we can maintain a higher document database.
level of security. b. Express: A back-end web application
framework.
Every user such as student, staff and administration is c. React: A JavaScript library for
able to see the information of each student online building user interfaces.
from anywhere and anytime. d. Node.js: A cross-platform JavaScript
runtime environment.
IV. Literature Review

Until recently the place of the College Management

System (CMS). Now-a-days, education is playing a
very significant role in society. Day-by-day, the
percentage of illiterates are decreasing and the
percentage of literates is increasing. Education will
change society in all aspects and everyone wants to
study higher professional degrees.
Figure 1. MERN stack
Admissions are increasing day by day so there by.
Ratio of establishment of new colleges and schools 3. Web Browser for accessing the website.

Volume 7, Issue 3, May-June-2021 | http://ijsrcseit.com 191

 Shubham Patil et al Int. J. Sci. Res. Comput. Sci. Eng. Inf. Technol, May-June - 2021, 7 (3) : 190-196

Hardware Requirements

We will need the following hardware to accomplish

our project.

1. Desktop or Laptop PC with Windows 10

64bit with 8GB Ram and atleast 2GB of free
space.
2. Android or iPhone that can run the latest Figure 3. Admin Dashboard
version of web browsers like Chrome, Safari
or firefox.
These are the various modules available for the
VI. Project Design and Modules admin.
1. Students
Login Page 2. Faculty
3. Departments
Login Page will be used to authenticate various users 4. Branch
that will be using the system. 5. Course
6. News
7. Timetable
8. Payment
9. Messages

Figure 2. Login Page

Figure 4. News Page
Admin Dashboard

This page will provide admin with the tool to

manage all the students and faculties as well as other
tools.
Figure 5. Students Information

Volume 7, Issue 3, May-June-2021 | http://ijsrcseit.com 192

 Shubham Patil et al Int. J. Sci. Res. Comput. Sci. Eng. Inf. Technol, May-June - 2021, 7 (3) : 190-196

Figure 10. Login DFD

Figure 6. Student Subject Enrollment

Figure 11. 1st level DFD Admin

Figure 7. Timetable Management

Figure 8. Attendance Page

Figure 12. 2nd Level DFD Admin

Figure 13. Student data Flow

Figure 9. MongoDB Compass

Volume 7, Issue 3, May-June-2021 | http://ijsrcseit.com 193

 Shubham Patil et al Int. J. Sci. Res. Comput. Sci. Eng. Inf. Technol, May-June - 2021, 7 (3) : 190-196

As a multi-paradigm language, JavaScript supports

event-driven, functional, and imperative
programming styles. It has application programming
interfaces (APIs) for working with text, dates, regular
expressions, standard data structures, and the
Document Object Model (DOM).

Figure 14. Student 2nd Level DFD MERN stack: The MERN architecture allows you to
easily construct a 3-tier architecture (frontend,
VII. Technologies Used backend, database) entirely using JavaScript and
JSON.
HTML: The HyperText Markup Language, or HTML
is the standard markup language for documents
designed to be displayed in a web browser. It can be
assisted by technologies such as Cascading Style
Sheets (CSS) and scripting languages such as
JavaScript.

CSS: Cascading Style Sheets (CSS) is a style sheet

language used for describing the presentation of a
document written in a markup language such as
HTML. CSS is designed to enable the separation of Figure 15. MERN Stack
presentation and content, including layout, colors,
and fonts. This separation can improve content React.js Front End
accessibility, provide more flexibility and control in The top tier of the MERN stack is React.js, the
the specification of presentation characteristics, declarative JavaScript framework for creating
enable multiple web pages to share formatting by dynamic client-side applications in HTML. React lets
specifying the relevant CSS in a separate .css file you build up complex interfaces through simple
which reduces complexity and repetition in the Components, connect them to data on your backend
structural content as well as enabling the .css file to server, and render them as HTML.
be cached to improve the page load speed between
the pages that share the file and its formatting. Express.js and Node.js Server Tier
The next level down is the Express.js server-side
Javascript: JavaScript is one of the core technologies framework, running inside a Node.js server.
of the World Wide Web. Over 97% of websites use it Express.js bills itself as a “fast, unopinionated,
client-side for web page behavior, often minimalist web framework for Node.js,” and that is
incorporating third-party libraries. All major web indeed exactly what it is. Express.js has powerful
browsers have a dedicated JavaScript engine to models for URL routing (matching an incoming URL
execute the code on the user's device. with a server function), and handling HTTP requests
and responses.

Volume 7, Issue 3, May-June-2021 | http://ijsrcseit.com 194

 Shubham Patil et al Int. J. Sci. Res. Comput. Sci. Eng. Inf. Technol, May-June - 2021, 7 (3) : 190-196

MongoDB Database Tier We would like to grab this opportunity to thank Dr.
If your application stores any data (user profiles, S. D. Sawarkar, principal for encouragement and
content, comments, uploads, events, etc.), then support he has given for our project.
you’re going to want a database that’s just as easy to
work with as React, Express, and Node. We express our deep gratitude to Dr. A. P. Pande,
head of the department who has been the constant
That’s where MongoDB comes in: JSON documents driving force behind the completion of this project.
created in your React.js front end can be sent to the
Express.js server, where they can be processed and We wish to express our heartfelt appreciation and
(assuming they’re valid) stored directly in MongoDB deep sense of gratitude to my project guide Prof. J. D.
for later retrieval. Again, if you’re building in the Sawarkar for his encouragement, invaluable support,
cloud, you’ll want to look at Atlas. If you’re looking timely help, lucid suggestions and excellent guidance
to set up your own MERN stack, read on! which helped us to understand and achieve the
project goal. his/her concrete directions and critical
VI. CONCLUSION views have greatly helped us in successful completion
of this work.
College ERP Management using MERN Stack
provides an easy way to automate the functionalities We extend our sincere appreciation to all professors
of the college. It is an integrated platform that for their valuable inside and tips during the designing
connects various departments of an institution like of the project. Their contributions have been
administration, staff, students as well as guardians. It valuable in so many ways that we find it difficult to
provides reliability, time savings, and is easy to acknowledge them individually.
control. Information can be saved and can be
accessed at any time by an authorized user. It We are also thankful to all those who helped us
includes almost all modules required for seamless directly or indirectly in completion of this work.
college functions.
VIII. REFERENCES
These modules include attendance management,
railway concession system, training and placement, [1]. https://www.slideshare.net/mohit0749/college-
staff details, staff records, etc. It also facilitates management-system-project-48367405
exploring various events happening in the college [2]. https://1000projects.org/college-management-
such as exams, practical, submission, placements, system-cms.html
annual events in the form of notifications. [3]. (PDF) A Research Paper on College
Management System | suraj kumar -
VII. ACKNOWLEDGEMENT Academia.edu
https://www.academia.edu/35401042/A_Resear
Motivation and guidance are the keys towards success. ch_Paper_on_College_Management_System
I would like to extend my thanks to all the sources of [4]. MERN Stack
motivation. https://www.geeksforgeeks.org/mern-stack/
[5]. https://www.ijarcce.com/upload/2013/june/4-
shobha%20bharamaoudar-

Volume 7, Issue 3, May-June-2021 | http://ijsrcseit.com 195

 Shubham Patil et al Int. J. Sci. Res. Comput. Sci. Eng. Inf. Technol, May-June - 2021, 7 (3) : 190-196

WEB%20BASED%20STUDENT%20INFORMA
TION.pdf
[6]. https://en.wikipedia.org/wiki/HTML
[7]. https://en.wikipedia.org/wiki/JavaScript
[8]. https://en.wikipedia.org/wiki/CSS
[9]. https://www.mongodb.com/mern-stack
[10]. https://sites.google.com/site/ignoubcafinalyearp
rojects/project-report/college-management-
system-project-
report?tmpl=%2Fsystem%2Fapp%2Ftemplates
%2Fprint%2F&showPrintDialog=1

Cite this article as :

Shubham Patil, Saurav Daware, Ameya Bhagat, Prof.

Jayant Sawarkar, "College ERP Using MERN Stack",
International Journal of Scientific Research in
Computer Science, Engineering and Information
Technology (IJSRCSEIT), ISSN : 2456-3307, Volume
7 Issue 3, pp. 190-196, May-June 2021. Available at
doi : https://doi.org/10.32628/CSEIT217337
Journal URL : https://ijsrcseit.com/CSEIT217337

Volume 7, Issue 3, May-June-2021 | http://ijsrcseit.com 196