Please drop a STAR🌟 if you like my work and fork it if you want any further assistance.
- 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.
- MongoDb- Install mongodb GUI on your machine.
- Nodejs - Install nodejs.
- Yarn- If npm fails yarn works as a fail safe.
- 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.
- 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.
- USER
| ID | Primary Key | Required | Unique |
|---|---|---|---|
| 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 |