System Analysis and Design for Student Hostel Management System Project

Introduction

PURPOSE

The purpose of this SRS & System Analysis and Design document is to build a Hostel Management System Site to help students book hostel rooms at their own convenience, file complaints, and write reviews about the room.

INTENDED AUDIENCE AND READING SUGGESTIONS

The Hostel Management System project is useful for both students and hostel committee members.

PROJECT SCOPE

The purpose of this Hostel Management System is to ease hostel management and to create a convenient and easy-to-use application for students. The system is based on a relational database with room allotment, review, and complaint features.

The Application will be able to perform the following operations:

  1. Allot Rooms: Students will be able to choose hostel rooms according to their convenience and pay for the same.
  2. File a complaint: Students will be able to file a complaint regarding any of the facilities and if the complaint could not be resolved within the specified time, it would be sent to the higher authorities.
  3. Review the rooms– Seniors who have already stayed in the room will get an option to review a room in which they can upload the room pictures and write about the problems(if they had faced any).

Mess: Students will be able to pay the hostel fees, see their past payments and write reviews about the food and management.

ANALYSIS

Specific requirements

External Interface Requirements

User Interfaces

The goal of this Hostel Management System is to design the web application that will be used for the proper management of hostels. The user types are listed below-

  • Students
  • Hostel Committee
  • Mess Committee

ER Model

Hostel Management System ER Diagram

DESIGN

RELATIONAL SCHEMA

  1. Users
  2. Reviews
  3. Writes rev
  4. Rooms
  5. Complaints
  6. Writes com
  7. Student

USER INTERFACE DESIGN

GOAL

MAKE INTERFACE

  1. Pleasing to the eye.
  2. Simple to Use.
  3. Minimize the effort it takes for users to accomplish the work.

PRINCIPLES OF USER INTERFACE

  1. Layout
  2. Content Awareness
  3. User experience
  4. Consistency
  5. Minimize user effort

VARIOUS USER INTERFACES

  • HOME– It includes navigation among different pages. Starting with registration and login and address of other pages.
  • REGISTRATION/log in If you are a new user you have to register and if already a user only login is sufficient. After registration and login user will be redirected to the home page.
  • ROOM ALLOTMENT– After logging in it is necessary for the user to fill room allotment form if the room is already booked user will be redirected to the allotment form.
  • DASHBOARD– After booking the room user can see the status in the dashboard including username, scholar no and room booked.
  • REVIEW A ROOM – The user can review the room he is allowed only after login. This page is accessible only when the room is allocated. The review includes the description and the photo of the room. After the submission page is directed to another page from where the user can view his review and even delete it.
  • VIEW YOUR REVIEW– It keeps the track of the user’s reviews.
  • REVIEWS OF ROOMS– Before booking the room the user can view the review of various rooms.
  • COMPLAINTS– After room allotment, if the user requires to file any complaint he can register his complaint.
  • YOUR COMPLAINTS– It keeps a record of all the complaints filed by the user.

FLOWCHART

Hostel Management System Flow Chart Diagram

CONCLUSION

Till now, room allotment is done manually and physical presence is also required for the same. Students have to come a few days prior to the beginning of classes in order to select rooms. Hence this particular project deals with the problems of managing a hostel and avoids the hecticness of carrying out tasks manually.

Online Grocery Management Store PHP & MySQL Database Project

The main objective of this Online Grocery Management Web application is to provide an online product/ grocery purchasing website. Everyone needs food to survive. If someone wants to cook food even by themselves, they’ll first have to go to some grocery store, buy items, and carry all that heavy load of raw materials themselves to their home. That’s where an online solution can help so we have implemented the Online Grocery Store web application. All one needs to do is order everything they need for their cooking requirements online and relax till it gets delivered to their homes.

Online Grocery Store Challenges:

  • To keep a record of existing users, allow for the addition of new users, and removal of existing ones, and maintain several of their addresses
  • To maintain a catalog of available products, and categorize products into different types, and manufacturers
  • To maintain a cart for every user (one per user), and also all the orders he has done in the past, each order having multiple products, alongside the quantity they are available in.

Features of the Online Grocery Store project, and our plan to overcome the challenges mentioned above:

  • We will create tables for the user, address, product, category, manufacturer, order, cart, and product_order. E-R analysis is submitted along with this description.
  • The above model will be modeled in the form of tables and stored in SQL-based RDBMS, preferably MariaDB.

Wish List (features to be included if time permits)

  • To implement a user interface for addition, updation of products, manufacturer, etc.
  • To provide discounts for bulk orders, sales, etc.

Tables for Database Design:

User

  • User_Id
  • Email_Id

Password

  • First_Name
  • Last_Name
  • Mobile_no

Address

  • Address_id
  • Address_1
  • Address_2
  • Zip_Code
  • City
  • State
  • User_Id

Product

  • Product_id
  • Product_Name
  • Units
  • Picture
  • Weight
  • Category_id
  • Price
  • Product_Description
  • Manufacturer_id

Category

  • Category­_id
  • Category_description
  • Category_Name

Manufacturer

  • Manufacturer_id
  • Manufacturer_Name

G_Order

  • Order_id
  • Payment_Method
  • Order_time
  • Billing_id
  • Amount
  • Shipping_id
  • Address_id
  • User_id

Cart (User_Product)

  • User_id
  • Product_id
  • Quantity

Product_Order

  • Product_id
  • Order_id
  • Quantity
  • Price (of 1 unit)

ER Design Diagrams:

ER Diagram for Grocery Store Project

Functional Dependencies:

1) User Table
2) Address Table
3) Product Table
4) Category Table
5) Manufacturer Table
6) Grocery Order Table
7) Cart Table
8) Product Order Table

Other similar Projects on the amazon Ekart System:

We intend to create an amazon Ekart System with features also whilst incorporating all the amazing features that could be seen on amazon’s official website and more.

Goals:-

  • Homepage: The Landing/Homepage offers various navigating features including shopping, menu, finding products, add-to-cart payment, etc., as shown in the image above.
  • Shopping: schedule your delivery with UPI pay.
  • Rewards: provide a program membership offer by incorporating sign-in features and provide free delivery on some products.
  • Careers: facility to explore career paths by imparting internships and apprenticeships and jobs by logging in/registering on the portal and providing too many jobs in many different ways.
  • Payment and cashback offer to make payment via this app – amazon pay.
  • Delivery: Accepting the orders and delivering them to the user’s doorstep.

Pages:-

  • Login page.
  • listing page
  • Profile page
  • Prime page
  • Sign in with the prime page
  • Payment with prime page
  • Payment page
  • Order page

Technologies To Be Used:

1. Front-End:

  • HTML5
  • CSS3
  • Bootstrap
  • javaScript
  • Reactjs

2. Back-End:

  • Nodejs
  • Expressjs

3. Database

  • MongoDB

Students Solution an E-learning-based platform Project

The project Students Solution is a website that is an E-learning-based platform project and it will help the first-year students of B.Tech (All Branches). In this, we will build a Students Solution site. After creating the Students Solution site, you will be able to take notes for your corresponding subjects which were provided by the developers, and you are also able to practice your basic knowledge with the help of a quiz Which was in this website we also provide some blogs which were helpful to motivate students for deeper knowledge and extracurricular activities.

This technology helps you to provide the best notes on your subject bases and gives extra knowledge along with your course.

It provides a convenient solution to the traditional notes-making system. We follow a modular approach to learning through our website.

About the Project

This Students Solution project aims to make a website for first-year students of our university. This is an e-learning website where first-year students of our university will get ready-made notes. Our website “Students Solution” is to automate the existing manual system with help of ready-made notes, fulfilling first-year students’ requirements so that they can receive a valuable education. This means no need to worry about making handwritten notes. And they can utilize their time up to the maximum. It is a need for time to switch to e-learning.

Motivation

When we joined the university we faced a lot in our very first year due to a lack of proper subject material and guidance after class. So we are thinking of developing a “Students Solution” website where first-year students of our university will get all the subject notes and materials.

To help the first-year students we are working on this project “Students Solution” so that they can feel free and study well.

Objective

The main objectives of creating the Students Solution, We will provide all the notes regarding your subject and quizzes regarding that particular subject which provide you the basic knowledge of that particular subject and we will also give vlogs to fresher’s to motivate themselves for extracurricular activities.

The main objectives are :

  • To provide a quality-based education.
  • To provide ready-made notes.
  • I-Q Test

Implementation Details

Part 1: To build a Backend of the website in which notes are to be attached.
Part 2: Develop a site for quizzes regarding that particular subject.
Part 3: To build the information of developers.
Part 4: Provide vlogs to motivate students for extracurricular activities.

FUTURE PROSPECTS

  • We will add video lectures.
  • Live classes would be there.
  • We provide all the material for different disciplines.
  • The test series will be there.
  • Gaming will be there for entertainment.

Requirements

Software Requirements (Minimum):

  • Windows 10
  • Visual Code Studio
  • Xampp

TECHNOLOGY USED

  • HTML
  • CSS
  • JAVASCRIPT
  • PHP
  • MYSQL

Development of Electricity Information System BCA Final Year Project

This is the BCA Final Year Project website related to electricity information systems developed with PHP and MySQL databases. In which users can see the problem related to the electricity in a particular area. Users also can complain about electricity-related problems like a complaint about the transformer, electricity problems at home, wire damage and overload of the powerhouse, etc.

Users can also see the information related to the Main powerhouse and its sub powerhouses like can take the information of the Senior Engineer and Junior Engineer of the corresponding powerhouse, can also check the load of the powerhouse and its number of workers.

Users can aware of the latest updates related to electricity and can take advantage of the latest information according to need.

The main purpose of the Electricity Information System website is to connect users directly with the administrator and for complaints related to Electricity.

OBJECTIVES:

Location of Electricity– In which can see the place where the problem occurs in electricity.
Duration in rectifying Electricity problem– can update with the electricity rectification timing, and how much time is taken to rectify the electricity problem.
The report related to Electricity– Make a report related to complaints and report related to whole information about powerhouse.
Query related to electricity– The user can query related electricity problems and related JE of the powerhouse and its workers.

Data Flow Diagrams:

Level 0 & 1 DFD below:

Electricity Information System Level 0 & 1 Data Flow Diagram

Level 2 DFD below:

Electricity Information System Level 2 Data Flow Diagram

ER Diagram Below:

ER Diagram of Electricity System

MODULES

The proposed Electricity Information System project will have its main page and modules as:

  • Login Module.
  • Admin master module.
  • Search module.
  • Validation handler.
  • Report Generation module.
  • Response master module.

Software Requirements:-

WAMP Server
Text Editor: (Sublime, Dreameviewer)
Front-End: HTML, CSS
Back-End: MySQL, PHP

Scope of the Project

Scope of the Electricity Information System project gives Sartnesss to the village, town areas, and also for the powerhouse admin.

Applications

  • This Electricity Information System application can be used in power stations so that they can save time, and reduce headaches.
  • Users also can update with the electricity changes.
  • Easy to complain About the electricity situation.
  • Electricity will be live on the network.

Online College Complaints Suggestions and Compliances PHP Project

“Online Complaints, Suggestions, and Compliances” is a website and through this project, we have learned to design webpages using HTML, CSS, JavaScript, and PHP. It has enabled us to have a deeper understanding of how frameworks help in the development of websites.

Thus, in this College Complaints Suggestions and Compliances project, we have acquired a lot of knowledge about various technologies in web development. We have explored many new concepts on the web, such as JavaScript and AJAX.

Solving these problems must be quick and transparent. Often, Students shy away from writing complaints and suggestions into the box, as students are afraid of peer views of their actions.

Problem Statement:

A College Complaints Suggestions and Compliances Web Application to allow students to raise complaints and suggestions transparently without exposing their identity.

The Objectives of this application are:

  • Allows students to log in with E-mail verification before submission of complaints and suggestions
  • Allows students to track their submissions from their portal
  • Allows teachers to reply and change the status of the submissions without exposing student’s USN
  • Provides a pie chart representing the types of submissions
  • Admin can block submissions using foul languages

Steps Involved:

Step 1: The web application loads the home page. With options of Student, Teacher, and Admin
Step 2: On selecting Student, the user must first log in using the login page. On successful login, the user is greeted with the student portal.
Step 3: The student portal allows users to check the status of the previous complaints, and suggestions.
Step 4: Students can click to submit complaints and suggestions, after the verification page using email verification.
Step 5: The student can click on the logout option and is then taken to the login page, which has the option to return to the home page
Step 6: On clicking the teacher option on the home page, the teacher has to log in. They are then taken to the teacher’s home page. The teacher can choose to view complaints and suggestions.
Step 7: On clicking on a complaint/suggestion is taken to the auction page. Where the teacher can change the status of the complaint with the option to reply.
Step 8: After replying, the teacher is taken back to the teacher’s home portal. On logging out, you are taken to the login page, with the option to be redirected to the home page
Step 9: On clicking the Admin option on the home page, the admin has to log in. They are then taken to the Admin home page. Admin can choose to view complaints and suggestions which are blocked due to the use of foul language. After allowing or disallowing the admin is returned to the Admin home portal. On logging out, you are taken to the login page, with the option to be redirected to the home page.

Functionalities

Login: This module allows students, teachers, and Admin to log in with different access to web pages and controls. The username and hash of the password are compared with the Tables stored in the Database.

Signup: This module allows students, teacher, and Admin to register their access to the web application. By signing up the user is registered in the Database, so that their login credential is saved for future logins.

Complaint and Suggestion Form: This module allows students to fill up complaints or suggestions. Before uploading to Database. It checks for any foul language violation. It marks the entry to be checked by the admin, before allowing it to be viewed by the teacher.

Student Submission view: This module allows students to view the status and reply to their complaints or suggestions previously raised. On clicking the user can re-open a submission.

Verification: Students have to enter the One-time password (OTP) sent to their email to verify the authenticity of the complaint and suggestions. This module is implemented using PHPMailer Library.

Teacher submission view: This module allows concerned teachers to view the complaints and suggestions without revealing students’ USN. On selecting a submission, the teacher can update the status, reply to the same, and notify the same to the student’s email.

Admin unblock submission: Display submissions flagged due to misuse of the platform. Allows admin to unblock the submission if it is appropriate, and updates the same in Database.

Application

  • This application can be used in all colleges to collect Complaints and suggestions
  • It can be viewed by a teacher without relieving student’s use
  • Students get updated by their emails when the status of their submissions changes
  • The teacher can view a pie chart representing the type of submission. So, they can concentrate on a given area
  • Submissions using foul language are blocked and are reviewed by Admin

Conclusion

The internet is a very powerful platform for people to share their views in confidence. This Web Technology Mini Project draws further on the notion of the same lines, allowing Students to place complaints and suggestions without relieving their identity. Colleges and institutions improve from the useful insights provided through our platform. Thus, allowing them to understand the needs of students wholesomely.

Related Projects Ideas on College Students Complaints Suggestions and Compliances System:

Blood Bank Management System DBMS Mini Project

The main purpose of the PHP & MySQL-based blood bank management web application system DBMS mini project is to provide the blood bank with an easier way to store and retrieve data and keep a record of the availability of blood in the blood bank.

After inserting the data into the database, staff need not register the same person again. They can simply search for recorded data and retrieve them for future blood donation or receiving purposes of that person.

In the nutshell, it can be summarized that the future scope of the project circles around maintaining information regarding:

  • The person can fix their donation schedule using an online reservation for the donation of blood.
  • The person can search for the availability of required blood in the local blood bank in the case of an emergency.
  • The blood bank stores the details of the blood donated by a person, like RBC, WBC, platelet count, etc.

The above-mentioned points are the enhancements that can be done to increase the applicability and usage of this project.

E-R diagram of the blood management system

E-R diagram of blood management system

MODULE DESCRIPTION

the list of modules incorporated with the “blood management system” is:

Login module:

This module is for employees of blood banks to log in so that only they can access the database.

Person module:

This module is used to store all the personal details of the donor or receiver.

Donor module:

This module is used to record the date and time along with the quantity of blood donated by a person. Personal details are accessed using a personal ID.

Receiver module:

In this module date and time, the quantity of blood received along with hospital details is recorded.

Stock module:

Here we can check the availability of each blood group blood.

RESULT AND ANALYSIS

Home Page of blood bank management system
The login page shows the login page, if the user wants to log in, they must enter a valid/registered username and password and click on the login button.

The home page shows information about the blood bank management system.

Add person page shows the Add person page, here details of the donor/receiver are registered.

Add person page shows once the entry of personal details is done.

The search person page shows the result of the search we have done. If we enter the person’s id it will return all the personal records present in the database.

The donation page shows the New donation page, here person id and units of blood donated are recorded, and submit button is clicked. On successful completion of entering it displays “Your donation is successful”.

Receive page shows the New Receive page, here person id, units of blood donated, and hospital details are recorded, and submit button is clicked. On successful completion of entering it displays “Your receiving is successful”.

Check the Stock page shows the stock details i.e units of blood present in the blood bank of each blood group.

The donation History page shows the Donation history page, the user has to give the time interval from when he wants to see the donation history details. Upon clicking submit he shows the donation history. If there is a donation that took place at that time interval it displays “No record found in the specified time interval”.

Receive History page shows the Receiving history page, the user has to give the time interval from when he wants to see the receive history details. Upon clicking submit he shows the received history. If there is receiving of blood that took place at that time interval it displays “No record found in the specified time interval”.

Add user page shows the add user page, where it asks for the super admin password. Next, you have to enter the new username, and password and confirm the password. Click on create user button. If the super admin password is wrong or the password and confirms password don’t match. It will pop an invalid password. On successfully creating a user it will display “New user created successfully”.

Download the complete Blood Bank Management System DBMS PHP & MySQL Project source code, project report, and execution steps here.

Alumni Management Portal for Educational Institutions PHP Project

This Alumni Management Portal project aims to develop a platform for the Educational Institutions to maintain communication between faculty, alumni, and students. The main objective of this PHP & MySQL web application is to enhance or improve employability opportunities for students, organize alumni lectures and events, and increase networking skills and opportunities for students.

INTRODUCTION

Our Institutional Alumni Management Portal project is a web-enabled application through which administrators, students, and alumni will be able to continuously communicate. For this, we need an application that is user-friendly. The needs of all three users of the portal should be covered.

Administrators can log in, maintain, verify and manage alumni and student records, and create events and group chats. Administrators can also generate reports in excel and pdf format and view placement statistics of the institute. Once an event is created, all the alumni and students registered on the portal will receive emails automatically.

Alumni can log in, register, update their details, view events, participate in group chats, and post job opportunities and materials. Students can log in, register, view details of alumni, register for events, download materials posted by alumni, job materials posted by alumni, and participate in group chats with other alumni and students.

The below figure shows and explains the Architecture Diagram of the Alumni Management Portal website.

Architecture Diagram of Alumni Management Portal

Objectives

To build a responsive Educational Institutions Alumni web application to manage and track students and alumni of an educational institute and build a portal that facilitates continuous communication.

Organization of Project

We have three modules in our project.

● Admin
● Alumni
● Student

Alumni management portals can be used by educational institutes to maintain and manage records of alumni and students of the respective institute in an efficient manner. It leads to better outcomes in terms of student placement opportunities, and knowledge transfer and improves the structure of communication between current students and alumni thereby increasing networking skills and opportunities.

In traditional methods where student data is manually stored, a lot of time is wasted doing redundant and repetitive work. Here storing data, statistics, and report generation all are automated. Furthermore, there is no need for paperwork since everything is done online and stored in a refined database.

The output screenshot of the project explains about “Test case check whether the admin is able to view all users”

All Users List of Alumni Management Portal Project

Online Platform for adding Student Classroom Notes PHP Project

Introduction:-

This Student Classroom Notes web application has helped to take only important notes in a relevant way. No user needs to spend more time taking notes. It’s a very easy way to take notes. Any kind of user can upload their notes at whatever time they want. It takes very less time to open the ”Student Classroom Notes”. Due to the very easy design of these apps, school students can also use this app to take their notes inefficient manner.

Importance and need of Student Classroom Notes:-

As it is developed for user-friendly so any sort of user can add their notes from any educational platform. They needn’t need go through any other online-offline software. These iNotes apps help to take the key point of important notes. As we are in this technical world so hard copy notes are not portable. There is a lot of chance of losing notes so this app makes the free risk of losing notes. User can keep their notes for future reference without any risk.

The motto:-

The main motto of this project is to the user can add or upload notes easily and very quickly as other software.
User can modify their notes in a very easy manner compared to other software.
Notes repositories are available in the form of a table manner so it is easy to identify your notes without wasting your time.
Users can log in from any location and upload notes and can share too.

Requirement Gathering:-

“Student Classroom Notes” is developed for all kinds of users from higher levels to lower levels. Many students and people do not want to take their notes with themselves every time. To remove such sort of problems, this “Student Classroom Notes” App been developed.

Working Principles & Methodology:-

In this project “Student Classroom Notes” every user has a username and password to access these Apps and can keep their notes personally.
He/she can keep their notes with the Title name and description so that the user can easily recognize the notes he/she uploaded.
This is very easy to identify their notes repositories on the home screen itself.
The user can easily search their notes in the search bar and filter too.

Software requirements:-

  • Operating System- windows10
  • Visual studio code
  • PHP
  • Google Chrome
  • MySQL database
  • Xampp Control panel (for local server)

We will be using visual studio code basic as our front hand because it is easier to use and provides features to the users which are used for the development of the project.

Future Scope & Conclusion:-

This web application has almost all the features of CRUD and smart online/offline notes taking.
The project has altos benefits. Managing the project is quite easy as per storing the notes. It is easy to maintain notes and update them as required.
As we know that technology is increasing day by day so hard copy note-taking will be decreased, at that time it will helpful for those who will use this app.
Still, some additional features are not added to the apps. As we are seeking features, if it’s required we will add them as soon as possible.

Hope every user has a clear idea of using our “Student Classroom Notes” Apps.

Student Exams Backlog Management System Project using PHP & MySQL

The main aim and objective of the Backlog Management System project are to provide the subject Backlogs to the student in a college in a simple way with the help of PHP, HTML, CSS, and MySQL database web applications. This project is useful for college students and educational institutions for getting the subject backlogs in a simple manner. As a result analyzer with subject status is an application tool for displaying the Backlogs insecure way.

The Backlog Management System is intended for the students and Faculty. The whole Student failed subjects analysis system analyzer will be under the control of the administrator and the admin has full privileges to read, write and execute the failed exams or Backlogs. And admin gives privileges to the Faculty and student and the guest user to access the reports.

  • Provides the search facilities based on various factors such as subject-wise backlogs, student-wise backlogs, department-wise backlogs, and Total backlogs.
  • Backlog Management System also manages Regulation details, department details, subject details, and academic year details.
  • It tracks the information on students, regulations, departments, semesters, and academic years.
  • Adding, viewing, Editing, and Deleting operations of records are improved.

Background of the System

The background of the Backlog Management System problem is that all the records are maintained manually at the time of results being released. In this case, there may be a chance to mislead students by changing their record values. So that valuable student data/information can be stored for a longer period of time with easy access and manipulation can be done. Basically, the Student Subject Backlog Management System project describes how to manage for good performance and better services to the users.

Purpose and Scope

Purpose

The purpose of this system is to maintain the details of the Backlogs of all students for their external or final examinations which are conducted by the university in the college. This system is managed by the staff of the department. Staff updates the backlog of student details along with course details for example Regulations, Department, Subject codes, Subject names, etc. The subject backlog of all students can be viewed manually. This system generates the reports of the students like subject wise, roll number wise & cumulative. In this case, faculty and students can check the details whenever they needed.

Scope.

This web-based Backlog System application will manage the information about various students enrolled in this course in different years, the subjects offered during different semesters of the department the backlogs obtained by the various students in various subjects in different semesters. The application will greatly simplify and store the details. Retrieve the particular student information accurately and efficiently

System Analysis

Existing System

 In this system backlogs of all students can be viewed manually at the time of results are released. In this case, there may be a chance to mislead students by changing their record values.

Proposed System

 This proposed system maintains the backlog of subjects and details of all students. This system generates the reports of the students like subject wise, roll number wise & cumulative. When the students clear their backlogs they remove from this system.

Advantages
  • Students can monitor their backlog subjects.
  • No need to maintain manual reports.
  • All the staff members can view the backlog of student data based on their requirements.
  • Staff can analyze which subjects are frequently failed by students.
Requirement Analysis

 The project is to provide Backlogs to the student in a simple way. This project is useful for students and educational institutions for getting the Backlogs in a simple manner. As a result analyzer with subject status is an application tool for displaying the Backlogs insecure way. So that valuable student data/information can be stored for a longer period of time with easy access and manipulation can be done. Basically, the project describes how to manage for good performance and better services to the users.

Module Division

This system contains two modules namely:

Admin Module

Admin performs the basic tasks of Add/View/Delete Regulation, Subjects, and Backlogs of students. And generate the reports student-wise, subject-wise, department-wise, and cumulative.

User Module

User Faculty can search different types of reports such as student wise, subject wise, department wise, and cumulative. User Student can search their Backlogs using valid roll numbers.

Conclusion and Future Work

The project “Backlog Management System” is a PHP, HTML, CSS, MySQL web portal that is useful to store the details of Backlogs. This system is managed by the staff of the department. Staff updates the backlog of student details along with course details for example Regulations, Department, Subject codes, Subject names, etc. So that valuable student data/information can be stored for a longer period of time with easy access and manipulation can be done. This project is useful for students and educational institutions for getting the Backlogs in a simple manner.

This Final Year academic project generates the reports of the students subject-wise, roll number wise & cumulative. Finally, staff can analyze which subjects are frequently failed by students. In this case, faculty and students can check the Backlogs whenever they needed.

Student Database Management System Bootstrap Project

PREFACE

1) The Student Database Management System project DBMS is basically a model to show how various real-life entities in a college are interlinked.

2) This Student Database Management System project is an extract from the model which is used in various institutions.

3) This Student DBMS project tries to map a relationship between various departments in an institution, their teachers, various courses by the teacher, and the students.

4) This Student DBMS project keeps a database about various departments in the institution, teachers involved, various courses taught by teachers, students enrolled in the institution, and keeps a report on the grades scored by students in various courses.

PROJECT ANALYSIS

TECHNOLOGY USED

The Student DBMS project DBMS uses technologies like MySQL, WAMP, and PHP for storing and accessing the database also HTML, CSS/and BOOTSTRAP to maintain the GUI of the project.

MYSQL/WAMP: They were used to store the data of the Student DBMS project.
PHP: It was used as a backend language for storing and accessing the database.
HTML: Front-end language used for developing the architecture of the page.
CSS&BOOTSTRAP: Used for designing the page.

ENTITY MAPPED

1) STUDENTS: This stores the various information about students.
2) DEPARTMENT: This stores the various information about Department.
3) COURSES: This store’s various information about courses.
4) INSTRUCTOR: This stores the various information about the instructor.
5) GRADES: This stores the various information about Grades scored by students.

CONCLUSION

The Student project DBMS mapped the various real-life entities of the institution like departments, teachers, and students and gave us a model through which we can efficiently store, manipulate and retrieve our data.

Through this Student Database Management System Bootstrap Project, we got a rough idea about how the data flows between the departments and how it is stored.