Employee Task Management System Web Project using PHP and MYSQL

Problem Description

We need to make a system in which mentors can assign tasks to the employee and other mentors can monitor the availability of employees and on that basis, they can assign him/her new task. As well as employees can see all the assigned tasks with priorities. The app should be able to: Store data on new Employees/Trainees and new Task Assignments Employees can see the availability of other employees, trainees, and interns but trainees will not be able to see other availability. Employees can assign tasks with details like task name, task description, assigner, priority, and expected hours for completion to other employees’ or trainees’ ToDo lists considering the maximum limit of a total of eight hours for an employee before assigning any task.

Target Audience

This is a very common problem in companies where an employee already working on an assigned task and another mentor or boss going to assign him a new task, S/He might not know the employee’s availability and the priority of the task on which the employee already working. In that scenario, there will be lots of communication going around to assign the task, due to which task going to be delayed. To resolve these issues and make employee availability transparent, we need to make a system in which mentors can assign tasks to the employee and other mentors can monitor the availability of employees and on that basis, they can assign him/her new task.

As part of the curriculum of B.tech and to gain practical knowledge in the field and Python programming and web development we have made this project. We have boosted our skills through it.

In this Project, we have worked on VS Code and GitHub. Git Bash, Mysql, Software xamp, CSS, and HTML.

Employee Task Management System is created in PHP and MYSQL. It deals with the rundown of workers in an organization or an association. It likewise contains the training went by every Employee. Representative is the foundation of an organization so the Employee Management System is an extremely useful framework for an association or organization.

It also contains training attended by each employee. The employee is the backbone of a company so the Employee Management System is a very helpful system for an organization or company. This system also manages the company employee details like their attendance, their performance, salary details, and leave details.

This section compresses the assessment of the writing important to the Employee Management System. It looks at hypotheses, ideas, methodologies, strategies, and systems important to the venture.
Comparative existing advances identifying with the improvement of the Employee Management Systems are talked about.

In this Project, we have worked on VS Code and GitHub. Git Bash, Mysql, Software xampp, CSS, and HTML. Employee Management System is created in PHP and MYSQL. It deals with the rundown of workers in an organization or an association. It likewise contains the training went by every Employee.

Representative is the foundation of an organization so the Employee Management System is an extremely useful framework for an association or organization. It also contains training attended by each employee. The employee is the backbone of a company so the Employee Management System is a very helpful system for an organization or company. This system also manages the company employee details like their attendance, their performance, salary details, and leave details.

Design Diagrams:

Use Case Diagram:

Data Flow Diagram:

ER Diagram: Sequence Diagram:

Activity Diagram:

Functional Requirements

REQ-1: Authentication 

  1. Login- The user can log in to the system with his/her username and
  2. Logout- The user can log out from the
  3. Login failure- If the user does not exist in the database or the user has not yet been authorized by the

REQ-2:Authorization 

  1. User role check- After logging in, the user role will be checked from the database and the user interface will be displayed according to their role.

REQ-3: Employee Management 

  1. Display- Users with defined roles can display the content of the database. To be more specific, an employee can only view his/her personal Boss and can not only see his/her personal information but also employee’s information who are under his/her department or school.
  2. Edit- A user with an employee role can edit his/her specific personal

information. Boss can only edit employees’ personal information that is under his/her coverage except for user role type. The Boss can check employee availability.

REQ-4:Trainee Management 

  1. Training – The Boss and employee shall create training tasks and assign them to other Bosses and employees and employees and trainees respectively that are required to attend the training as well. Boss and Employee can also check the availability of the trainee.

REQ-5: Task Management 

  1. Tasks – Boss and Employee can check assigned tasks, they can check task priority. they can also create the task and assign the task.

1. Sign Up
2. Login Up
3. View Employee Details
4. Create Task
5. Priority
6. Availability
7. Assign Task
8. Task Status
9. Task Done
10. Task Details
11. Personal Details
12. Submit Task

System Features

Module Description

Sign Up: Bosses, employees, and trainees will sign up using their credentials.

stimulus: boss/employee/trainee will sign up through the signup button.

response: dialogue box for “thank you for signing up” appears.

Log in: Boss, employee or trainee will log in to the system using their unique ID.

stimulus: boss/employee/trainee will log in through the login button.

response: for boss/employee/trainee different pages will appear respectively.

View employee details: contains employees’ details.

stimulus: click on the button to View employee details.

response: Details appear (only boss and employee can view details)

Create Task: boss can create tasks for employees or another boss. Employees can create tasks for trainees or other employees. trainee can not create tasks.

stimulus: click create task button.

response: the task will be created

Priority: Check the assigned task priority.(boss/employee/trainee)

stimulus: click on check assigned task priority.

response : shows priority(High,Medium,Low).

Availability: check availability of boss/employee/trainee for assigning the task.

stimulus: click on the check availability button.

response: shows availability.

Assign Task: After creating the task the creator will assign the task to the boss/employee/trainee.

stimulus: click on the button to assign a task.

response: Task will be assigned

Task Status: change the task status whether it is completed/submitted/in progress.

stimulus: click on the button to change task status.

response: changes will be done according to your status when you choose options from it.

The task is done: The feature indicates the task is done. Only bosses and employees can access this feature.

stimulus: click on the task done button.

response: status will be updated once the task is done.

Task Details: will get trainees through the details of the task assigned.

stimulus: click on the View Task Details button

response: details appeared

Personal Details: will display personal details of the trainee to her /him.

stimulus: click on the View personal details button.

response: personal view appears to him/her.

Submit Task: The feature is for trainees only, to submit the task.

stimulus: click on submit task button

response: the task will be submitted.

Future Scope

1) AI is applied in almost every industry and may become a standard in the near future. 

2) Data visualization represents the data in a visual and understandable manner: graphs, diagrams, maps, etc.

Conclusion

This is a customized task management tool that enables your enterprise to manage all tasks efficiently in this troubled time & even in the post-COVID age. Our robust task management app help organizations face challenges related to project management & gain a higher Return Of Investment over the period while meeting deadlines and utilizing resources effectively.

Download the Complete Employee Task Management System Project code, Report, PPt, and Design Documents

IoT based Attendance System Project Using Blockchain and JAVA MySQL

The success of this IoT-based Attendance System app will ensure that many more parents and organizations will be motivated to use this common platform. It becomes complicated when strength is more. With the increase in technology, attendance monitoring is designed with android or web-based applications. However, the intention of this design is to provide a Blockchain-based app that can be downloaded and used by the organization with no third-party control to meddle with the data.

There is an update option to modify attendance when it’s needed. However, the modifications are recorded and tracked, just in case, it’s a fraudulent activity. Attendance is captured using IOT automatically and is entered into the blockchain which makes the data tamper-proof, secure and robust. The privacy of its users is preserved because the user ids are generated by a trusted third party. This data is available for the government for Scholarships and other related decision-making.

IOT-based Attendance System using Blockchain is an application that is made for students and faculty of a particular college to maintain students’ attendance which is captured through an IOT device(biometric) and then the attendance is stored in the Blockchain. Blockchain is used in this application to ensure safety and a tamper-free environment as the data cannot be manipulated and is used for government purposes.

Objectives

Generally, in many institutions attendance is monitored and marked using conventional systems like android or other similar web applications. Few conventional databases do not have features like checking whether any information has experienced unauthorized changes or not. In this system when the data is entered into the blockchain, no one is allowed to edit or delete the data.

This makes the application transparent and different from other web-based attendance systems as IoT is used to capture attendance through biometrics of the students in the class. Students’ poor attendance rate is one of the most challenging problems tackled by college management today. With the help of this application, student attendance rates can be improved which is also helpful for the government to take precise decisions regarding scholarship-like schemes for students with transparent data. Using blockchain and some encryption techniques, this application is made secure from any manipulations.

Student Login Page

Methodology

The fingerprint module will collect fingerprint data from multiple users and sends it over the internet to the website. The IoT-based Attendance System website is coded in HTML, and CSS, JSP has a MySQL database, and records of attendance are stored in Blockchain. By logging into the website, the student can view all their attendance records. The timestamp of students’ attendance is encrypted and stored in the blockchain.

CONCLUSION AND FUTURE SCOPE

This IoT-based Attendance System application helps to automize the attendance system and makes it easy to manage all the data. Encryption, decryption, and blockchain make the application very secure. The application has a very user-friendly UI and is made to keep UI and UX in consideration.

The future enhancement of this IoT based Attendance System application is

  • To use Ethereum to make the application up to date with the technologies
  • To generate automatic weekly and monthly reports

DATABASE TABLES SCREENSHOTS

Tables in the project.
Test case showing the home page after pasting the URL in the browser
Test case showing navbar functionalities working.
Test case showing login is done and navigated to the home page
Test case showing student registration is working.
Test case showing faculty registration
Test case showing faculty registration is working.
Test case showing attendance stored in blockchain

IoT based Attendance System Using Blockchain
Test case showing student’s attendance records.
Test case to get student report
Test case showing Student’s attendance report.
Test case showing download report is working
Test case showing all student details.
Test case showing all student’s attendance records.

Flow Chart Diagram:

Flow Chart

Architecture Diagram

Architecture Diagram

Usecase Diagram:

usecase diagram

Software Requirements

Programming Language: Java
Graphical User Interface: HTML, CSS with Bootstrap, JSP
Libraries: MYSQL connector jar file, Apache Tomcat jar file
Encryption Algorithm: SHA-256
API: JDBC
Framework: Java EE
Tool: Eclipse, MYSQL

Hardware Requirements:

IOT Fingerprint Scanner

Hospital Patient Medical Records Information Project App

Introduction

Information and communication technologies (ICTs) have great potential to improve health in all countries by enhancing access to health information and making health services more efficient. Mobile applications (apps) and other related software can also improve the quality of services and reduce their cost. The aim of the Patient Medical Records Information project was to enable health care practitioners such as doctors and nurses working in hospitals to be able to retrieve patient medical information remotely on any mobile device.

In this Patient Medical Records Information report, I will outline the research I conducted in choosing various technologies. I will discuss the problems I encountered and the solutions I came up with to overcome these issues in creating the specific application. I will also discuss the many technologies I used in the creation of the app including a data model representing the design.

The architecture of the solution

The overall structure of the solution is that the mobile app is being created for the hospital to maintain patients’ records and keep nurses and doctors up to date without carrying heavy paperwork around with them. The technologies I used to create this app suggested by my supervisor were Ionic, PHP, Angular JS, JavaScript, and MYSQL.

PHP provides integration of general-purpose programming and web-development scripting language. It is suited for server-side web development, and scripting and is used for professional websites. AngularJS is used for dynamic web apps and allows you to use HTML as a template language extending HTML’s syntax to express the application’s components clearly and concisely (Docs.angularjs.org, 2016). I chose both PHP and AngularJS because I had very limited knowledge of how they work and I wanted to improve my knowledge and skills in using them and they were also free. 

JavaScript is a programming language used to make web pages interactive (Chapman, 2016) and MYSQL Database is an open-source relational database management system (RDBMS) based on Structured Query Language (Search EnterpriseLinux, 2016).  Both of these programs were chosen because my supervisor requested me to use them and they were also free to use. Finally, Microsoft AZURE Cloud storage is open cloud storage, flexible, enterprise-grade cloud computing platform (Azure.microsoft.com, 2016). I decided to use this platform as my supervisor provided it to me free of cost I researched it and I found a lot of information online to help me complete this project.

The clients who are the doctors and nurses wanted to be able to log in to a mobile app to retrieve information in relation to patients. Firstly the doctors’ requirements were to be able to see all of the patients registered to him/her and the associated patient information. Nurses wanted to be able to log in and see all patient files and associated information as they worked with all patients. The second requirement was that once the doctor/nurse logged in to the mobile app they would have the ability to update the patient records for example blood pressure, heart rate, types of medicine, etc and they could also add notes or remarks. When the remarks and related updated information is added to the mobile app it then updates all the medical history and notes related to the patient. Furthermore, once the doctor/nurse checks the patient’s information in the future the patient’s information will be updated which makes it an effective and efficient method in contrast to multiple physical files.

The Hospital Patient Medical Records mobile app itself is written in AngularJS and JavaScript and through the HTTP requests the mobile app sends the requests to the PHP and the PHP then retrieves the data from the cloud MYSQL and transmits the data back to the mobile app.

Class diagram and Data Model

Through the HTTP requests the mobile app sends the requests to the PHP and the PHP then retrieves the data from the cloud MYSQL and transmits the data back to the mobile app. I designed the mobile app using these technologies as it was a requirement of the project given by my supervisor.

Technologies used

The technologies used included:

  1. JavaScript
  2. PHP
  3. AngularJS
  4. MYSQL Database
  5. Microsoft AZURE Cloud storage 
  6. Ionic

I chose both PHP and AngularJS because I had very limited knowledge of how they work and I wanted to improve my knowledge and skills in using them and they were also free. 

JavaScript and MYSQL Database were chosen because my supervisor requested me to use them and they were also free to use. I utilized Microsoft AZURE Cloud storage as my supervisor provided this platform to me free of cost and I researched it and found a lot of information online to help me complete this project.

Problems Encountered/Solved

At the beginning of the Patient Medical Record project, I was overwhelmed with the task at hand as I didn’t know where to start or what to do, so my project supervisor guided me and gave me advice about how to commence the project and what to do to begin.

The first time I tried to retrieve the data from the database it took me 4 days to retrieve it. Subsequently, I spoke to one of my colleagues and my project supervisor and did some research online and I figured out how to retrieve the information more efficiently and effectively.

Time management was an issue because I had many assessments to do and I left work late and I was running out of time in the end. For example during the Easter break, I had numerous projects due so I found it difficult to allocate time to all of the different assessments. I also wasted my time using a Google database called Firebase at the beginning of my project but later on, I decided not to use it because of the project requirements, and as a consequence, I wasted 2 weeks.

Also in relation to time management, I didn’t anticipate how time-consuming the research from the project would be. E.g. it took me a number of days to understand PHP and learn how to write a PHP script that could talk to the database. AngularJS was never taught in college so I had to take the time to teach myself. Although I completed the project in the allocated time I learned the importance of organization and prioritizing work.

Conclusions

Mobile technologies are emerging as a powerful tool for health information transfer including making patient information portable and accessible. I gained a lot of experience from using the 4 technologies and I believe I have the capability of using them if needed for future projects or for employment purposes.

I am also aware of how to solve specific problems and how to research these problems e.g. in relation to database retrieval or how to successfully manage my time. I recognize that I can overcome difficulties and achieve my goals successfully by being persistent, organized, and patient. Although working in isolation on individual projects it is important and is a necessary part of employment it is important to seek advice or guidance from superiors or colleagues that may shed light on an issue or provide a new perspective.

Recommendations

In terms of further developing the Hospital Patient Medical Records Information Project App, it could be linked to local GPs, pharmacies, and other health care providers so there is a complete holistic picture of the patient and his/her medical history. I would also have managed my time better as I was under severe pressure and time constraints and this may have affected the quality of the end product.

Citizens and the Municipal Authorities Connecting System Project

Abstract

Citizens & Municipal Officials Connecting System is a project that is designed to facilitate the citizens and the Municipal Authorities to simplify the process of complaint filing and management. It consists of a mobile application for the citizens as well as an ASP.NET web application for the Authorities. The citizens can file complaints through the app and the authorities will get those complaints and assign them to the appropriate officer.

The officer will then solve the complaint and notify the administrator through the system, the administrator will then change the status of the complaint. The user can track all of this through their mobile app from their dedicated section to view the complaint status.

This system is a significant improvement over the existing system of complaint filing and management, and hence we believe that our project can make a significant contribution to the modernization of the governance procedures.

INTRODUCTION

Citizens & Municipal Officials Connecting System is a tool designed to function as a platform for the citizens to communicate with the Municipal corporation authorities and replace the old method of writing letters and e-mails as they are a time-consuming mode of communicating with the authorities.

  • Background

In this age of rapid urban development and internet connectivity, the gap in communication between the residents of a city and the Municipal Corporation that runs the city should be reduced to a bare minimum.

Unfortunately, there hasn’t been much progress in that area or it has been very slow because this topic hasn’t been seen as a priority by the authorities even with all the technological advancements, due to which the citizens have suffered as they are yet to see a channel of communication that is as fast and as up-to-date as the technology of today.

  • Objectives

The objective of our project is to provide solutions to both – the citizens and the municipal corporation. We aim to provide the citizens with a platform, which they can use to communicate with the authorities.

Another objective of the project is to provide the municipal corporation with a tool – which they previously didn’t have – to manage all the complaints that they receive, freeing them from the responsibility of managing all the heaps of files that are present in their office.

The most important of all the objectives is to save the time of the Municipal authorities so that they can focus on multiple tasks in a single day and utilize their time more efficiently. Other secondary objectives include creating awareness among the masses about the digitization of the traditional paper-based administration – which is regarded as time-consuming – as we are moving toward the idea of a Digital India.

  • Purpose, Scope, and Applicability

The following are the purpose, scope, and applicability of the city reporting system that we are going to develop.

  • Purpose

The project has been undertaken by us to simplify the communication process between the authorities and the citizens by removing the unnecessary and time-consuming formalities that are in place right now and putting in its place a new system that uses an entirely new channel of communication – the Internet and the mobile phone.

Since the citizens can directly communicate with the authorities, it saves a lot of their time as they don’t have to follow a certain protocol anymore, the authorities will forward their query or complaint to the appropriate officer in charge and make the whole process hassle-free for them.

This way the authorities also don’t have to deal with all of the extra paperwork like forms and letters resulting from the old method of registering a complaint, all they have to do is to forward any complaint that they receive to the appropriate officer and that officer will take the necessary steps needed to solve that particular complaint.

  • Scope

The scope of our system ranges from the citizens that will use the system to report their grievances, to the Municipal authorities that will use the system to then manage those complaints and solve them.

This offers us multiple avenues where we can simplify the process of complaint filing and complaint management for both the parties involved respectively.

Citizens can have various problems, like waste disposal, water supply, sewage, drainage problems, waterlogging, etc., through the mobile application they can just simply click a picture and post a complaint, which will then be forwarded to the concerned officer. Thus we are building a single platform that can be used to resolve a wide range of issues about most of the departments in the Municipal Corporation.

Thus we can say that our project is not just one dimensional in terms of its scope we have tried to cover as many areas as we could, and we have also tried to make our project scalable so that we can build upon the existing architecture instead of building a new system entirely from scratch.

  • Applicability

The citizens here can file their complaints in a matter of a few clicks instead of making a personal visit to the local Municipal Corporation office due to which the transportation time and cost of the citizen are saved and the paperwork is also reduced making the whole operation an environment-friendly one.

The Mobile app can also help people with certain physical disabilities to file complaints without having to worry about traveling to the Municipality office and properly handling the paperwork or documentation and going from table to table, to find the right officer to submit their complaint since the app can do both the things for them so that they don’t have to take all the trouble by themselves.

Municipal officers that have been assigned a complaint through the system will need to provide a proof-of-work that they have solved that particular issue and not just click solved on the screen and think that their job is finished, in this way we are promoting accountability of the officers towards the citizen.

ER Diagram:

ER Diagram

SYSTEM ANALYSIS

Existing System

Till now most of the complaints are filed physically or via emails, which in the case of emails require multiple email IDs too, for the relevant authority of a particular department. This might take a lot of time and effort for finding the authority first, for a particular kind of complaint, and then find an email ID of the department.

Due to these multiple channels of communication, the authorities also find it difficult to track every complaint since the users might file their complaints through the medium of their choice, this leads to confusion among the authorities as there is no central system that manages all of the complaints in a single place

Proposed System

This system will not only save the time of the complaint filers but also allow them to track their complaint and their status at regular intervals of time. Once the complaint is solved, the user gets the update on their phone..

Requirement Analysis

  • Problem Definition

Nowadays it is important that if a user is using a mobile app, they have to be provided with accurate information/guidance and proper security of their data should be implemented, to create trustworthiness between the citizens and the government. Authentication and verification of users have also become mandatory now.

  • Issues

Some of the issues that the citizens face with the current system are as follows

  • Time Consumption: Travelling to the office of the Municipal Authorities and filing the complaint physically is a time-consuming process as it involves hopping from table to table.
  • Dealing with Paperwork: Another problem with the physical method is that involves dealing with a lot of paperwork. The citizens have to fill out various forms to file even a single complaint.
  • Lack of accountability: Municipal officers in the past have been accused of not being accountable to the citizens, through our project we are promoting accountability among the Municipality officers.
  • Requirements specification

Here we are going to develop a system that acts as a communication channel between the citizens of a locality and the Municipal Corporation of that locality the main objective is to provide a common interface between the citizens and the authorities so that they can communicate trustfully, at ease and without any inconvenience for both the parties involved.

Overview

  • The user can file a complaint by logging in to the app
  • The user will be requested to create and register an account by filling out all the details that are required
  • A complaint ID will be generated when the user files a complaint it will be unique for every complaint the user files
  • The user can track the status of all their filed complaints through a separate tab called ‘complaint status’.
  • The administrator will be able to delegate various complaints to an officer under him.
  • The officer can change the status of the complaint assigned to him once he has solved the complaint

Online Medical Shop DBMS Python Mini Project

This project is based and innovated on an Online medical shop, wherein we store all the details about the customers, the stock of the medicines, orders, and payments and also the project will include a page wherein the user will indicate the symptoms and will get a probable disease and the prescribed medicine.

The project is aimed to modernize and support existing small business owners. In the age of technology where online medicine is dominated by e-commerce giants such as 1mg, net meds, etc. We wanted to develop a solution for small business owners as well.

The existing Medicinal systems have the provision for any user to book a request for a particular medicine through e-commerce. And further, the traditional methods to visit the medicinal centers for mere inquiry are time-consuming and monotonous and the non-availability is disappointing.

The data relevant to the processing of the request may or may not be manually stored or be captivated in a file system that is prone to manual errors, inconsistency, redundancy, and difficulty in retrieval. With our system, the availability can be shown so, even if a customer wants a pickup of his/her medicine. they can do so without any problems. Our model also has an integrated web scraper, which is an innovation we have come up with. This scraper can scrape medicines off the net for data warehousing.

This system maintains the storage details of all the customers and medicines that are stored in the shop. The system will keep track of the orders made and the payment details. NoSQL will be used to store future suggestions and customer reviews.

The main part of the project will be a part where the customer will be able to select his/her symptoms and medicine will be referred to them. Along with the expected disease. We also would integrate Web Scraping of all the medicines related to a particular disease entered by the user to store it in our database.

Software Requirements

• Language support required: Python 3.5 or later, HTML5, JS, CSS3
• NoSQL database required: MongoDB
• Relational Database required: MySQL
• Windows 7 or 10 /Mac OS X 10.11 or higher, 64-bit /Linux: RHEL 6/7, 64-bit (almost all libraries also work in Ubuntu)
• Heroku and pip are preferred for deployment and installation of packages (such as Django,asgerif, mongoose, etc) specified in requirements.txt
• A web browser support is needed.

If using the software through deployment, no language support in your machine is required.

Conclusion & Future Enhancement

This project was successfully built and completed. The project is an online medical shop with two categories of users (admin and customer) who can update inventory and place orders respectively. We have also added a web scraper as an innovation to this project. However, there are a lot of changes and addition of functionalities that can be done, which we intend to do after peer and faculty review.

Some of the enhancements are :

  • Listing of products linked with images to generate a more shop-relevant UI
  • Remove some programming language constraints
  • Online Deployment
  • And changes that our faculty and peers suggest.

In the end, we would once again thank our college, examiners, faculty guides, and teachers to help us finish the project within the speculated timeline.

Supermarket Management and Billing System Java Project

The project is on Supermarket Management and Billing systems. The supermarket is a huge shop where we all can find a lot and lots of products may whether grocery or fashion or utensils etc. in the various categories in different departments. Also, there is a huge number of staff in different positions. It has to keep all the records of its staff so that the employee management would be effective. So, to make such problems easier to handle we have developed this system that not only keeps authentic data may that be of transactions into and out of the supermarket or that be the information of its employee.

The manager module in the software helps to keep information of employees and the cashier and the data entry operator module helps to keep records of transactions inside and out of the supermarket.  The barcode scanning system in the software help to run the transaction process fast and effectively.

INTRODUCTION

The Supermarket Management and Billing System, a desktop application, is developed to provide all the facilities and services required in various shops like shopping centers, mini-mart, fancy shops, etc. The main objective of the system is to provide efficient transactions with minimal error.  Bar code scanning technology helps cashiers with faster and more efficient billing. Cashier, manager, and data entry operator are provided with their own authorization account so that only the authorized person can perform their respective jobs. Users in the system: –

  • Cashier: a – person who handles the transaction
  • Data entry operator- enter the products imported into the store as well as update the details.
  • Manager- supervise all the activities going on in the shop

Statement of Problems

  • Manual data entry takes much more time than the barcode method.
  • The manual calculation can generate errors while buying or selling goods.
  • More time consumption for any transaction and findings of the products.

Objective and Scopes

  • To provide an efficient and effective billing methodology.
  • To keep a record of every business transaction
  • Maintain the stock management and the billing system
  • Reduce the time consumption for every process in the buying and selling of goods.

Database ER Diagram:

Database ER Diagram

METHODOLOGY

The project is to do with the concept of OOP (Object Oriented Programming) with Java and relational database with MYSQL and for the excess printer for the billing process we use Visual Basic Script (VBScript).  Taking into account the statements of the problem, we developed a system that not only helps in maintaining precise transactions but also keeps track of every business that has been done. There is the provision of a login module for individual employees as per their job title after which they will be provided with their respective job functions. With the help of the software, they can achieve a better working experience along with consistent precision.

There are various organized tables which makes the software very effective. The shop assistant module is the symbol of modern business techniques. It is a customer-friendly module. The manager has an organized manner of employee management such as addition or removal of cashier or data entry operator or shop walker. S/he has access to the profile of every employee in his hand at any time of necessity. Logs module helps him/her to analyze the customer’s choice. Furthermore, the automation in the billing system helps the cashier in their transaction in a very precise manner. The use of barcodes makes it easier for making bills and the automatic calculation prevents them from simple mistakes.

CONCLUSION

Supermarket Management and Billing System are developed for the professional handling of the supermarket’s sales and buying as well as the management of the whole supermarket. It is very easy and useful application software that increases the productivity of the business.

Our project on Supermarket Management and Billing systems has been implemented successfully. We take this opportunity to express our sense of indebtedness and gratitude to all those people who helped us in completing this project.

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.