AI-Powered News Articles Search Web Application using IBM Cloud and Slack Bot

Purpose

The purpose of this News Articles Search project is to develop a web application that fulfills our need to find the obvious and recent news articles and update them regularly. After the discovery service is integrated with Slack Workspace, it gives a bot as an intermediate to search news with a keyword. In addition, the web application also analysis the sentimental present in the news article and extracts keywords and concepts to make it an attractive and understandable format for the user to understand what is important and what is not.

Literature Survey

Existing Problem

News Article applications that are currently used are confusing the users, with multiple functions and an overflow of design, these applications still do not fulfill the demand of the news users and often get results from the past days, weeks, and months, which confuses the users only. Also, there is no way in these apps to know what the approximate feeling of the audience is regarding the article or news topic, which makes it less interactive and very low number of users.

Proposed Solution

Discovery service available in the IBM cloud, creating a web app to get the latest and obvious news results fast and user friendly. When integrated with Red Node Flow, the IBM Discovery Service can create a simple, engaging, organized user interface that provides users with relevant news articles as Discovery Service continuously crawls the web for the latest news to provide. By adding emotional analysis, we make the user interface more interactive, easier to understand, and attain more users.

Project Tasks

1. Creating and deploying the Watson discovery news app locally.
2. Integrating Slack-bot with Watson Discovery.
3. Creating node-red user Interface.
4. Integrating node-red UI with Watson Discovery.

Flow Chart:

Flow Chart

Experimental Investigation

First, we use the discovery service to configure and query adding our collection. A red node application is created in which the discovery is integrated and a simple flow of 5 nodes is created to enter the news topic and the results show related news. Slack then integrates with Watson’s discovery service so that news articles can be searched on more than one platform, and finally, sentiment analysis is performed on the data/news articles being searched.

Advantages and Disadvantages

1. The News Articles Search web application provides interactive sentiment analysis.
2. It can be accessed through more than one platform which is slack.
3. It collects and delivers the most recent data.
4. It does not have additional features like storing news history.
5. It does not provide a stand-alone app but rather uses a web application.

Applications

1. This News Articles Search web application can be used by any user in need of accurate and fast results.
2. Can be used by firms and organizations.
3. Can be used in the stock market to make predictions.

Bot on slack

Bot on slack

Conclusion

This News Articles Search project gives some basic working knowledge of the Watson Discovery Service and showed you how to use Discovery along with JavaScript and Node.js to build your own news mining web application. It also gives insight into real-world applications of AI and helps us understand Slack better.

Future Scope

1. The IBM Cloud and Slack Bot web application can be integrated with the cloud and made into a mobile app to use on it on-the-go.
2. Additional sentiments can be added to the UI.
3. Related and trending news topics can be shown to the user.

 

Development of E-Commerce Store Portal using Bootstrap and ReactJS

The main aim of this project is to design, develop, and implement of E-Commerce Store Portal website based on HTML, CSS, Bootstrap, JavaScript, and ReactJS. To give a high openness of administration we will structure the online site that supports local businesses, with the goal that potential clients need not go to a physical shop to purchase items or administrations. The objective of this E-Commerce Store Portal project is to create an e-commerce web portal with a content management system that would allow product information to be updated securely using a system. The E-Commerce Store web portal will have an online interface in the form of an e-commerce website that will allow users to buy goods from the merchants. This web portal will allow local organizations and start-ups to start their businesses and reach out to the market.

INTRODUCTION

This Bootstrap and ReactJS web portal project is aimed at developing an online static website for an E-commerce store that can be used by people to list their business on the website and will also provide customers to buy the products directly from the store. The website is based on HTML, CSS, Bootstrap, JavaScript, and React. Customers can buy the products directly from the store. This will help local businesses to register their products on the website. It will eventually help local businesses to increase their profits and people to buy the goods from the comfort of their homes. Users can see the products from the website. Our website will contain a Homepage where all the basic information about the store and details of the products will be available. This site is easy to operate and user-friendly.

OBJECTIVE OF THE PROJECT

The web portal will have an online interface in the form of an E-commerce website that will allow users to buy goods from the merchants. This web portal will allow local organizations and start-ups to start their businesses and reach out to the market

MOTIVATION

Online shopping practices are increasing rapidly, thanks to digitalization. Online E-commerce store owners are always eager to know how to increase traffic on their E-commerce sites and how to increase their profits to earn more revenue.  Hence by this, bringing together the various local businesses to a single platform so that anyone can access them anywhere according to their need. So, with the increasing importance of online sales and the growing number of customers visiting online stores we are going to develop a website that helps to save the time of the users. This website encourages local businesses to create their online store and supports them to run their business to grow.

E-Commerce Store Portal

Benefits of the proposed work

• Saves time for customers in quickly view various items on the E-Commerce portal.
• The ability to view and purchase items anytime, from anywhere with Internet access.
• Provides information about resort facilities.
• User-friendly interface.
• No Convenience fees.
• Total features of E-Commerce Website are accessible.
• Easy to use and simple to understand.
• Quick and save lots of time.

Modules and their functionalities:

1. Dashboard: This is the home page of our website.
2. Hawkers: This consist of all the hawkers available online for selling their products.
3. Feedback: The feedback area consists of all the feedback given by buyers.
4. Vendors: This contains information about the vendors and their products.
5. Place Order: This is used for placing an order of the product of your choice.
6. About Us: This page consists information of about the team behind the idea of promoting local businesses.

Implementation and User Interface

This E-Commerce Store Portal project is implemented with the help of Visual Code.

The user interface design was one of the core tasks in this project. The aim of UI design is to make the E-commerce application to be accepted and used easily.

Software Requirements:

  • Macintosh /Microsoft Windows /Linux
  • Virtual Studio Code or any other text editor
  • Chrome or any other browser

Resorts Management System Full Stack & Bootstrap Project

ABSTRACT

Resorts Management System Full Stack Website which is based on the user interface that is front end project which can be used by the customers to access the different types of rooms according to their needs and other facilities of the resort which include a banquet hall, restaurant service, rooftop pool service, etc. On our Resorts Management System website, we have included all the relevant details that user wants to access while searching for a resort, it has all valuable data or information.

Also if the user has any query regarding any service they can send us the message for the website. In our project, the Resort website that we have made is fully responsive which helps users to access it on any device or at anytime, anywhere. This application will help to improve services for tourists and also improve the revenue source for our resort.

OBJECTIVE

In the present time, there is a great rush in Resorts, as these have become a necessity for everyone in the society. People travel a lot, stay in hotels and resorts, goes to the hotels for functions, meetings, and refreshments. Our Resorts Management System project is developed keeping in mind the general needs of the customers when he goes to the resort. We cannot deny that we are now in much more technological improvement and especially for business, shifting from a manual process to online.

It focuses on giving the customer all the information about the park and its activities. If a customer wants to come to the park, he can see the facilities available and know the park rates’ impact online. This will also save time for our customers as well as the administration with online booking instead of on-site booking. This Resorts Management System is very secure due to the availability of login and password options. Creating profits and achieving customer satisfaction is the main goal of our system.

Providing customer satisfaction is the main objective of our project. And we have also been taking care of the expectations of the users when they search for some resort for their holiday or any other event. It focuses on giving the customer all the information about the resort, and photos of the resort, and also help them to see the various room in the resort and book them in advance, various other pages are the About Us page, Facilities Page, Faqs page and Contact Us page, Blog Page. If any customer is willing to come to the resort, he/she can see the facilities available and can know the cost-effectiveness of the resort online.

This will also save time for our customers as well as management by booking online instead of booking on the spot. The resort system Full Stack & Bootstrap project’s main idea is to develop an online web-based application that is accessible to all and to create a scope for visiting tourists from different geographic locations. 

DETAILS OF SOFTWARE USED

Technology Used:

  • HTML: The page layout will be designed in HTML
  • CSS: It is used for designing
  • JAVASCRIPT: To Program the behavior of web pages
  • Bootstrap: HTML, CSS, and JavaScript framework for creating responsive, mobile-friendly websites.

Resort Website

Software:

  • Microsoft Windows 7/8/10 or Linux
  • Vs Code or any other text editor
  • Chrome or any other browser

TEAM CONTRIBUTION

Teamwork plays a vital role to make any project successful. It needs the participation of every single member. Our team comprises four members and work will be equally divided among each member so that every member of the group can contribute and can give their best efforts on the Resorts Management System project.

LIMITATIONS OF THE SYSTEM PROPOSED

Besides the above achievements, we still feel the project has some limitations, listed below:

  • Limited information provided by this system
  • Since it is an online Resort project, customers need an internet connection
  • People who are not familiar with computers or using online websites can’t use this software
  • Heavy traffic leads to failure or long wait issues

CONCLUSION

Online has got a clear advantage over the manual system. The Online Resort system is more reliable, efficient, and fast at the end of the project. I can say that online websites play a very crucial role in the development of the firm.

  • Thus we have proposed a Resort Fullstack Website.
  • It eliminates the 3rd party website completely ( MakeMyTrip, Goibibo, Trivago )
  • This software aims at reducing paperwork & provide multiple facilities to users with fewer efforts and Access to the Portal according to choice & availability.

We have prepared a full-fledged working website on named Resorts Management System. It is a website based on the Resort Management system and displays various facilities and services offered by the resort. We have displayed various features of our resort-like hotels, rooftop, spa, swimming pools, banquet halls, etc. The central objective of our Full Stack & Bootstrap Project website is to provide an online facility for accessing all the services of our resort.

We have created a platform where customers can directly communicate with us and can overcome the problems of manual system and third-party platform issues. This Full Stack & Bootstrap Project aims at reducing paperwork and provides multiple facilities to users with less effort. Users can access the portal according to choice and availability.

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.

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.

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.

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

 

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

Design & Development of Educational Institutions Grievances Portal Project

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

Introduction: 

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

The following is the overview:

Purpose:

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

System Overview:

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

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

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

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

Model of Solution:

Goals:

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

Objective / Future scope:

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

Functional and non-functional requirements:

Grievances Portal Project website there three types of users:

● Citizens
● Institute
● Admin

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

Functional Requirements:

User Functions

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

Institute Functions

1. Institutes will have a login

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

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

System Functions

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

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

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

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

Administrator Function

Reports to be generated

The technology stack used:

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

Implementation strategy:

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

Conclusion:

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