Please drop a STAR🌟 if you like my work and fork it if you want any further assistance.

College ERP🏫 in REACTJs

• This is a simple college erp web app in MERN stack,it consist of all the basic CRUD operations.
• All the fields (students,teachers,class,exams) can be edited via the admin panel.

Prerequisites 🧾

• MongoDb- Install mongodb GUI on your machine.
• Nodejs - Install nodejs.
• Yarn- If npm fails yarn works as a fail safe.

Features 👓

• Create new students.
• Create new teacher.
• Create new exam.
• Create new user and assign permissions and roles.
• Create new course.
• Students, Teacher are in one-to-many relations in database.
• Exam, Course,admin are in mant-to-many realtions in database.

Instructions👨‍🏫

• Open project folder in a terminal or prefered IDE .
• Perform "npm install " or "yarn install".
• Type npm "start-script build" this will make a html and manifest file in client/build folder to render on a browser.
• Once node_modules are downloaded type "npm start" or "yarn start" to start the server on prescribed port.

Screenshot 📷

SCHEMA

• USER

ID	Primary Key	Required	Unique
Mail	String
name	String
password	String	✔	✔
roles	String
surname	String
username	String	✔	✔

• COURSE

ID	Primary Key	Required	Unique
Name	String	✔

• EXAM

ID	Primary Key	Required	Unique
Place	String
Score	Number
Valid	Boolean

• Relations

_course	_student	_teacher
course	student	teacher
one-to-many	one-to-many	one-to-many

• STUDENT

ID	Primary Key	Required	Unique
DOB	Date	✔
lastname	String	✔
name	String	✔

• Relations

_course
course
many-to-many

• TEACHERS

ID	Primary Key	Required	Unique
lastname	String	✔
name	String	✔

• Relations

_course
course
many-to-many