Security Analysis and Implementation of Supermarket Inventory Management System

This Supermarket Inventory System creates purchase orders once the inventory level reaches a predefined level. Supermarkets and the vendor’s warehouse use this system to create receipts and invoices. The accounting department uses this system to match invoices and receipts so that the payment can be recorded accurately.

Through this project, we will be able to focus on both small and big retail stores in helping manage the Inventory of their store with security implementation. If taken in a more general form it can be used to manage inventory of even Production houses and Warehouses.

The Inventory Management System is an application designed to allow the supermarket staff to create, maintain and view the contents and value of its inventory of items in a categorized way. It also aims to analyze the position of the supermarket in the market and help it know what items to order in what quantity by producing graphs depicting the sale of different items on different basis such as monthly, yearly, brand type, etc. The main goal as of now is to implement the application by considering security loopholes.

We will analyze and implement web security in this project followed by a case study on cyber crimes in India. By security inputs, it will decrease the vulnerability of applications being hacked and attacked. It provides the surety and trust to the customers that their resources are safe and secure. Customers’ trust should be an organizational job. It also determines the use of information security at its pick level to resolve real-world problems.

Overview of the Project

The Inventory Management System is an application designed to allow the supermarket staff to create, maintain and view the contents and value of its inventory of items in a categorized way. It also aims to analyze the position of the supermarket in the market and help it know what items to order in what quantity by producing graphs depicting the sale of different items on the different basis such as monthly, yearly, brand type, etc

The supermarket Inventory System is to facilitate our customers to track their products as and when they are transported from the vendor to the warehouse and from the warehouse to the retail location to the customers. It is necessary to keep our resources safe and protected. In order to implement security in the application it would be done by implementing encryption, keeping a secure session base password, implementing two-level authentications, observing system logs and security faults, analyzing network flow using Wireshark, implementing Wireshark, preventing the application validation from unnecessary inputs, session management, session hijacking, hacking, cross-site scripting and implementing code to prevent from SQL injection and many more.

Sample Home page emphasizes the basic details about IMS organization. Authorized and registered customers would be able to login in IMS system to track and place their orders. They can look at the GST module, can contact our customer support team for any queries, review frequently asked questions FAQs, latest sales available, and many more. New customers can visit our portal to know about the IMS organization and can contact us.

Conclusion:

This Supermarket Inventory System creates purchase orders once the inventory level reaches a predefined level. Supermarkets and the vendor’s warehouse use this system to create receipts and invoices. The accounting department uses this system to match invoices and receipts so that the payment can be recorded accurately. Through this project, we are able to focus on both small and big retail stores in helping manage the Inventory of their store with security implementation. The main goal as of now is to implement the application by considering security loopholes. We have analyzed and implemented web security in this project followed by a case study. By security inputs, it decreases the vulnerability of applications being hacked and attacked. It provides the surety and trust to the customers that their resources are safe and secure. Customers’ trust should be an organizational job.

Future Scope:

The future scope of this Supermarket Inventory Management System project is vast, as we are trying to implement security and decrease loopholes that help to create security awareness. It will be helpful and used in government organizations, private companies, and nonprivate sectors; researchers to make it much better and would be referred by institutions too. Further enhancement of this project will really help to build own company that provides Inventory support with all security features that will be used by all storekeepers, allowing the supermarket staff to create, maintain and view the contents and value of its inventory of items in a categorized way with less vulnerability. This system is a tool for tracking asset levels, order management, safety stock, sales, and deliveries. It would help to avoid product overstock and outages.

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

Library Management System Using PHP, JavaScript, HTML, CSS and MySQL

Introduction

The Library Management System is an application to manage various tasks such as check out and check in of books, adding the borrowers, and fine management of the books.

Functions:

1. Search Books based on keywords.
2. Select the book and checkout if available.
3. Check in the book.
4. Pay fines for books checked in after the due date.
5. Add borrowers.

Architecture

To implement the system, various schemas were built which are described below:

1. Book
The book table contains the ISBN, title, and availability of the book. Here, ISBN acts as the primary key of the table.
2. Book Authors
The Book_Authors table contains the Author_id and ISBN number of the book written by the author. Here, Author_id and ISBN act as the primary key.
3. Authors
The Authors table contains the Author_id and name of the author. Here, Author_id is the primary key.
4. Borrower
The Borrower table contains the card_id, SSN, Name, Address, and phone number of the Borrower. Here, card_id is the primary key.
5. Book Loans
The Book_Loans table contains the Loan_id, ISBN, Card_Id, Date_out, Due_date, and Date_in of the book loans. Here, Loan_id is the primary key.
6. Fines
The Fines table contains the Loan_id and Fine_Amount of the book loans. Here, Loan_id is the primary key.

The application is built on MVC (Model View Control) Architecture.

Libraries and Software Used

Software Used: Wamp(Apache, MySQL, PHP)
Database: MySQL
Language: PHP, JavaScript, HTML, CSS, SQL
Libraries: Bootstrap

User Manual

There are 4 navigation links on the index/home page. The following are the functionalities of each tab:

1. Search Books

The user can search books from the database by typing the keywords into the search box provided and clicking the search button. If the keyword matches the records in the database, the result is displayed in tabular format. On clicking the row of the table, the user can proceed to checkout if the book is available by providing the card id.

2. Check in Books

First, the user needs to search for the record by providing the keyword in the search box and clicking the search button. After the results are fetched, on selecting the required row, the user can check in the book.

3. Pay Fines

On clicking the refresh button, the user can see the total summed fines of the borrower based on their card id. On clicking the required row, the user can pay the fines.

4. Add Borrower

By filling out the form and clicking on submit button, the user can add a borrower to the database.

Download Library Management System Project Using PHP, JavaScript, HTML, CSS, and MySQL.

Food for Life PHP Minor Project Synopsis

Introduction

”FOOD FOR LIFE” is a food relief web project to serve food for the needy. Nowadays, One-third of the food produced is being wasted and about 9 percent of the people in this world go to bed on an empty stomach. In this Minor Project, various party palaces or hotels have to give information about their unused food on our website and we or other organisations have to collect the food and distribute the food to the needy.

Technologies to be used

 This Food for Life project will be a Web application to be developed in PHP having below technologies:

  • PHP
  • HTML
  • MYSQL
  • JavaScript

Technical feasibility

The technical needs of the Food for Life system may include:

Front-end and back-end selection

When we decided to develop the Food for Life project we went through an extensive study to determine the most suitable platform that suits the needs of the organization as well as helps in the development of the PHP & MySQL project.

Front-end selection:

    1. Scalability and extensibility
    2. Flexibility
    3. Robustness
    4. Platform independent
    5. Easy to debug and maintain

Back-end Selection:

1. Multiple user support.
2. Efficient data handling.
3. Provide inherent features for security.
4. Efficient data retrieval and maintenance.
5. Easy to install.
6. Various drivers must be available.
7. Easy to implant with the Front-end.

Objectives 

The main objectives of this Food for Life project are:

  • The main objective of our academic minor project is to reduce food wastage as many of us throw unused food in dustbins
  • The objective of this is to help the organization that serves food to the hungry people

Conclusion 

This ”Food For Life” project is to feed hungry people with the help of our system. Organizations such as hotels or restaurants have to publish the details of their food on our Food for Life website.

College Classroom Check and Fill Mini Project Synopsis

Introduction

The Classroom Check and Fill project is to prepare a website that tells the current status of a particular room. It tells whether a class is going on or empty or there is no class in that particular room. . It uses the technologies like PHP, python, java, MySQL, and many more. With the help of this website, a teacher or a student can know the status of the room and work accordingly.

Objectives

The aim of our project is to help teachers and students to check if in the room a class is going on if the room is empty or if there is no class in that particular room.

1. To help the HODs and teachers to check whether the venue is empty or not (in one click)
2. To help students to check their timetables with ease
3. Provides user-friendly application

Methodology/ Planning of work

Step 1: GATHERING RELEVANT INFORMATION
Our project is to help teachers and students to check if in the room a class is going on or the room is empty or there is no class in that particular room. We will take the relevant information from the CR of a particular class of IT and update the status of the room accordingly.

Step 2: PLANNING

Step 3: DESIGN LAYOUT

Basically in this step, we create the front-end part of our website with the help of languages like HTML, CSS, Bootstrap, and Javascript.

Step 4: DEVELOPMENT

Step 5: TESTING, REVIEW, AND LAUNCH

Step 6: MAINTENANCE AND UPDATION

Facilities required for proposed work

Hardware Requirements: Laptop – i3 processor or higher, 4 GB RAM or higher, 100 GB ROM or higher
Software Requirements: Laptop or PC, Windows 7 or higher, Visual Studio, HTML, CSS, Javascript, Mysql, Php

References

[1] Geekathon series(2013)[Online]. Available: http://www.GeeksforGeeks.com
[2] Jimmy Wales, Larry Sanger (2001)[Online]. Available: http://www.Wikipedia.com
[3] Refnes Data (1998)[Online]. Available: http://www.w3schools.com
[4] Steve Chen (2005) [Online]. Available: http://www.youtube.com

StellarStudent College Student and Faculty Communication Project

StellarStudent is a web application that deals with students and faculty. Ever since digitalization started in the country, schools and colleges want the best way possible to share information with their students. Some colleges use Google Drive or Whats app to share materials or collect other documents. However, the chance of data loss or misplacement is guaranteed. It is better for the college to have an admin who can look after all the happenings on the college website with just one click. With high security and validations of users, the chances of data misplacement are low with StellarStudent.

This Student and Faculty Communication project aims to connect the students with their faculty with no miscommunication. It is a web-established web-based application that involves faculty uploading study materials and notices like events and placement drives, viewing certifications, and quiz results of students. Students can also communicate with each other via the exchange of images, feedback, and discussion. This application can be handled by the admin and manage students as well as faculty.

Objective 

The StellarStudent is a web-based Student and Faculty Communication project for BVRIT-H students and faculty. The main objective of this project is to let college students interact with their faculties.  In this project, the faculties can upload materials, quizzes, etc. Even students can ask questions to faculties and can also upload the certificates. Our main goal is to ensure cost-effective, technical excellence, and secure apps.

Methodology 

To store the user data MYSQL has been used as a database. HTML and CSS have been used for front-end development. PHP is used as a server-side language, which is used to connect the front end to the back end. We can run this application in our browser.

Software requirements specifications

 Introduction:

Student and Faculty Communication SRS describes the requirements and specifications of StellarStudent, a web-based application for the college. 

Purpose:

The purpose of this document is to present a detailed description of StellarStudent.

Scope:

The project StellarStudent helps college students to interact with their faculties and many more. This web application can be accessed by students and faculty of BVRIT HYDERABAD College of Engineering for Women.

Overall description

The project StellarStudent is a web-based application with two interfaces: One is for students and another is for management. The website works on desktop computers, laptops, and mobile devices with the help of a browser.

Project Functions:

The project Student and Faculty Communication has the following product functions:

  • The web portal will provide the functionality to manage the system and the student
  • The website is secure because users must enter login details to access the
  • The system contains a huge For this reason, the search option has been provided on all report pages. The search results can be viewed in the list view.
  • The product works online with help of the internet

Assumptions and Dependencies

    • Internet connection
    • 24X7 uptime server connection
    • One assumption about the product is that it will always be used on mobile phones that have particular technical support.

Modular Decomposition of Components:

Dashboard Component

• Admin account
• Publish news
• Publish events
• Publish meeting schedule
• Add course records
• Add subject records
• Add certificate types

Faculty Component:

• Quiz materials
• Study materials
• Students record
• Faculty profile
• Certificates

Discussion Component:

• Post discussion forum
• Discussion reply
• View discussion forum

Quiz Component:

• Upload quiz question
• Attend quiz exam
• Quiz result

Study material Component:

• Upload notes
• View study materials

Certificate Component:

• Upload certificates
• View Certificates

Upload certificate by student Screen

View Uploaded Certificates

Online Learning Management System PHP Project

Objectives of the Project:-

The general objective of this Online Learning Management System project is to provide various courses to students as well as others who are interested in learning online. The use of the internet has increased and so the courses are available to be learned online. By providing this option, it would be easy for the users to learn by sitting in a comfortable place and learning based on the time they have.

The courses will be added, deleted, etc. by the admin. This project consists of the front end and back end sides. The front end side of the website is developed for the general public who are interested to know about us and to find out the courses provided by the management system. The back end is for the users who have created their accounts and admin utilities.

Scope of the Project:-

For this project, to store all the data various tables and attributes are required. As the main idea of this project is to provide courses for the students to enroll in and learn, it will also allow the instructors to teach courses. Thus the scope of this project is limited to the following tables: COURSES, USER DETAILS, STUDENTXREF, and INSTRUCTORXREF.

User requirements:-

Following would be the basic user requirements-

  1. Users should be able to view the Home page, About Us, and login/Register page of the website.
  2. Users should be able to search for the courses in which they are interested.
  3. Users will be asked to enter the user type as Student, or Instructor while creating the account.
  4. Users who have been marked as Students will be allowed to enroll in the available courses and will be displayed the courses in which they are already enrolled.
  5. Users marked as Instructors will be able to teach the course which is not taught by anyone else. They will be able to see the courses which are taught.
  6. Admin type of user will be able to add or delete courses as well as delete instructors from the courses.

*Note – User can be general public without creating an account, student, instructor, and admin.

Business Rules:-

Below are some basic business rules-

  1. One student can enroll in many courses.
  2. Every single course can be taken by many students.
  3. One instructor can teach many courses.
  4. One course will be taught by only one instructor.
  5. Users can be students or instructors based on the details entered while creating an account.

Entities and their attributes:

In this proposal, there are basically 4 entities. The description for each is given below-

USERDETAILS Entity –.When a student or instructor wants to enroll/teach for any course, first of all, they will have to create an account on the website by using the login page. All the details entered while creating an account will be stored in this table. This table will consist of the attributes as User id, user last name, user first name, user type (it can be student or instructor), and password. The primary key of this table will be the user id. Once the user has created an account, they will be able to know about the courses.

COURSE Entity – The course table will store all the details related to the courses which are offered. This table will have the following attributes Course id, Course name, course department, course description, course start date, and course end date. Course id will be the primary key for this table. Based on the above attributes, students can decide which course they are interested in. The instructors will also be able to know about the courses which are already taught by some other instructors and the courses available for them to teach.

STUDENTXREF Entity- This table will act as a reference table between the COURSE and USER DETAILS tables. The attributes of this table are student id, course id, and user id. The primary key of this table will be the student id.

INSTRUCTORXREF entity – This table is also a reference table between COURSE and USER DETAILS tables. If the user type is instructor then the details for that user id will be stored in this table. The attributes of this table are instructor id, user id, and course id. Instructor id will be the primary key for this table. Here the course id will be unique as 1 course cannot be taught by multiple instructors.

Entity-Relationship Diagram:-

Fig 1: Entity relationship diagram for Online Learning Management System.

Website Description:-

The online learning management system is a system that provides students to learn about various courses online. Various pages have been created for the users like Home Page, About Us page, Login/Register Page, and Search courses page.

The sitemap for the online Learning management system is as:

The project consists of the Front end and back end. The front-end pages are described below:

Home Page:

This page is the main page of the project. This page gives a brief description of the management system and also posts the latest courses which are going to be added in the future. This page will be linked to all other pages. Whenever the user is interested in learning any course, then they need to create an account by clicking on the Login/Register button provided on the navigation bar.

Login/Register Page:

The login page lets the user enter their username and password to login to their account. There are three different links for students, instructors and admin in the login/register page. Students can click on the enroll/register for courses link in order to login into the account. Students who are already registered can put in their username and password to login to the account. In the case of new users, they can register for a new account by clicking Join us button. In order to sign up for an account a user needs to enter an email address, preferred username and password, and date of birth. The user has to make a selection of the account type either teacher or student from a drop-down menu. Then they can simply login into their account. 

The login page lets the user enter their username and password to login to their account. There are three different links for students, instructors and admin in the login/register page. Students can click on enroll/register for courses link in order to login into the account.

Students who are already registered can put their username and password to login to the account. In case of new users, they can register for a new account by clicking Join us button. In order to sign up for an account a user needs to enter an email address, preferred username and password and date of birth. The user has to make a selection of the account type either teacher or student from a drop down menu. Then they can simply login into their account. 

About Us Page:

This page describes the goal of developing this project. This will make clear to the users what the purpose of developing this website is and how they can use it. Contact information is also provided for the users so that if they have any doubts, they can send an email with the query. 

1.6.4 Search course Page:

When a user is interested in learning any course, before creating an account he can check whether the course in which he is interested is provided by the management system or not. This search option will help them to know about the courses and then they can decide whether to enroll in those courses or not. While using the search option, users are not required to create an account.

The back end part will come into the picture when the user has created an account. Users can be students or instructors. While creating an account, the user will be asked to select the User type from the drop-down option. The pages at the backend side are described below:

Student Page:

This page (student.php) will be displayed to the user whose user type is Student. It will display the courses which are available for a particular student to enroll. He can select multiple courses for enrolling. Checkboxes are provided in front of all courses and then finally enroll button is provided.

Once the student selects any course and clicks on Enroll button, he will be shown a thank you message for enrolling in those courses. Student.php will call enroll.php when an enroll button is clicked by the student. The back button is provided on enroll.php which will re-direct the student to student.php. The student will also be displayed the courses in which he has already enrolled on student.php. 

Instructor Page:

When a user selects the user type as an instructor, he will be directed to instructor.php page. On this page, he will be displayed with the courses which he is already teaching. The instructor will be able to teach courses that are not being taught by any other instructor. A checkbox option will be provided to the instructor to select courses and then he can click on each button. This button will direct the instructor to teach.php page where he will be displayed a thank you message.

Admin Page:

Admin page is designed for the administrator to add and delete courses in the system. In order to login as an admin the user needs to select the admin-Add/Delete courses link from the Login/Register page. Two options appears in the admin page 1.Add a course and 2.Remove a course. Add a course lets the admin add new courses in the system.

The details the admin needs to provide in order to add a course are course name, course department, course description, course start date, and course end date. The admin can simply press the Add Class button. A success message appears on the page after the submission of the details. In order to remove a class the admin can make a selection from the drop-down menu and press the Delete Class button. The success message appears afterward.

Functions provided by the website are:

  1. The following are the functions provided by the online learning management system:
  2. Browse the homepage, and about us page.
  3. Search courses without creating an account.
  4. Interested users can create an account.
  5. Students can enroll in courses.
  6. The instructor can teach courses that are not being taught by any other instructor.
  7. Admin can add/delete courses.

Usability considerations:

The online management learning system website has logical navigation. Users can easily navigate around the webpage. The home page gives the users information about the whole system. All the contents are written in simple language. It has a user-friendly interface and functions well with no broken links. All the links and sub-links are clearly represented. The procedures to log in to the account, register for courses, and add or remove the courses from the system are very clear.

The system lets the users know if their attempts of adding courses or removing courses were successful. When the users put wrong credentials while logging in, it lets users know their attempt has failed because of the wrong username or password. So, that user can put the correct information and log in to the account. The website has all the required functions based on user types. That makes the website informative and user-centered. 

FUTURE ENHANCEMENTS:

  1. Based on the entries in the database, graphs can be created to provide information about the number of students in each course.
  2. A class entity can be added to provide more information about courses like classrooms, class timings, etc.
  3. Change the template to make it more attractive and user-friendly.
  4. Passwords can be stored in an encrypted way to avoid giving away personal information.

Covid-19 Testing Management System Python Project

Covid-19 Testing Management System is a small project developed using Python programming. Here are the application features below.

Project features:

• Adding new testing centers
• Search for available testing centers by locality
• Update and delete testing centers
• Show all testing centers by city, state
• Shows the number and type of testing kits available at each center.

Software to be used to develop this application:

• Python
• SQL for creating a database
• Library to interface between Python and SQL
• Either Django (to create a web app) or a GUI library to create the UI (not decided yet)

Implementation

1. Login page (This has a simple login prompt designed using a GUI library that asks for the user id and password.)
2. Menu:
a. Add a testing center
B. Delete testing center
C. Edit the number of testing kits available
D. Search for the testing center by district/city/state
E. Show all testing centers
3. Separate sections for:
a. Adding a new center
b. Deleting center
c. Updating center information
d. Searching for center
e. Nationwide data

Covid-19 Testing Management System can be developed by using PHP & MySQL Server with different functionalities below.

User Characteristics

The Covid 19 Testing Management system has 2 types of users they are Admin and user(patient)

General Constraints

The tools and technologies that are used to develop this project are:
The language used in this project is PHP5.6 and PHP7.x.
The database used in this project is MySQL 5.x.
The web browsers that are used in this project are Mozilla, Google Chrome, IE8, and OPERA.

Operational Scenarios

Scenario A:
How your application starts
Our application covid19 testing management system starts by login into the application, if the user is a new user, the user needs to register by providing the needed credentials.
New users need to provide testing information. A registered user needs to provide test information.

Scenario B:
Usage Scenarios like Customer Check-out
When a customer visits our application, he/she needs to log in by providing their credentials according to their role i.e., admin and user.
If the user is new, he needs to register if he is an old user, he can directly enter the login details and login directly.

Scenario C:
Database

The data that we are going to store in the database
1) Admin Login
Username
Password

2) New admin login
Admin name
Username
Password

3) User login
Username
Password

4) New user login
Name
Phone number
Username
Password

5) User Registration
Name
Current address
Gender
D.O.B
E-mail id
Phone number
Age
Aadhar card number

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

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.

Design & Development of Disaster Safety Android app

A Disaster Safety Android app that helps people inform you about everything that is nearby by using help centers before and during an accident. Also, a PHP-based website to enter data on the server-side and work with the android application successfully. The Disaster Safety mobile app also gives you the location of all your friends and family that have been accessed by the user. The app can store offline maps and information about help centers also comes through messages and is displayed on the map.

Innovation:

India being a disaster-prone country suffers a lot of casualties every year not because of the lack of resources but because of the lack of information on these resources. This app brings the resources to you, even when you are in the middle of nowhere and knows nothing about what to do in such a situation, Disaster Safety app can save your life.

Features:

  • It works in offline mode and saves the data.
  • It not only works at the time of disaster but also in various situations like you are any kind of trouble or your phone is lost.
  • Gives the news and the guidelines about the various disasters.
  • Can track the location of your friends and family in danger.
  • Notifies you when your friend or a family member is in danger.
  • Saves a lot of power consumption as works offline.
  • Locates the nearby relief centers, hospitals, and police stations not only by internet but also through SMS.

Database Model

admin user

Column

Type

Null

id

int(11)

No

username

varchar(30)

No

password

varchar(50)

No

family 

Column

Type

Null

member_id

varchar(13)

No

family_id

varchar(13)

No

permission_given

tinyint(1)

No

guidelines 

Column

Type

Null

id

int(11)

No

calamity

varchar(30)

No

before_cal

text

No

during_cal

text

No

after_cal

text

No

help 

Column

Type

Null

id

int(11)

No

latitude

double

No

longitude

double

No

type_of_help

varchar(30)

No

login 

Column

Type

Null

Default

id

varchar(13)

No

 

name

varchar(30)

No

 

status

tinyint(1)

No

1

latitude

double

No

0

longitude

double

No

0

gcm_regId

text

Yes

NULL

news 

Column

Type

Null

Default

id

int(11)

No

 

notification

text

No

 

info

text

No

 

date

varchar(10)

No