Tag: PHP

Posted on

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.
Posted on

Design & Development of Educational Institutions Grievances Portal Project

Currently, there is a portal name Grievances portal similar to this. In the grievances, portal people can share their local problems and their solutions are provided by anyone. But in our portal people can share problems of any region and they are taken up by colleges of the region facing problems. This helps several institutes to work collaboratively on a large scale.

Introduction: 

This Educational Institutions Grievances Portal Project report gives a scope description and overview of everything included in the Project Report.

The following is the overview:

Purpose:

The purpose of this report is to give a detailed description of finding and solving common issues with educational institutions. It will illustrate the complete declaration and purpose for the development of the system. It will illustrate an interaction, constraints, and interface between different users of the system.

System Overview:

This Grievances Portal Project takes the problems faced by students of a particular institute as input in the form of upvotes or posting a problem. All users have to log in using Google authentication facebook or any social media platform. This helps to keep the track of users participating.

The institute first has to register so that it is possible to keep a track of which colleges are participating. All the passwords of institutes are encoded using ​md5 ​and the colleges can then take up the problems about a particular locality and can do collaborative projects to solve them.

The solutions are generally provided in the form of videos which is easily understandable to the local public. But before posting solutions, the colleges have to first check for the authenticity of the problems. They can mark any solution as duplicate or bogus.

This ensures any unrelevant problems from reaching admin and the system is thus maintained. Finally, a report is generated in the form of an excel sheet that helps the admin to know the problems existing in our country. This file can be downloaded as well.

Model of Solution:

Goals:

The Grievances Portal Project aims for semantic text/web page classifications. It provides a better and more comprehensible platform for posting college-level problems and finding solutions. It is extremely user-friendly and easy to use.

Objective / Future scope:

● Define a mechanism to decide ​the count of votes needed to approve an issue
● Once voting is closed for an issue i.e. when the issue is upvoted by the number of users count of votes needed to approve an issue, then the upvote facility will be closed and the system immediately sends a notification to all the related institutes.
● There should be a way to maintain “Reputed Institutes”
● Admin should be able to see which Institutes are working on that problem.
● Each problem should have a thread on which registered users may discuss its solution or upvote or downvote the solutions also.
● The emails of users sending “bogus approved issues” may be blocked when marked as bogus as colleges​

Functional and non-functional requirements:

Grievances Portal Project website there three types of users:

● Citizens
● Institute
● Admin

All users get the same view of the website with similar functionalities but they all perform different tasks.

Functional Requirements:

User Functions

1. Sign Up
2. Can change his/her profile
3. To add an issue
4. Users may also look for issues in any region
5. Can visit a problem description directly through a URL and upvote for it.
6. Users cannot upvote the same issue more than once.
7. Will be notified through email to approve if any solution is available for any of the problems he has upvoted for.

Institute Functions

1. Institutes will have a login

2. After login they will be able to see the issues of ​their region only​ like

a. Unsolved issues (approved)
b. Issues with solutions

System Functions

1. Knows list of Institutes per district
2. Gets added issues and stores
3. Keeps a track of upvotes per issue – Once upvotes reach a ​threshold ​the issue is notified to all the Institutes in that region or district via email. (Institutes can see approved issues of their region via their login as well).

  • Problems of a district may be shown to that region instead of that district
  • Institutes of nearby districts may fall under the same region.
  • Or simply it can be forwarded to the Institutes falling in the same district.

4. Once an Institute submits a solution, the system notifies all the users who upvoted for that issue. So that they may approve the solution.

5. Will know how many solutions an Institute has provided. It means how many of them are solved issues.
6. Long pending issues should be notified to UGC who then will notify the Institutes
7. Institute should be notified when its solution is approved.

Administrator Function

Reports to be generated

The technology stack used:

Backend: PHP.
Frontend: Html, Jquery, javascript, Ajax, bootstrap.

Implementation strategy:

1. Initially, the whole template was designed to suit our requirements.
2. Bootstrap was used for the development of the template of this website (SB Admin 2)
3. All pages were then linked which made the division of work easier.
4. The whole backend was made using PHP.
5. There were various event listeners used in this system like on focus, click, change, etc., which were implemented using JS and Jquery.
6. Almost all pages had the same page refresh and reload for which we have used AJAX.

Conclusion:

1. Our team has completed a Web Application
2. Product Design was a crucial point in the development
3. We now have a complete understanding of how a website works from start to end
4. We learned a new language – AJAX. We also strengthened our knowledge in PHP, JS, and Jquery.
5. Most importantly, we learned how to work in a team.
6. The future scope of our specified in the Goals -> Objectives section.

Posted on

Online Vehicle Insurance Management System Project Idea

Objectives:

This Insurance Management System project is a website or web application mainly for persons who are willing to buy insurance for their vehicles. Through this website, it will be easier to find a suitable one.

The main intention of building this website is to provide users to choose their budget and the best package for their vehicle. We have tried to maintain all the information about the insurance plan which is easily understandable to the users and makes it easy to find the plan.

This system helps the user to get a different kind of insurance.

Description:

The Online Vehicle Insurance website is to provide services for people who need insurance by getting help from the agents.

There are seven main modules in this system.

User Login:

In the login section, a user can log in to his account using his user id and password to share and update all the information like vehicle type, age, location, last insurance date, and contact number and he/she can submit the information.

Login/Sign-Up:

In this module, the user can register the plan in which he/she is interested in providing the vehicle number, PUC, other papers of the vehicle, E-Mail, and ID proof.

Why take insurance:

In this module, people who are interested in insurance but have some confusion will find some Q&A here like,
• Why should people take insurance?
• What happens when I give or take insurance?
• How many plans are available? What kinds of plans are there
• Is taking insurance good?

Insurance Types :

• Liability Insurance
• Collision Insurance
• Personal Insurance
• Comprehensive Insurance

Dashboard:

• Recent Policies
• Product
• IDV

Expiry Date:

• Car type
• Car Registration
• Select Policy

About Us

This webpage serves information about the developers of the website.
Address of the developers and their contact information.

Data Flow Diagram:

Vehicle Insurance System DFD

Posted on

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:

Posted on

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.

Posted on

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

Posted on

Fresh Online Grocery Ordering Website Project

Project Overview

Fresh Online Grocery Ordering Website is an online web application for automating the process of ordering grocery products from suppliers and paying for them in advance. Therefore, there is no need for the suppliers to wait for a long time and pay in cash at the time of delivery. This system also helps farmers to sell their products through this system.

The current Grocery Ordering system is not much efficient and can lead to a major waste of time as the supplier needs to wait for a long period. The main purpose to design this Online Grocery Ordering application is to provide an environment where the users will be able to order products from a supplier and pay in advance.

To what extent the system is proposed?

The proposed Grocery Ordering system automates the manual process of users the shop owners which can be used for ordering products from suppliers online and farmers visiting the shop with their products for selling and physically paying for the products with cash by introducing an online automated system that sends product requests online. The current system is not much efficient and can lead to a major waste of time as the supplier needs to wait for a long period. The main purpose to design this application is to provide an environment where users will be able to order products from a supplier and pay in advance.

Specify the Viewers/Public who is to be involved in the System?

The Viewers/Public that are mainly involved in this system include staff, suppliers, and farmers. The staff, suppliers, and farmers can also register to this system with valid information. They can buy/sell products and also include payments

List the Modules included in your Grocery Ordering System?

The system includes 4 modules. They are:

• Admin Module

Admin is the one who does the staff and supplier registration and approves or rejects the leave request of staff and farmer’s product request, publishing notifications to the users, fulfilling staff and farmer’s product requests, and can view and block and unblocking of existing users. Admin can do a secure payment for their products through the online payment system. Admin can also view their request status from Suppliers and notifications from the Staff. Admin can approve or reject the leave requests as well as admin can view the existing products and order the products and view the status of the ordered products.

• Staff Module

The staff can view the current stock and update the stock. After product stock reaches a critical value the staff can issue a notification to the admin. Staff can send leave requests and see the status of the requested leave and also
able to update their profile.

• Supplier Module

The suppliers can view and update their profile as well as their stock.
Suppliers can add new products and can view product requests send by shop owner/admin and process orders. Suppliers can get a secure payment for their products through the online payment system.

• Farmer Module

The farmer can send a request for selling their products through that shop.

Farmers can see the status of product requests send to the admin as well as can view and update their profile. Farmers also can get a secure payment for their products through the online payment systems and can also view their
request status and notifications from the admin.

Sequence Diagrams for the Project:

Farmer Supplier Sequence Diagram Online Grocery Ordering system Online Grocery Ordering Farmer Admin Sequence Diagram

Identify the users in your project?

The main users of this project include:

  • Admin who controls and coordinates the entire activities of the system including provisioning users to buy/sell their products and responding to requests from farmers.
  • Staff who manages the day-to-day activities of a grocery shop including updating seller stock and logging and maintaining transactions to and from the grocery shop.
  • A supplier who processes the order that was made by the admin.
  • The farmer who requests products online.

Who owns the system?

The owner of Online Grocery Ordering is the grocery shop in which the system is implemented. A system administrator is appointed by the organization for managing and coordinating the system activities.

The system is related to which firm/industry/organization?

Online Grocery Ordering is a grocery shop management system and it is associated with a grocery shop in which the system is implemented.

Details of the person that you have contacted for data collection?

Questionnaire to collect details about the project? (min 10 questions, include descriptive answers, attach additional docs (e.g. Bill receipts, certificate models) if any?)

1. Is there any discount streams available?
Several discounts are available for a range of products if the customers purchase products in a bulk range.

2. Is there any products available in your shop other than grocery items?
Yes, we also sell products including vegetables and fruits as well as sweets.

3. Is there any wholesale products in your shop available?
Yes, we provide products for wholesale.

4. Which among the products are most frequently sold out?
Sugar, cerials, vegetables.

5. How do you maintain the records of day-to-day transactions? What all features do you expect if this system gets automated?

6. How do you keep track of inventory?

7. How do you transport your groceries?

We use paper bags for the transportation of products.

8. What are the pricing strategies that you follow for selling your products?

It depends on the market value/price.

9. Is your supplier responsible for restocking?

Yes, our supplier is responsible for restocking, if the products meet their time limit.

10. How do the details and contacts of suppliers maintained?

The details and contact of suppliers are maintained in records physically.

Download the complete Grocery Inventory Management System PHP & MySQL Project.

Posted on

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.

Posted on

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.

Posted on

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.