Author:- Baljinder Singh
Aim of project is to make a management system for School to loging in as admin, staff, Student and use oprations like Number of students, Number of staff members, Checking result and attendence of students and adding new student ,new staff member then there is an option for signing up to register your self to use those features.
- Java(jdbc)
- Mysql
Intellij IDEA
- Login
- signup
- Admin
- Staff
- Student
1. List of staff members
2. List of Students
3. View result of specific student
4. Updating marks of student
5. View attendence of student
6. Update attendence of student
7. Add staff member
8. Add students
1. List of student
2. view result of student
3. Update result of student
4. View Attendence of student
5. Update attendence of student
6. Add student
1. View Report
2. View Attendence
The database schema used in program is "login"
Stores all login information with columns
1. username
2. passcode
3. id
4. Pofession
Stores all info of Staff members with colums
1. Name
2. Id (auto genrated,primary)
3. Age
4. Subject
5. Stream
Stores all info of Students with colums
1. Name
2. Id
3. Age
4. address
5. Stream
Stors attendence of student with colums
1. Name
2. Id
3. Present
4. Absent
5. Percentage:-derived ((Present*100/(Present+Absent)))
stores result of student with colums
1. Name
2. Id
3. Physics
4. Biology
5. Maths
6. Accounts
7. Buiness Studies
8. Chemistry
9. Computer
10. Total :- derived (Physics+Biology+Maths+Accounts+Buiness Studies+Chemistry+Computer)
11. Percentage :-derived (Total*100)/400