Author: Admin

Posted on

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.

Posted on

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.

Posted on

CSE Minor Project on Data Analysis of IT Sector in India using Big Data

Statement about the Problem:-

The IT industry is continuously growing in India, but there hasn’t been any tool yet that can analyze this sector’s growth with such a large dataset with immediate results. Such a problem can be addressed using a tool that can fetch any analysis-related query on huge datasets and can give immediate results.

Why is the particular topic chosen?

This topic finds its relevance in the analysis of growth of the IT industry of India to judge the increase in the number of IT companies in various states and at the central level too.

This tool would be able to handle huge sized datasets of companies which normally are found to be difficult to access in a fast manner to fetch relevant results

Objective and scope of the project

Using a dataset of companies to:

  • Observe IT growth in India for the past few decades in terms of various factors such as Sate wise growth to understand the development needed in the same.
  • Understand private and public sector growth of industries in India.
  • Understand the capital investment involved in various sectors of industry and many more.

Methodology/Process description:-

Dataset of companies which is huge in size will be first accessed through Cloudera software using Hadoop technology.

Using this technology, various queries would be coded down to use the dataset to give back all the results needed in minimal time.

Those results would then be converted into graphical representation to study the growth.

Required Resources :

Software-

  1. Cloudera
  2. Eclipse

What contribution would the project make?

  • This will help in studying the IT structure of India.
  • Various parameters needed to decide future steps to be taken for improvement in various states can be figured out using this analysis.
  • Analyzing growth patterns of various industries in India.
  • It is ultimately creating a tool that would be able to handle any big size of industry data and would give much faster statistical results than normal processors.

The Schedule of the project

  • Identify Statistics needed: (2 days)
  • Data Acquisition: (5 days)
  • Process/Clean Data: (1 week)
  • Exploratory Analysis: (1 week)
  • Designing Queries: (5 days)
  • Creating code: (5 days)
  • Implementing Code & Validation: (1 week)
  • Debugging code: (5 days)
  • Running code and fetching results: (1 week)
  • Graphical Conversion of results: (5 days)
  • Visualize Results: (5 days)
Posted on

Development of Speech Recognition AI Project with Python

Methodology

Working on the Speech Recognition Python Project. Design and Development of Speech Recognition AI Project with Python Source code, report, and ppt using NLP, PLP, and Deep Neural Networks.

Speak– The assistant will speak the following introduction, the output, and the following things according to which good is given. It will use the laptop microphone to hear the input from the user and later recognize the voice said by the user and match the code words and if anything matches it will show the output.

Wish Me-The assistant will speak the Message included in the introduction even if it will wish the morning afternoon and even the evening depending upon the real-time based scenario. It will wish the morning from 04HH to 11HH 59MM. It will wish the afternoon from 12HH to 17HH 59MM. It will wish the evening from 18HH to 03HH 59MM.

Take Command– The assistant will take microphone(speech) input from the user and returns string output. It will be sub-divide into many different parts as described below. Listening-The assistant will open the microphone and try to hear what the user wants to convey to it.

Recognizing– The assistant will try to recognize the input spoken by the user and then check the code whether the word that is recognized by the assistant is there or not if the input matches it will show the output otherwise it will speak “Say that again please” this line which means to give the input again by the user. If the word is correctly recognized, it will follow the instructions assigned to it.

Wikipedia– If the word is recognized as “Wikipedia” it will search Wikipedia according to the input given by the user. E.g. if we say Narendra Modi Wikipedia so the assistant will speak “searching Wikipedia Narendra Modi” and then after it “According to Wikipedia…” and the details of that particular person. Youtube- If the word is recognized as “YouTube”, it will open the internet explorer and directly start opening the default web browser by the link “youtube.com”.

Google– If the word is recognized as “Google”, it will open the internet explorer and directly start opening the Google by the link “google.com”.

Train Information– If the word is recognized as “Train info”. It will fetch the detail from a CSV file and returns the detail of all the train and display them on the terminal. Stack Overflow- If the word is recognized as “Stack Over Flow” it will open the internet explorer and directly start opening the Stack Over Flow website by the link “stackoverflow.com”.

Play Music– If the word is recognized as “Play Music” it will search the .mp3 or .mp4 file in the default path of the device that is provided by the programmer in the programming. E.g. if we say Play Music so the assistant will search in the path like “D:\\Non Critical\\songs\\Favourite Songs2” and it will play that particular song. The Time- If the word is recognized as “The Time” it will check the real-time from the device and speak the same in terms of “HH:MM: SS”. E.g. if we say the time so the assistant will check the time and if the time is 08:14:21 P.M. it will speak “Sir, the time is 20HH:14MM:21SS”.

Open Code– If the word is recognized as “Open Code” it will search the .java or .py file in the default path of the device that is provided by the programmer in the programming. E.g. if we say Open Code so the assistant will search in the path like “C:\\Users\\XYZ\\AppData\\Local\\Programs\\project.py” and it will open the code. Stop- If the word is recognized as “Stop” it will speak “Quitting sir thanks for your time” and the code terminates.

Code-Snippet

Speech Recognition Project Coding

Algorithms used in Speech Recognition

NLP (Natural Language Processing) & Tokenization
PLP
Deep Neural Networks
Discrimination training
WFST Frameworks etc;

The following must be installed-:

1. sudo pip install SpeechRecognition.
2. Sudo apt-get installs python-pyaudio python3-pyaudio or pip install pyaudio.
This is the most important module in your project as it provides the main functionality in our project to convert speech into text.

Future Scope

This specific area of AI ends up being productive in each specialized field. We have additionally actualized this to show how it is valuable in various fields as we have made a little undertaking to exhibit its use in various documented, for example, railroad, looking through feed and so on; Like PCs began to play chess better than human, speech recognition before long will be improved by PCs as well. Critically, that will include some significant information about nature in general and the human mind specifically. So speech recognition is a significant advance in our investigation of natural laws. Our venture can be utilized by railroads and another center point to show distinctive data utilizing speech recognition.

Posted on

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.

Posted on

Design and Implement a Healthcare Monitoring and Management System IoT Project

Nowadays Internet of Things is bringing a revolution in the infrastructure of technologies. The IoT-based health monitoring system is essentially a patient monitoring system in which he can be supervised 24*7. Remote Patient Monitoring arrangement enables observation of patients outside of customary clinical settings (e.g. at home), which expands access to human services thus bringing down costs. Healthcare is given extreme importance by each country with the advent of the novel coronavirus.

Recently there has been a spike in the use of smartphones and along with that, wearable sensor remote health monitoring has evolved quickly. IoT not only helps in preventing the spread of disease but also in getting a proper diagnosis, even if the doctor is present at a remote distance By facilitating effortless interaction among various modules, IoT has enabled us to implement various complex systems such as smart home appliances, smart traffic control systems, etc.

PROPOSED SYSTEM:

The main objective of this Healthcare Monitoring and Management System is to develop, design, and implement a smart patient healthcare monitoring system. The sensors used here are embedded in the body of the patient to sense the parameters like the heartbeat and temperature. These sensors are connected to a master unit, which calculates all of their values. These values are then transmitted by leveraging IoT cloud technology, to the base. From the base station, these can be easily accessed by the doctor present at some other location. Thus based on the temperature and heartbeat values, the doctor can decide the state of the patient and appropriate measures can be taken.

OBJECTIVE:

Monitor patient parameters remotely to increase the efficacy of healthcare management systems

IDEATION:

We need to monitor the patient parameters from remote distances using various sensors. The data given out by the sensors are then sent over to the cloud for further access via a Wi-Fi module (inbuilt or externally connected). This is being done to reduce the critical time of testing patient parameters before any major operation.

Here we are measuring the temperature and pulse parameters of a patient remotely.

Components required:-

MLX 90614 Temperature
MAX 30102 Pulse Rate
Jumper wires.
Nodemcu ESP8266 board

The Gantt Chart is shown below:-

smart patient healthcare monitoring system

Summary:-

 Health care is given extreme importance nowadays by each country with the advent of the novel coronavirus. Thus in this regard, an IoT-controlled healthcare monitoring system is most probably the best solution for such an epidemic. Internet of Things (IoT) is the new revolution of the internet which is a growing research field, especially in health-related services.

“Healthcare Monitoring and Management System” is the project where we have mainly focused on two objectives first one was a smart health monitoring system, to collect the health history of patients with a unique ID and store it in a database so that doctors need not spend much of their time in search of the report and give analysis right from the dashboard. Any health care that is being done will be updated and reflected in the dashboard itself. And the other one is the Wearable-Sensor-Based Fall Detection System for aged people, to monitor their movements of them, recognize a fall from normal daily activities by using sensors, and automatically send a request or an alert for help to the caregivers so that they can pick up the patient.

However, there are a few shortcomings to this too. Basic knowledge of the operation is to be learned by the caregivers. Also, both the caregiver and the wearer should know how to protect the sensors from water damage or any physical damage. 

  • Planning and project management 

S.No.

Activity

Starting Week

Number of Weeks

1.

Literature Review

1st week of January

 2

2.

 Project Finalization

3rd week of January

 1

3.

Required software setup

4th week of January

 1

4.

Gathering of Hardware & Formation of codes

1st week of February

1

5.

Hardware assembly calibration

2nd week of February

 1

6.

Code Integration & Debugging

3rd week of February

 2

7.

Inclusion of IoT and Blynk

1st week of March

 1

8.

Finalization & modification of Website and mobile application

1st week of March

 1

9.

 Preparation of project report

2nd-3rd week of March

 2

10.

Preparation of Project presentation

4th week of March

1
Posted on

College Search Engine Project using File Management in C++

Introduction

This is a simple file management-based search engine using C++ and some Graphics that gives you the details about your University like University Info, Faculty information, Student Fee payment information, etc.

It gives you details such as the admission process, hostels, courses offered, and different activities conducted by the university.

FUNCTIONS:

  • Basically, the function is used to set the cursor position on consol using x and y coordinates.
  • The function is used to flush the stream.it can flush all the buffer from the stream.
    Basically, it is used to clear a consol.
  • The function is used to delay the output on the console by providing according to values.
  • The function is used to provide a sound effect on the console according to provided arguments.

Search Engine File Management

Motivation

We got this motivation as we wanted to explore how a search engine can be managed without database management.

We explored different ways of creating a search engine and then we decided to make it using file management.

Applications

  • Researching information on University
  • Admission regarding queries
  • Precise information from the source

Challenges

  • Stemming algorithm
  • Colorful backgrounds and Graphics
  • Screen resolution (Formatting gets unsettled)
  • Linking of HTML with C++

Conclusion

  • As we have finished this College Search Engine project, we have got a better understanding of the inner workings of a search engine using files.
  • We have known more about the use of graphics in C++.
  • Debugging and file management knowledge have increased along with concepts such as inheritance, constructor, and destructor.
Posted on

Development of Career Builder HTML & CSS Minor Project

  1. Introduction

There has been a demand for a career builder product, an application that can solve the problem of mock tests, and sample papers for different government and non-government projects.
The current trend of research on ed-Tech startups shows us that there is no specific application that solves this problem Several variants of this application are not focused on this. The current career builder web application project is to study and develop how this exam web and mobile application works so that we can build them in the forthcoming future.

  1. Motivation

Our country has too many government exams and the craze for it is too much but in the ed-tech market in this digital age, there is no stable application by which the aspirants can practice for the exams. In the modern era of 2021, the aspirants have to go to the local market and ask for the books for the preparation and mock exam of that particular government exam. Therefore we felt like there is a need for such a career builder application in the market. This is a pain point for many that we can see around us.

  1. Related work

Before starting this career builder project our team made many different google forms to know the need for this project and if something like this is required in the market or not.
Other than that we had previously observed people go to the local bookstore and ask for sample paper books and wait until it’s available also finding the papers is also tough since too many sites take extra permission and show nonrelevant ads.

  1. Objectives of the work

The objective of this career builder project is to make a well-focused web application (maybe a demo for this time and an upgraded version in the future and a mobile application too) so that the aspirants can find all the sample papers and mock exam papers in one place without suffering through the whole internet and make a business model in the future out of it.

  1. Technical Details

This career builder project is mainly developed using HTML, CSS, JavaScript, and JSON.
We are gonna develop an API to fetch data ( Questions and choices ) from the JSON file and are going to use external APIs for external data too. Some CSS frameworks will also be used for the beauty of the front end. The score of the user’s performance will be calculated and stored using local storage.

career builder Minor project ER Diagram

6. Hardware and Software Requirement Specifications

Write hardware and software requirement specifications.
The hardware required for the project is our team members’ laptops for programming and a WiFi router for remote work since we all are in different cities. Many software are used for communication and development as follows –

  1. Zoom – for planning and discussing the project and connecting virtually through video calls our team used the Zoom application which is also used in the tech industry for the same.
  1. Slack – for communication in the form of texts and images and also for data sharing except for the code we used slack and we could use other applications too but we choose it during a discussion because it is also used in the industry.
  1. Visual Studio Code – for the real work to be done in the programming we used the IDE called visual studio code. The two main reasons to choose this IDE only over the others are

a. We used it before in our college, therefore, we are comfortable with it.
b. It is widely used in the industry.

This software gave us support through its vast extensions some of which are

Live Server (main feature hot reload)
Prettier (format the code in ES6 the industry standard )

  1. Git Bash – for the use of the terminal for the Linux commands since 1 of our teammates uses Linux Operating System (Ubuntu) and it is beneficial to use these commands over windows commands (commands of Windows Power shell, etc ) since again because of industry standards – most of the startups in India provide mac book to their developers, the terminal of which also works on Linux commands and other companies also suggest to use Linux over windows at least for Command Line Interface.
  2. Git Hub – To deploy and share our code, it has many features like making branches and working separately together. To take the snapshot of that particular instant of the code for the future and other features like a staging area, commit, clone, and a remote code sharing system.

  1. Future Scope

The MVP version of the career builder minor project and its corresponding later versions can be used by the aspirants so that instead of finding papers on the whole web they can simply use a single website and study and practice without distractions.

  1. Conclusion

This career builder minor project is made with the idea of having a web application where the aspirants can practice with the sample papers of their particular exam.

Posted on

Design & Implementation of Staff Leave Management System Project

This system is aimed at implementing a leave management application for staff that is of importance to any Educational Institute. The leave management system is a web-based application that can access by all the staff of the college. Their features like updating staff records, approval of leave cancellations of leaves, track the staff leave record.

MOTIVATION

The motivation for designing this application come because I came to know that the staff in my college have to fill out the leave application form and then submit it to the office .then the clerk checks their records and proceeds further. So it is a time-consuming process. So to save their time and minimize their application form process, I decided to design the online leave application form. Moreover, I value recent learning about the java programming language as well as seeing how powerful and dynamic they are when it comes to web designing and applications. Whereas, PL/SQL database at the back-end because I found them to be extremely useful while on the technologies.

This system is specifically made for the following issues:

  1. It reduces manual work.
  2. This system is fully computerized.
  3. Highly efficient and accurate.
  4. Easy access to college staff records.
  5. Offers real-time visibility of data.                       

Security Risk: – 

The system-generated mail notification sent to the leave applicant is late.

PROPOSE/OBJECTIVE AND GOALS

PROPOSE

The proposed system is developed to manage staff leave and their records in the colleges. It helps to record staff information, Approve or denies staff leave request.

Objectives:-

  1. The purpose of the project is to build an application program to reduce the manual work for managing staff leave.
  2. To generate inquiry for staff on demand.
  3. To keep all the information related to pending leave.
  4. Well-designed database to store faculty information.
  5. The main objective of this application is to automate as well as update the leave information of staff.
  6. It tracks all the details about faculty, and attendance.
  7. If the any of the faculty wants to know about his/her leave status it will be very

Project Scopes and Limitations

  1. To manage the details of staff attendance, and records of their leaves.
  2. Easy to operate and hopefully can smoothen up the job of clerks and staff.
  3. This system produces a computerized system for defining the best solution for the leave application.
  4. Easy access to staff records.

Existing System

This system is offline it requires a lot of effort. for applying for a leaving staff in the colleges go to the office and collect the leave application form and by filling up the details, type of leave, leave applied for how many days, the reason for leave, load arrangement, etc. leave application form they have to submit it to the clerk. The clerk checks their pending leaves and then approve the leave application form or deny them for the further process. There is no security for data.

Project Perspective

The online leave management system application is a web-based system. A leave management system is a process within in college that determines how leave is requested by staff and approved by higher authorities.

System model:

 The structure of the system can be divided into the following parts.

  1. Admin module: Admin/clerk will maintain all the faculty details, employee leave record details, and HOD leave record details in the database. 
  1. Faculty module: in this module faculty will get access to check their leave status. 
  1. HOD module: In this module Head of the department will have permission to look after the data of every faculty member in the department. 
  1. Principal module: Among all the modules principal module is given more permission. He can view information of every department’s faculty information and take action based on reports. 

Admin module:

  1. Home page
  2. Leave applicants page
  3. Deny/approve page
  4. Update module
  5. Login page 

Faculty module:

  1. Leave status
  2. Pending leaves
  3. Leave type
  4. Leave days
  5. Leave reason 

HOD module:

  1. Faculty data
  2. View data
  3. Approve/deny leave
  4. signature 

Principal module:

  1. Access to All faculty data
  2. Approval of leave
  3. View records

STAKEHOLDERS

Key stakeholders of an online staff leave management system are:

  1. Clerk
  2. Staff
  3. HOD
  4. Principal
Posted on

Real-Time Map-Based Pollution Monitoring and Data Management System

Title : Real-Time Map-Based Pollution Monitoring And Data Management System

Introduction: For years, pollution has been a major issue faced by mankind and it is increasing by the day. The recent pollution disasters that happened in major cities across the globe have taught us one thing and that is, that it is important to keep an eye on the pollution that is increasing day by day. Many government and global organizations have started to work on it and almost a decade has passed since these programs have been functioning. But, the major issue with these organizations is that they are focused on beating pollution on every front whether it is air pollution or water pollution.

These organizations are more focused on amending laws for pollution control and the monitoring process boils down to analyzing air quality and then making changes in the environmental laws. Also, the issue is that these bodies are controlled by the central or federal government. But, pollution is no longer an issue that can be tackled gradually and conventionally. It needs immediate attention and effective monitoring is required so that the authorities can take necessary measures to solve the pollution problems.

The pollution problem is more persistent in urban metropolitans and metros. But, municipal corporations have very little control over the situation because of a lack of data to act upon. Recent developments in the smart city sector are also encouraging cities to develop monitoring systems. The city of Ahmedabad, Gujarat has implemented digital signboards that show the real-time value of major air pollutants and overall air quality. This data is displayed to the people driving on the road so that they can take necessary precautions to avoid or minimize the health risks due to pollution. But, this kind of Pollution Monitoring project requires a huge amount of funds and is also not feasible everywhere.

So we are building a minimalistic model to tackle the issue of monitoring pollution. Our main goal is to provide real-time data visualization and also provide a database that will store all the data and provide readings of various pollutants. The data will be visualized through the means of a map hence it would be easy to pinpoint the exact location when any kind of action is needed. We will also build a device to capture data and then feed it into a web application that can be used to monitor and visualize the data.

The main aim of this Real-Time Map-Based Pollution Monitoring project is to provide a centralized repository of sensor data and also to create an effective and centralized monitoring system. The low cost and feasibility of the project make it easy to use for both smart cities as well as small towns. Furthermore, this kind of monitoring system will allow for the development of effective countermeasures and control strategies for keeping the pollution problem in check.

Process Flow:

Pollution Monitoring System Process Flow

Methodology

Methodology

This Real-Time Map-Based Pollution Monitoring project is aimed at local authorities like the municipal corporation rather than the central government so that immediate action can be taken by them to control the pollution problem.

This Pollution Monitoring project can be briefly divided into three main parts:-

  • Data Collection.
  • Data Monitoring.
  • Data Storage.

1. Data Collection:

Data collection is an important part of this Pollution Monitoring System project. Any kind of monitoring system is functional only because of the data that has been provided to it.

Data collection will be consisting of reading data from sensors. Now, from the research conducted, we have been able to deduce the major kind of data that we need. Looking at the urban pollutants we have observed that the most prominent pollutant is the Particulate Matter (PM) and Suspended Particulate Matter (SPM).

Hence we have decided to use a DSM501A Particulate Matter and Suspended Particulate Matter Sensor for detecting PM(2.5) or Particulate Matter, which is one of the major pollutants. Also, it leads to various lung and carcinogenic diseases and skin problems.

Particulate Matter concentrations have raised dramatically in the past decades to increase the number of automobiles on urban roads. Hence we have decided that monitoring PM/SPM (Particulate Matter and Suspended Particulate Matter) is going to be one of the main agendas of our monitoring system.

Another major pollutant that has been identified is Carbon Monoxide (CO). Now, CO is not just a single pollutant but, it is also responsible for creating another harmful pollutant i.e Ozone (O3). Ozone is important for blocking UVs from the sun but, at the ground level, the Ozone is a dangerous gas. Carbon Monoxide is specifically dangerous as it affects the hemoglobin if the concentrations exceed 35 ppm (parts-per-million).

From the research we have done, it has been clear that CO is present in spatial quantities but, that means that we need to effectively monitor it to keep its concentrations at safe levels. We will be using an MQ-7 sensor for measuring Carbon Monoxide.

Studies have pointed out that SO2 and NO2 are also major air pollutants and contribute to the degradation of overall air quality. Also, several hydro-carbon compounds are pollutants although not major, affecting the air quality a lot. Hence we have decided to use an MQ-135 sensor to monitor SO2 and NO2 levels as well as the overall air quality.

The sensors will be interfaced on a Raspberry Pi and their data will record using the GPIO library (Python). The data from these sensors will then be directed to the web server and the storage.

2. Data Monitoring:

Data Monitoring is the key component of the system. To monitor the data we have decided to use Google Maps so that the position of our Raspberry Pi Module can be pinpointed and then by using color-coding we can determine the levels of pollution in the vicinity of our Raspberry Pi Module.

All of this will be achieved by creating a web server in Python using the Flask framework and the main desktop app will be a web application written in HTML, CSS, Bootstrap, and JavaScript. The desktop app will have three options

  1. Map-Based Monitoring
  2. Individual Pollutant Monitoring
  3. Statistics

3. Data Storage:

Data Storage is necessary to reference past data and develop statistics from them. The data will be stored locally on the file system and can be downloaded in the form of excel sheets.

Timeline 

Serial Number

Tasks

Duration

1.

Synopsis and Presentation Submission

15 days

2.

Component Purchasing and Testing

15 Days

3.

Interfacing sensors and writing server script

15 days

4.

Writing Front-End Application

15 days

5.

Integrating Front-End and Back-End services

15 days

Components

  • Raspberry Pi model B
  • SD card and adapter
  • MQ-7 sensor
  • MQ-135
  • DSM501A