---ACMS (Admission Coaching Management System)---
This project was made with the goal of creating a platform for students,teachers,managements and admin (of a coaching center) so that they can use it to maintain all their current, previous and possibly fututre records.
This project has four major pannels - admin, manager, teacher, student all of which is made for its corresponding users keeping their most basic and important tasks in mind.
An admin can use this to view, update, add data of branches, manager of those branches, courses, subjects, overall exam and result publishing and batches of all the branches of the coaching center.
Managers can use this to approve new teachers and students to their assigned branches or delete and manage the ones who are already approved.
Teachers may use this to manage results of all the students of a branch of their assigned branch and also remain informed about the most updated routine assigned to them.
Students may use this to keep a track of their assigned subjects, upcoming results or classes of the whole week, their own performances on all the previous exams.
Almost all the data was shown in the project using inner join or other forms of joins between two or more tables and all of them were updated when any data was changed by the users. For more convenience search feature was added in each of the pannels.
---Executing The Project---
In order to use this project, a database named ACMS has to be created in the microsoft SQL server. The database and all necessary tables can be created executing the file "ACMS_Queries.sql" included in the zip file. After successfully creating the database one can run the project and select a pannel from the four given options and sign in with proper credentials. In the given database data these credentials are:
ADMIN=> userid: 000001 pass : 123456
Manager=> userid: 2022020001 pass : 123456
Teacher=> userid: 2022030001 pass : 123456
Student-> userid: 20220400001 pass : 123456
---Made and Submitted by---
Animesh Das Chowdhury ID - 190204058
Tonmoy Banik ID - 190204059
Mohammad Tanveer Shams ID - 190204060
MD. Maruf Rusafi Arnob ID - 190204088