Tag: MySQL

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

College Classroom Appliances Repair and Maintenance System App

Implementation

This College Electronic items Repair and Maintenance System App has been implemented to accept complaints against damaged fans and lights in the classroom and to show the status of the registered complaint.

The college classroom-specific android mobile app has two sides, the user end, and the admin end. The user end is for the class CRs which allows them to lodge complaints, view the status of the complaint, and see the complaint’s history. Whereas, on the admin end, the admin can view the lodged complaints and can update the status of the complaint.

User end Project development:

First, after opening the Repair and Maintenance System App, a login page appears. The user must log in to the app, with his/her respective login ID and password. If the details match with any of the CR’s details, then the app will be directed to the user side. After logging in, a page with all the room numbers is displayed.

When the respective room is selected, the user is directed to a page where he will be asked to select the fan number or the light number that needs repairs. On clicking the submit button, the complaint will be lodged successfully.

On the home page, there is a menu bar towards the extreme left, which has two options-complaints books and logout. The complaints book has information about all the complaints that have been lodged to date.

The status of the complaint whether it is repaired, or it is still pending, is shown for each complaint. By using the logout option, the user can log out of the app. This is the user side of the app.

Dataflow of the App (User end):

DFD of College Classroom Fan & Lights Repair System App                                         

Working Flow of the App(User end):

Output Workflow results of College Classroom Fan & Lights Repair System App

Admin end project development:

When the given user ID and password match with the details of the admin, then the College items Repair System App will be directed to the admin side. After the admin logs in, he will be directly navigated to the complaints book. Here, he can view all the complaints, old as well as new ones, that have been registered. At the end of each entry, he has the option to update the status of that entry.

Conclusion:

The ultimate goal of this Final year android-based mini or major project is to eliminate the huge loss of man-hours and manual intervention. The goal is to provide an effective platform to lodge complaints and also to maintain a chain of responsibility and efficiently attend to complaints.

The entire academic project has been built according to the requirements stated and can be implemented without errors. The complaints can be stored and can be monitored. The is very useful as it would reduce stress and it is very easy to use. This process is less time-consuming and is highly reliable.

This Repair and Maintenance System App project was developed with HTML, CSS, XML, Java, JavaScript, and MySQL databases. It can be scaled to add even more sophisticated features and be made more flexible.

The application can be integrated by adding several other complaints regarding infrastructure etc. A communication system can be provided where the students can clarify their queries. This would enhance the standard of the application.

Posted on

Farm Assist – An Android Application for Farmers Assistance Project

Introduction:

Farm Assist (The farmers assistant project) is an android mobile application that is used to get the details about the crop price, and crop insurance details as insisted by the government. We can also get tips for skillful cultivation and get better yields. The farmer’s assistant application also provides the dealers to interact with the farmers so that they can enter the crop price details and buy the farmer’s crop.

Problem:

The main problem of the Farm Assist – Farmers Assistance project is that we are considering the loss of farmers due to the price of the crop that is sold to the dealers, the nonprofitable methods of cultivation, and the details regarding the crop loan issued by the government.

Technology stack :

1. Android studio.
2. CSS
3. Java
4. HTML
5. MYSQL
6. JSON
7. JavaScript
8. BootStrap.

The farmer’s assistant project mobile app consists of a basic entry for any user means anyone is allowed into the app without any login but the dealers are given a special button to register as a dealer.

In the crop section, the dealer information is stored in the database and shown when the farmer is searching for the best dealer the dealer’s list is displayed for him. the dealer is allowed to update the prizes when the updates are to be done.

In the Insurance section, the insurance of every crop is given and is updated in the database periodically when it is needed. In the agro-tips, the farmers are given the best tips for good crops and crop diseases.

App Home Screen of Farmers Assistance App

AGENDA:

  • Problems faced by farmers.
  • What are the solutions that others had given in the past?
  • Application demo.
  • Crop details.
  • Insurance.
  • Agro tips.

Problems faced by farmers:

  • The main problem that we are concerned is about the sale of crops to the dealers.
  • General market rates which are provided by Government are not implemented at the root level.
  • So to overcome this problem we are developing this application for the benefit of farmers and future generations.

What are the solutions that others had given in the past:

  • In the past govt. has started some committees in India to overcome this problem.
  • But it is not implemented all over the state due to the lack of knowledge of farmers and few inconveniences.

APP Demo:

The facilities which we are providing in our Farm Assist – farmer’s assistant app project

Crop details:

The first farmer will enter into the crops and then he moves into the district then the prices of the crop in that district will be shown in the farmer’s assistant android mobile app.

Insurance:

In this, the periodical update of the amount that the government has provided to the crop will be updated.

Agro tips:

  • Different suggestions like fertilizers, crop rotation, etc. are provided to the farmers.
  • The agricultural officers give these details regarding fertilizers, crops to be grown, etc.

Related Projects on Farmers & Agriculture based below:

Real-Time Assistance to Farmers and Health Sector Android App

Farmer’s Medium of Communication for Support Price of Crops

Farmers Buddy Java Project

Automatic Humidity Monitoring and Pumping System for Farmers

Design & Development of E – Agriculture Java project

Posted on

Patient Medicine and Appointment Tracking System Java Project

Introduction

Patient Medicine and Appointment Tracking System is a web application that provides an interface through which Admin, Patient, Doctor, and Receptionist can register to the portal. The Java, HTML application will be used as Medicine and appointment tracking system.

The proposed Patient Medicine booking system eliminates the paperwork at hospitals and provides an easy solution through which the users would be able to read and update the data on the portal.

Description

This Patient Medicine and Appointment Tracking System project is a web application in which the Admin, Doctor, Receptionist, and Patient can register where Receptionist will ask for the email id of the patient for registration and the patient will get an email having a key generated by the receptionist through which patient can authenticate and can register on the portal.

The patient will be able to log in, create and view a medical report which comprises of clinic name, disease, doctor name, receptionist name, appointment date, etc, which are going under his guidance. The portal will provide information about the patient’s Medical Report and Appointment with the doctor.

This Medical Report will be maintained by the Patient, and the Approval/Disapproval of the appointments directly depends on the receptionist /doctor. The patient will get an email regarding the appointment in either of the cases.

Data Modelling of the Patient Medicine and Appointment Tracking System

Problem Formulation

We often forget about the small things in our day-to-day life because of our fast and busy schedule. But these small things like taking medicines and our weekly or monthly doctor’s appointment, have greater impacts if they are ignored. So, the main objective of building this project is to maintain the health of the user in his busy lifestyle.

The medication should not be ignored and thus MediTrack will help the user by reminding them timely about the medicines and schedule of appointments with the doctor. It also provides the doctor (receptionist) to keep track of and schedule the appointment with the patient.

Motivation

Existing technologies in the market carry out only online delivery of the medicines as per the prescription. Meditrack serves the patient’s needs by allowing them to make an appointment with the doctor and can keep a track record of their prescriptions, and appointments.

The Patient will be able to keep track of medicines, Appointment details, stock of required medicines, and scheduled reminders at appropriate times for prescribed medicines.

Software Requirement

Front End: HTML, Bootstrap. Angular
Backend: SpringBoot
Operating System: Windows 7 & 8
Database: MySQL

Visit the developer’s Page and Download the complete Java & MySQL project on Patient Medicine and Appointment Tracking System

Posted on

Grocery Store Management System Python Database Project

The objective of this python project is to design a GUI for the Grocery store Management System which incorporates details of the Employees, the Manager, the Designation of the employees, the categories of the products, the details of the Customer, and a list of available commodities, and location information of the grocery stores.

Suppliers and details of commodities which shows which items are going to be out of stock for the store which has various branches situated in various areas with different Managers taking care of that data set.

This database is efficacious in running the grocery stores. The users of the database will be the store managers.

  • Grocery Store Management System is designed to provide the grocery stores with the benefit of having everything online, from products data to customers data.
  • It helps the store managers to perform various functions like checking the products stock, suppliers information, customers information and also allows them to check if a particular product is available in any other branch.
  • It also helps to keep track of the store employees.
  • Provides a user-friendly interface where everything can be accessed with just a button click.

Database

  • Created views using joins to have a virtual table that can be accessed anytime.
  • Created a table for login credentials that allow only the managers of the store to access the database.
  • We have used the database queries effectively and carefully to implement the insert, update, delete and search. We have also used a view to join our tables and view the records. A database with the name grocery store has been created.

In Grocery store management, we have the following tables which will store the corresponding data

Database table Design for Grocery Store Management System

Location

The Location table has records of the location information of the grocery stores. For now, we have defined grocery stores in 20 locations.

Employees

The employee’s table has records of the Employees working in the grocery store. As we have defined our model to have managers for each store and they exclusively have the access to the database of the grocery store (DB Users), for now, we have defined all the managers for all the grocery stores listed in the Location table.

Designation

The Designation table has various records of different designations applicable/available in the grocery store.

Customers

The Customers table holds the details of the customer

Manager

The Manager table holds the details of the employee

DB Users

DB Users are the Managers

Commodities

The Commodities table holds the details of various products such as the product number, product name, product quantity, and product price. 

Suppliers

The Suppliers table holds the details of the product suppliers

Categories

The Categories table holds the details of the Product categories

GUI

The GUI for our project, the Grocery Store Management system is built using Python Tkinter. We have created GUI for all our tables, where we can perform operations, such as INSERT, UPDATE, DELETE, and SEARCH on all the tables of our Grocery Store database. 

Database connection to GUI

 To establish a connection to the database and GUI the following syntax needs to be used.              

Here, I have used the credentials of my localhost database connection, however, one has to replace it with the credentials in their system. By using this, the user can connect to the database and a GUI will be displayed accordingly.

Description of GUI

The main.py file has to be run, in which all the other modules are imported. Each module is for each table in our database. Main.py holds everything and it directs us to different modules with the help of buttons. When we run “main.py”, a login window, where we have to enter the credentials will be displayed and will only take you inside, if you enter valid credentials. If the credentials are correct, then a window is displayed with image buttons for all our tables.

When we click on each button, it will be redirected to the respective module, and a connection is established with the database. To establish a successful connection with the database “grocery store”, it should be available in our system.

View the developer’s page on Github and download the Grocery Store Management System Python Tkinter Project & MySQL Database Design Project source code, Project Report, and Project PPT for academic project guidance and reference purposes.

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

Design & Development of E – Agriculture Java project

The main objective of this E Agriculture Project is to build a website that will help Indian farmers to make effective cultivation by providing information on crops and making a path to earn more money from Indian villages by selling their products to different cities online and by registering their crops to get their suitable price for their crops. They can open this site and register with it and sell and buy their products and register their crops online etc.

  • The website “E Agriculture Project” is for farmers.
  • This website contains information about different types of effective farming and irrigation techniques.
  • This website gives information on crop management to satisfy the demand for a particular crop to reduce crop prices.
  • Through this E Agriculture website, the government can buy products directly from farmers.
  • Through this website, farmers can buy seeds, and fertilizers directly
  • The farmers can have a deal with the government for a certain cost.
  • So farmers can have a lot of profits.

Software Requirements:

Operating System: Windows 10,
Technology: Net Beans
Database: MySQL

Modules Description:

Login:

This helps the farmer to login by which they can know about soil information Crops suitable for different regions and government schemes and register the crops which they want to produce.

New Register:

If the farmer wants to log in the has to first register by clicking new register and Filling in the details

Home:

Once the farmer has logged in he can register the crops in their region, buy products, Sell products, Know crop information, soil information, schemes given by the government, update details, available at home

Crop Management:

It has all information about crops suitable for different regions, soil information, and all crop Information, scheme of the government

Crop Registration:

It helps the farmer to register for the crops that they want to produce in their region. This leads to the balancing of crops and certainty in the price of crops

Buy Products (seeds, fertilizers):

It helps the farmer to buy fertilizers and seeds from the government without agents between

Update details:

It helps the farmer to update their details which they have filled in the new registration

Download the Design & Development of E – Agriculture Java project Source Code, Report.

Posted on

Students and Teachers based College Notice board System Java Project

In the Students and Teachers-based College Notice board System, we are providing role-based access rights to different users, that are students, teachers, and administrators in a college.

In our College Notice board System Java project, the students and teachers can view all the Notices such as examination notices, marks notices, announcement notices, training and placement notice, schedule notices, etc. which are published by the respective departments. Improving my feedback is very important. Keeping this in mind, we have a section in our system dedicated to feedback. With the help of this, students can give feedback to their respective teachers which will help in increasing the quality of education in a university.

In the College Notice board System, students and teacher can access their class timetable, anywhere and on the go without the hassle to go to a particular place to see the timetable. Students can access all their academic details with the help of an interactive graph. The system is very user-friendly, it is made in such a way that users will have a hassle-free and interactive user experience.

Future work to be done

  • Teacher – Student feedback system, which will enable students to give their respective feedback to their teachers directly in real-time.
  • Timetable portal, which will enable students to view the timetable of their respective classes. If further implemented using B.P.A (business process automation) or R.P.A (robotics process automation), then the timetable for the whole department could be easily generated without any human interference with the help of Artificial Intelligence (A.I.)
  • Students can also use the College Notice board System on their mobile phones and tablets through an Android and iOS application.
  • Students can also chat with the faculties to clear doubts and ask questions using the real-time chat system.
  • Students can get counseling with the help of A.I. Chatbots and also can chat with the counselors present at the university.
  • It will also show the graph of Cumulative Grade Point Average (C.G.P.A.) and Semester Grade Point Average (S.G.P.A.) concerning the semester. And also use the College Notice board System to view the marks and answer sheets.
Posted on

Daily Student Classroom Attendance Management System Project

PURPOSE

The purpose of developing a Daily Student Classroom Attendance Management System Android Mobile App is to digitalize the traditional way of taking attendance. Another purpose for developing this application is to generate the report automatically at the end of the session or in the between-session for a particular student on a regular check basis.

SCOPE

The following Android Mobile App project has much scope both in present as well as future. In the present situation, the system can be accessed on android mobile devices. Any android device which has the access to the server on which the project has been deployed can use the application i.e. the Daily Student Classroom Attendance Management System project will work for a particular institution. But later on, the project can be modified to operate for many institutions.

SOFTWARE INTERFACES:

  • Front-end: XML
  • Back-end: Java
  • DATABASE: MySQL, Firebase
  • SERVER: SQLite Server
  • Tool- Android Studio

PROJECT OBJECTIVES

This android based mobile app project is a classroom attendance management system and the objectives are:

1. Manual work for information retrieval on attendance becomes less like the work.
2. Easy access for students because they can view their attendance and make up for the shortage of attendance accordingly.
3. It is also time-saving as manual work is less.
4. There is less chance of error.
5. It eliminates duplicate data entry in time and attendance entries.
6. Weekly or Monthly attendance reports can be generated for a particular student.
7. Easy maintenance of students and faculty data by admin.
8. Data redundancy can be decreased as data is now stored in one place.
9. Data is now much more secure.
10. Easy access for teachers as they can now view their student’s attendance reports easily.

FUNCTIONAL REQUIREMENTS

1. LOGIN

Admin and Faculty will login in into the system with username and password, if username and password are correct admin/faculty will be prompt to proceed option otherwise an error will be shown

INPUT: username and password
OUTPUT: student detail information

2. UPDATE COURSE DETAILS

Admin can insert, update, and delete course details.

INPUT: Course name
OUTPUT: Operation(insert/update/delete) successful

3. UPDATE STUDENT INFO AND COURSE ENROLLMENT

Admin can insert, update, delete student info, and enroll students in particular courses.

INPUT: name, Roll No., DOB, Course
OUTPUT: Operation(insert/update/delete) successful

4. UPDATE TEACHER’S INFO AND ASSIGN COURSES

Admin can insert, update, delete teacher’s info and assign a course to each teacher.

INPUT: Name, Address, Email, image, course, DOJ
OUTPUT: Operation(insert/update/delete) successful

5. MARK ATTENDANCE

Faculty can take attendance on a particular day over a student’s name by marking him present or absent.

INPUT: Absent/Present
OUTPUT: A confirmation message

6. WEEKLY/MONTHLY ATTENDANCE REPORT/CHART

Admin/Faculty can create a student attendance report/chart between any 2 dates

INPUT: starting date, ending date
OUTPUT: attendance report/chart