QR Code based Customer Billing System for Supermarket Shopping Project

ABSTRACT

The objective of this project is to propose a real-time capturing system that helps consumer billing for hypermart shopping using Quick Response (QR) code in Android smartphones.

EXISTING SYSTEM

Nowadays in most hypermart shops, customers have to take a long queue for billing after shopping and it’s a time-consuming process. Also, users will not be aware of the total bill amount at the time of purchase. Increase time spent at the billing counter and reduces customer satisfaction.

PROPOSED SYSTEM

When a customer entered a shopping mall or a hypermart for shopping, his smartphone will be connected to the hypermart’s server. After the successful connection with the server, he can start purchasing. At the time of shopping, the QR code should be read for bill generation. QR code pattern can be read by android smartphones at the time of adding an item to the cart. The QR code will identify the price of the product and it will automatically calculate the total price according to the quantity of the product in the cart. So QR code verifies products by capturing them through a smartphone, then decodes them and sends them to the server for authentication. When the user finishes his shopping, the total amount will be displayed on his phone as well as the cashier’s monitor. You can also visit & download the PHP, My SQL Application project on Supermarket Inventory Management System.

 This will avoid huge queues and waste of time for billing after shopping. The customer can plan his shopping whether to continue or not by viewing the purchase bills so that he can manage the bill and shopping effectively.

The project consists of two main modules.

Admin module

Admin will add the products with their price, manufacturing details, and quantity information. He can view the billing and purchase details of customers and generate daily, weekly, and monthly billing reports. Admin can add the products with their price, manufacturing details, and stock information without any duplication. Based on the arrival of new stock and purchasing the product from the stock, the stock quantity will be updated. He then generates a QR code for each product. He can view the billing and purchase details of customers. Accordingly, he can generate daily, weekly, and monthly billing reports.

User module

User can plan their shopping using this app. The user can register with the app. When he enters a hypermart, he can scan the QR code of the product and can view the corresponding product details. Then submit the quantity to be taken. He can finally submit his items in the cart to generate the bill and also have the facility to cancel items from the cart. 

This Supermarket Management and Billing System are related to the Customer Billing System for Supermarket Shopping Project. You can also visit & download the Java Application project on Supermarket Management and Billing System

SOFTWARE  REQUIREMENTS

  • Operating system:   Microsoft Windows XP/above, Android
  • Platform:   Net Beans, Eclipse
  • Front End:   JSP, Android
  • Back End:   MySQL

TABLES        

Table 1: Login

Primary key: username

Purpose: To store login details

Column

Type

Description

Username

varchar(50)

 Primary Key, Email id

Password

varchar(50)

 Password, unique password

User type

varchar(50)

 user type

Status

varchar(50)

 Status

Table 2: Customer

Primary key: customer_id

Foreign key: emailid

Purpose: To store customer details

Column

Type

Description

customer_id

int(50)

 Primary Key, customer id

customer_name

varchar(50)

Name of customer

emailid

varchar(50)

 Foreign Key , Email id

Phone_number

bigint(50)

 Phone Number of Customer

address

Text

 Address of Customer

appcode

varchar(50)

 App code

 

Table 3: Category

Primary key: category_id

Purpose: To store category details

Column

Type

Description

category_id

int(50)

 Primary Key, Category id

Categoryname

varchar(50)

 Category Name

 Table 4: stock

Primary key: stock_id

Foreign key: product_id

Purpose: To store stock details

Column

Type

Description

stock_id

int(50)

 Primary Key, Stock id

product_id

int(50)

 Foreign Key, Product id

Stockqty

bigint(50)

Quantity of Stock

Stockdate

date

Stock Added Date

Status

varchar(50)

Status

Table 5: product

Primary key: product_id

Foreign key: category_id

Purpose: To store product details 

Column

Type

Description

product_id

int(50)

 Primary Key, Product id

productname

varchar(50)

Product Name

category_id

int(50)

Foreign key, Category id

Quantity

bigint(50)

Quantity of product

manufacturingdate

date

Manufacturing Date

Expirydate

date

Expiry Date

Price

double

Price of Product

manufacturer

varchar(50)

Manufacturing company

Description

text

About the product

Madein

varchar(50)

Country name

Image

varchar(50)

Image of product

Qrcode

varchar(50)

Quick Response code

Status

varchar(50)

Status

Table 6: cart

Primary key: Cartid

Foreign key: Email

Purpose: To store cart details

Column

Type

Description

Cartid

int(11)

 Primary Key, Cart id

Email

varchar(50)

 Foreign Key, Email

Cdate

date

 

Flag

int(11)

 

Table 7: cart_item

Primary key: cart_item_id

Foreign key: Cartid , product_id

Purpose: To store cart item details

Column

Type

Description

cart_item_id

int(8)

 Primary Key, Cart item id

Cartid

int(8)

 Foreign Key, Cart id

product_id

int(8)

 Foreign Key, Product id

no_of_quantity

int(8)

 Quantity of product

 Table 8: purchase

Primary key: purchase_id

Foreign key: bill_no, Emailed, product_id

Purpose: To store  purchase details

Column

Type

Description

purchase_id

int(8)

 Primary Key, Purchase id

bill_no

int(8)

 Foreign Key, Bill No

Emailed

varchar(50)

 Foreign Key, Emailed

product_id

int(8)

 Foreign Key, Product id

purchase_date

date

 Product Purchased Date

Quantity

bigint(15)

 Quantity of product

Table 9: bill

Primary key: bill_no

Foreign key: Emailed

Purpose: To store bill details

Column

Type

Description

bill_no

int(50)

 Primary Key, Bill No

Emailed

varchar(50)

  Foreign Key, Emailed

Amount

int(50)

 Total Amount

bill_generate_date

date

Date of bill generated

Status

varchar(50)

 Status

Table 10: feedback

Primary key: feedback_id

Purpose: To store feedback details

Column

Type

Description

feedback_id

int(8)

 Primary key, Feedback id

from_id

varchar(50)

 Sender’s id

Message

varchar(50)

 Message

send_date

date

 Feedback send date

Download the complete Android app project on QR Code based Customer Billing System for Supermarket Shopping Project.

Also, Read this Sales Management System for Hypermarkets PHP & MySQL Web Application Project.

Android Application for learning Internal Examination Objective-Type Questions

According to the JNTU curriculum, students are capable of scoring 25% of the overall marks based on their performance in the internal i.e. Mid-Term examinations. In the internal examinations, each subject carries 25 marks, out of which 10 marks are allotted for subjective-type questions, 5 marks are allotted for assignments and the rest of the 10 marks are allotted for objective-type questions.

Students face many difficulties, especially while preparing for the objective type questions as the existing system i.e. previous year’s objective type question papers and their keys available in pdf format on JNTU-related websites & blogs, class notes, textbooks, etc. do not provide an effective way of learning. In the existing system, the student has to visit multiple websites to view and download previous question papers and most of the question papers are in pdf format where questions are listed on one page and answers are listed on another page which makes it the student difficult to read and learn, he will have to switch to two different pages in order to read one objective type question.

The student has to repeat this to learn all the questions which are time-consuming and inefficient to learn. In order to overcome these problems, we need to develop a system that can be accessed by the students(users) easily. We strongly believe that building an application on Android can solve the problems faced by the existing system.

PROBLEM STATEMENT:

Every semester, JNTU conducts two mid-term examinations consisting of 10 marks worth of multiple-choice questions and fill-in-the-blanks. In order to secure good marks in the internal examinations, students must be prepared with 4 units of each subject. They can prepare from multiple sources including notes, textbooks, references, and previous question papers. It is difficult and time-consuming to find and download all question papers as they are located at various sites.

We have to download these question papers and the question papers are in pdf files and their respective keys are in other pdf files. Hence it is often time-consuming and difficult for the students to prepare effectively for the bit paper of mid-examination.

MOTIVATION:

The marks secured in internal examinations play a vital role in improving the overall aggregate of students. Most of the students prepare well for the theory part of the internal exams as it has efficient and direct sources to prepare like notes, guides, textbooks, etc. but sadly, they are lethargic in preparing for the bit paper of internal examination. The reason behind this is that the sources for preparing for bit papers are not clear and are difficult to use. Hence it is important to build a new system using a new approach through which the students can easily prepare for the bit papers. This Internal Examination System should also be in such a way that it should be available and accessible to the majority of students. Therefore all the above factors led to the development of an android application for learning JNTU bits. This provides its users with a user-friendly interface and an effective way of learning the JNTU bits.

SCOPE:

This Internal Examination System software will be an Android application for Learning JNTU bits. This system will be designed to maximize the scope for the users to score higher grades in Mid-term examinations. This is done by preparing the user for Multiple Choice Questions (MCQ) and Fill-in-the-blank questions worth 10 Marks. This system provides a user-friendly environment for users. It can be accessed on the go at any time by the users. It provides a user interface in a hierarchical manner, hence it doesn’t lead to any confusion. This system also contains a relational database (using SQLite) containing a list of questions (BITS) and their corresponding answers for different branches and regulations.

OUTLINE:

This Internal Examination System application serves as an effective solution for students facing difficulties in preparing for the bit paper of an internal examination. There is no need for internet connectivity in order to use this application. This application provides an efficient user interface and is easy to operate. This application supports the features of android as it is built on Android. This application operates in either of the two modes (revision mode/learning mode) based on the requirement of the user. Therefore this application is user-friendly and also provides high performance.

EXISTING SYSTEM:

According to JNTU, every semester will have two mid-term examinations (except for the first year, as it only has three mid-exam for the academic year) consisting of 10 marks worth of multiple-choice questions and fill-in-the-blanks. Students must prepare for 4 units for each Mid-Term exam. As per the existing system, students prepare themselves for objective-type questions from multiple sources including textbooks, references, and previous question papers. Previous question papers are the most important source of questions as there is a high likelihood that a few or more questions will be repeated in the exam.

These papers are accessed via webpages (and/or) other sources in the form of PDFs/word documents. This generation of students is used to a fast-paced lifestyle. As the existing system is time-consuming and it deals with patience, most of the students ignore the preparation for objective-type questions. They might rather try their luck with objective-type questions during the internal exams. Hence this affects the student’s overall performance in internal exams.

DISADVANTAGES:

  • It is difficult and time-consuming to find and download all question papers as they are located at various
  • One cannot effectively form the question papers as questions and answers are located on different pages which leads to we can overcome the flaws of the existing system by making use of the proposed system that is mentioned below.

PROPOSED SYSTEM:

The marks obtained in internal examinations play an important role in improving the percentage of students. The system will be an Android application for learning JNTU bits. It will be a handy application for the users. The user shall be able to use this system whenever and wherever he/she wants. The user shall be able to prepare for different subjects’ objective-type questions from one single source i.e. with the help of the proposed system (Android application).

This Internal Examination System will be built with the intention to be highly beneficial for the users (especially for the students). We will build this system in such a manner that it would support most versions of the Android operating system. Therefore this system is intended to provide an optimized way of learning the objective type questions to the users.

ADVANTAGES:

  • Easy to access JNTU bits which are updated
  • Scoring-system for students to learn
  • Saves time by allowing users to switch to multiple subjects within seconds

Overall Description

Product Perspective:

To provide users with an optimized way of learning JNTU bits. This is done by providing the bits (Multiple Choice Questions and Fill in the Blanks) of various subjects in the application, which can be accessed easily by the users. The efficiency of learning is increased as this application can be operated in either of the two modes (learning mode and revision mode).

Product Functions:

The Internal Examination System is intended to perform the following functions:

  • It provides branch-wise objective-type questions for the user.
  • It also provides objective-type questions based on the
  • It allows the user to easily navigate through various subject’s objective-type question papers based on his/her
  • It acts as a platform for the users to learn the objective-type questions effectively using different modes:
  • Learning mode
  • Revision mode.
  • Learning mode: In this mode, the system provides a list of questions and when the user selects a particular question then the system displays that question along with options where the user is facilitated to select an option according to his choice and submit it then the system shows whether the user answered it correctly or not in this way it provides an active, comfortable and effective mechanism towards
  • Revision mode: In this mode, the users are provided with a list of questions along with answers to revise so that it does not waste time during
  • The system consists of a scoring system, which allows the user to self-assess.

User Documentation

The Internal Examination System will consist of in-built documentation which can be accessed via the help menu. The documentation will contain information about various functions of the system and how to utilize those functions in an effective manner.

External Interface Requirements

User Interfaces:

  •  This system display’s a welcome screen as an introduction for the first time for users.
  • After that, the system navigates to a new screen where the users shall be able to set their batch details.
  • Then the user shall be able to select the subject and the mid-term.
  • Now the user shall be able to attempt a question.
  • Then the user shall be able to view the correct answer.
  • The system displays the current mode (Learning, Revision) in the title bar.
  • The system provides a single space for choosing both modes and changing settings.
  • The user shall be able to view help and information.
  • The system provides the users with a single screen where all the questions are displayed and whether it was answered correctly.
  • Tabs to switch quickly both Multiple Choice questions and fill-in-the-blanks.
  • The user shall be able to exit the application.

Software Requirements

Operating System: Android 4.0.3 and above

FUNCTIONAL REQUIREMENTS:

The following are the three main scenarios of the Internal Examination System application:

Learning Mode:

Learning mode offers the user a chance to attempt a question before revealing the correct answer to the user. This gives the user feedback on whether their answer was correct or not.

It is given high priority as it is an essential part of the system without which users cannot become better at scoring good marks in objective-type questions in the internal examinations.

  • The user should select the current batch.
  • The user should select the current mid-term.
  • The user must select the appropriate subject.
  • The system should verify that the appropriate year and corresponding semester are selected. The system does not allow users to make erroneous selections.
  • The system should verify that only subjects in that semester are displayed and selected.
  • The user can select any question from a list of all the questions in that subject.
  • The user can view and answer the questions.
  • The system should be able to provide users with the correct answers in a clear manner. REQ-9: The system should be able to provide the option of loading the next Question.

Revision Mode

In this mode, the user can browse through all the questions provided in the application.

The correct option for the question is displayed to the user.

Revision mode is a high priority and is a fast-paced mode designed to enable the users to quickly revise the answers before the exam.

  • The user should select the current batch.
  • The user should select the current mid-term.
  • The user must select the appropriate subject.
  • The system should verify that the appropriate year and corresponding semester are selected. The system does not allow users to make erroneous selections.
  • The system should verify that only subjects in that semester are displayed and selected.
  • The user can select any question from a list of all the questions in that subject.
  • The system displays the question and its correct answer.
  • The system allows the user to load the next question.

Scoring System

The scoring system displays the total number of questions answered correctly and the score for each subject. It allows a user to assess their own progress while learning and allows them to compare their progress in different subjects.

The user can measure their own performance. It is difficult to assess themselves and understand their progress without a scoring system.

  • The system stores the total no. of questions answered by the user in an array.
  • The system should check whether the user answered a question correctly or incorrectly.
  • The system should assign a score based on the number of correctly answered questions.
  • The system displays the score on a total and per-subject basis.
  • The user can reset the score if needed. When the user resets the score the system displays attempted questions and their score as zero. The user can retake learning mode to start attempting the questions from the beginning.

NON-FUNCTIONAL REQUIREMENTS:

Safety Requirements

There are not many safety requirements with this application, other than any normal hazards of a mobile device. One such hazard is users, using this system when they are driving a vehicle. And on the other hand, the users are strictly suggested to use this system only for preparation purposes before the exam but not in the examination hall during the exam.

Security Requirements

A user cannot edit any question or answer stored in the database of the application. Android provides SQLite helper classes which are implemented in such a way that only classes belonging to our system may access the database. Additionally, our system utilizes the built-in security in Android operating systems which provides security to the user’s device through a password, pin, or pattern.

Software Quality Attributes

  1. Correctness: The data of the system e. objective type questions and their respective answers are collected from genuine sources like the JNTU University, websites, faculty, etc. And it is arranged in an error-free manner. Hence the system ensures correctness to its users.
  2. Flexibility: The system layout is in such a way that it can be accessed via both mobile and
  3. Usability: This system can be used on the go by the users. It provides a high degree of usability.
  4. Reliability: The user can completely rely on this system for effective learning of the objective type

CONCLUSION AND FUTURE SCOPE

This application is developed on Android. It is used to overcome the difficulties faced by the students while preparing for the bit paper of an internal examination. It introduces a modern way of learning JNTU bits to its users. The list of questions and keys present in the application are collected from reliable sources like textbooks, downloaded from the JNTU website, etc… hence the content provided by the application is reliable. The user interface of this application is simple, hence it can be operated with ease. This application allows the students (users) to learn the bits in an effective manner and hence this will help them to improve their overall aggregate.

In the future, we need to extend this application such that it can be used by students of all branches under JNTU i.e. EEE, Civil Engineering, Metallurgical Engineering, etc. so that majority of students can be benefitted. We can also add additional features to this application like marking the most important questions, practice tests with time limits, etc… At present, if we want to update this application, we need to uninstall it and again install the new version of the application. In the future process can be made easier by making it an online application. Efficient security methods should be provided to the application as it becomes online. The application should be able to run on the forthcoming versions of Android.

Download the Complete Android Application for learning Internal Examination Objective-Type Questions Project Code.

Food Recipe Cross-Platform Android and IOS Application Project

Surely there are many Food Recipe Cross-Platform apps that offer a wide variety of options to choose from, but most of them are online only, and those that are offline lack either that multitude of options or are devoid of proper UX and structure.

Modules and Description:

1. Smart search filters:

Users can search or filter recipes by name-based ingredients and diet. When a user searches for an ingredient, all the related recipes to that ingredient will be shown to the user, and a search based on a diet is also displayed. For example, some people are allergic to some ingredients and wish not to include them in their meals. The user will be able to search the recipe based on diet or other requirement factors. The search filter will return the appropriate recipes depending on the type of search.

Search by name, base-ingredients, diets,.

2. Categorized view:

In our application, all recipes are categorized into various cuisine, food types, diets, and varieties. We collected the exclusive authentic recipes of various countries and their cuisines are categorized on the type of food and the specific diet that the user is seeking varieties.

Recipies are categorized into cuisine, food types, diets, vegan, etc,

3. Curated Collections:

We’ve gathered recipes from famous chefs around the world and listed their signature recipes and collected various information and data about these recipes from popular websites and articles.

Curated recipe collections from famous chefs, web articles, etc.

4. Pantry Manager:

Every user can manage their own personal pantry with the help of a pantry manager, which we have included in our application.

5. Meal Planner:

Manage your pantry using our pantry manager and Plan your meals for family dinners, parties, and other social gatherings.

6. Shopping list:

Add recipes to your shopping list and browse the required ingredients with a quick glance.

We have also given a feature where the user can add ingredients to the shopping list. So that the user can track all the missing ingredients and purchase them all at once later when he/she visits for grocery shopping. These shopping list features take out all the work for you, whether you want to share a virtual list with your family and friends, or check out the nutrition facts for whatever you’re buying. It can be used and created by more than just a cell phone, as some apps can integrate with smartwatches.

 7. Skill Guide and Glossary:

Under the skill guide and glossary section, we’ll provide the user with various information on cooking techniques. Like knife skills, etc., and including a ‘Dictionary’ to understand common culinary terminology. This section is basically dedicated to starters who do not have experience and match knowledge in cooking.

Offline wiki on knife skills, cooking techniques, and various other culinary skills including dictionary to better understand common culinary terms

Activity Diagram:

  • View Recipe

The user shall be able to see the recipes in the application. In other words, the user shall be able to access the Recipe Forum, where all the user’s recipes are posted and ordered by the date of creation. Our application allows users to view recipe lists with images and titles. Single recipes can be viewed with images, recipe titles, and details of cooking directions. 

  • Search for a Recipe

 The search functionality will provide the users with a shortcut to find their targeted recipes if posted before by the users.

  • View Ingredients

The user of the app shall be able to view the ingredients of a certain recipe.

  • Add Recipe as Favourite

Once the user accesses the recipe information, he/she shall be able to mark a recipe as a favorite. Our application allows users to save recipes as favorites. When a user performs a search operation, the result is a list of recipes. Each recipe in the list has a favorite button on it. Users can add recipes by clicking on the favorite button.

The user shall be able to access the recipes that he/she marked as favorites.

 Result Screen Shorts

  • Recipes are categorized in the form of cuisines (based on countries and origin).
  • Fast food items are categorized into Burgers, Pizza, Noodles, and Sausages.
  • We have also collected the signature dishes of some of the world-famous chefs under the Chefs Curated category.
  • We have a category named ‘Meals’, were further divided into 6 categories:

– Lunch

– Breakfast

– Dessert

– Dinner

– Salad

– Soups

  • We also have a special Category. Here, the user-specific recipes are collected. For instance collection of vegan recipes is included.

External Interface Requirements:

  • Hardware

The Food Recipe Cross-Platform mobile app will be operating on Android and iOS.

  • Software

The mobile app will be compatible with the mobile and tablet(Android app) last versions.

Developer Requirements:

Hardware Requirements:

  • OS: macOS-64bit and Windows 7 (64bit) or later
  • HDD:1.23GB if windows or 2.8GB if MacOS for Flutter SDK
  • RAM:4GB (minimum)
  • Processor: Intel i3 3rdgen or AMD equivalent

Software Requirements:

  • OS: macOS-64bit and Windows 7 (64bit) or later
  • Tools: Flutter SDK
  • Android Studio/Visual Studio Code or any other IDE supporting dart
  • Git
  • Windows Powershell 5.0(only for windows users) 

User Requirements: 

  • OS: Android Jellybean or newer and iOS 8 or newer
  • Hardware: iOS devices (iPhone 4s or newer) and ARM Android devices
  • Storage Space: ~200MB
  • RAM: 2GB

Conclusion:

  • So by using this application users can cook different recipes at their homes.
  • They can also manage their diet.
  • They can manage their time.

The Food Recipe Cross-Platform application meets with the enterprise-class application principles. It is designed to be performing, scalable, extensible, and highly available.

Future Scope:

In future work, I am planning to persist in developing more mobile apps and entering deeply the world of Android development. Food Recipe Cross-Platform has helped me to gain a lot of development skills and enrich my background, as I spent the previous 4 months searching for every tiny detail that concerns the development of android applications. Thankfully, I have built a good knowledge.

Therefore, any upcoming Food Recipe project of mobile application development will undoubtedly be within my reach. In addition, as to the future of Recipe Organizer, I will deploy it in Google PlayStore and update the app from time to time if necessary. I will export my database soon and then buy an account in Google PlayStore to publish the app. Also, I will monetize my application using Admob.

Download the complete Food Recipe Android and iOS App Project Code, Report, and PPT.

The College Student App – A Solution to a Student common College Requirements

Problem Statement

A College Student App Android application needs to be developed that caters to the needs of students. The app should provide solutions to a student’s common requirements.

Timetable

Organize your daily college schedule with the help of the Timetable.
Create and customize according to your specific subjects for the semester.

Bunk Manager

Keeps you on track with the number of classes you have missed and warns you if you’re close to going below your attendance requirements for that course.

Expense Manager

Manage your expenses directly on your smartphone. The manager will be used by students to check the amount of money spent daily, weekly and monthly with the help of graphs.
The application also provides a widget for the expense manager to make it easier for the user to interact with it.

Memos

Quickly create, access, and organize notes. This proves extremely useful when you need to write things down on the go.

Reminder

It helps in reminding yourself of different important things which you don’t want to forget.
This feature has convenient messages which pop up on your notification bar as and when instructed.

The Study

Main Menu

The splash page on the left is the image that appears just as the android application is opened. It remains for 1.5s and is used to give time for the background applications to start running.

The College Student App main menu page is made to input details of the user, into the application. It appears only once when the application is first opened. These details are necessary for the Time Table and Bunk manager pages which are discussed later on.

The user has to input the following details into the text boxes

  • Classes per day (a maximum of 8)
  • Working days per week (either 5 or 6)
  • Total number of courses
  • The names of the course titles
  • Max number of classes in that course (max input of 60)
  • Required Attendance percentage

Menu screen

This is the initial page once the application is started and running. It serves as a menu for the user to choose the desired function. The menu screen of the college app consists of 5 buttons.

One button for each of the features present in the app:

  • Expense Manager
  • Timetable
  • Memos
  • Bunk Manager
  • Reminder

A single tap of any of the above icons will open the respective feature and take you to the next screen.

Reminder page

The College Student App Reminder application first starts off with a text box, which is used to give a title to your reminder. The user has to type in the message in this top space.
Next, the date and time of the event must be registered. The buttons when pressed open a drop-down panel that you can scroll through to find the correct date and time.
The date is in the DD/MM/YY format and the time is in the HH/MM format as shown above.
Finally, the bottom CREATE REMINDER button will finish the process.
The VIEW REMINDERS button stores all the previous reminders along with their date stamp for future reference.
The Reminder Message will pop up at the top of the screen in the notification bar at the specified time on the specified date. It also includes the ‘Big View’ Notification display.

Memo Page

Clicking on the memo icon will take you to the page above. This memo application is made to look like any ordinary piece of paper pinned down by a thumbtack. It’s an easy way to jot down any important points that you’ll need for further use.

The user can type in a title for the note on the top and continue with the details of the memo in the pop-up for the New Note.

Once saved, the user can create more and more memos by simply clicking on the green plus sign at the top of the screen. The minus sign on the left is used to remove a note that has already been created. It appears only after the first note is created and a pop-up gives you options to select the note you want to delete along with a Numpad.

Timetable Page

In the timetable feature, the user is meant to input the details once and then use the timetable for further use. The timetable page is made after initially asking the user whether they have a 5-day or 6-day college week. The number of classes in a day is also inputted along with the time intervals. After which the layout for the timetable is formed. Then one by one the classes are to be added. This is a one-time process.

After filling in all of the details, the user hits the confirm button to store the timetable. The timetable is saved and can be checked whenever necessary. It will be color-coded according to the subjects to simplify searching for the user. The edit button on the bottom of the screen allows the user to change the timetable if any adjustments are needed. The save button saves the changes made.

Bunk Manager page

The bunk manager opens up once the “Let’s Party” icon is tapped on. It opens up to an initial screen including all the subjects of the students. The student simply has to click on the subject which is currently taking place. Once the subject is selected, the next page that opens is the one that calculates your attendance percentage. If the user is attending the class, he taps on the Attended button. This draws a single tally mark under the attended column.

The same thing happens if the user is missing a class. In the bunk manager, the data is presented on the top of the screen. Also, the attendance percentage is automatically calculated as and when the classes are attended/bunked. This screen also includes an undo and reset button just in case you make a mistake or decide to attend class at the last moment. The last screenshot above shows the warning pop-up that opens up when the student’s attendance percentage goes lower than the minimum requirement.

Expense manager page

The expense manager page contains two buttons on the top. One dollar-eyed face for crediting money on the top left corner and another for debiting money on the top right.
First, it asks for the initial amount of money in your account which you have to punch in. After that, the user can update their expenses by filling in the pop-ups with the given number pads along with the reason for you spending their cash.

The application will keep track of your expenses and make sure that you don’t overspend. Another feature of this expense manager is the timely graphs showing the different ways you have spent your money.

There exist three columns:

  • A detailed expense for that specific day
  • Expenses with graphs per day
  • A monthly expense

Conclusion:

The College Student App is developed to be an innovative application and its main purpose is to get familiar with Android SDK and its development in general. The android OS has many advantages, as listed earlier, and this is why we picked this over others.

We primarily chose the Android platform as it is open-source and well documented, and the most commonly used mobile operating system among college students.

The advantage of declaring your User Interface in XML is that it enables you to better separate the presentation of your application from the code that controls its behavior. This feature of Android is used extensively in the development of our application.

Moving forward, we hope to push the user-specific data onto a server. We also plan to push notifications, tasks such as updating attendance records, wherein the user is notified after the class using the system time and date. Another functionality we would like to include is to sync expenses to a bank account thereby automatically updating the available balance when an amount is credited or debited. The application should be up on the Android play store soon once further testing and improvements have been made.

Citizens and the Municipal Authorities Connecting System Project

Abstract

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

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

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

INTRODUCTION

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

  • Background

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

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

  • Objectives

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

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

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

  • Purpose, Scope, and Applicability

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

  • Purpose

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

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

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

  • Scope

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

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

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

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

  • Applicability

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

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

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

ER Diagram:

ER Diagram

SYSTEM ANALYSIS

Existing System

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

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

Proposed System

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

Requirement Analysis

  • Problem Definition

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

  • Issues

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

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

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

Overview

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

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

 

Raspberry Pi Project on Intelligent Door Access Management System

Today the world has been far more advanced in technology than in the last 3 decades and with that, there are advances in the technologies that help to keep our homes safe. With the help of IoT now we can track our house even when we are on vacation.

The significance and the purpose of our Door Access Management System are to make the user’s home much safer by increasing security and giving the user full control of the system.

Introduction

Background of Project

When we are at work, we may have an important meeting and may not be in time to receive our guests and they may need to wait outside. The same may happen if we are on a vacation and to safeguard ourselves from Intruders.

The duty of an Engineer is to provide solutions for the problems faced every day with upcoming technologies and we have come up with a model which will help to solve them.

Statement of the problem

This project will create a smart doorbell messaging system so that when a guest clicks on the button, obtains an image of the user via a camera peripheral, uploads the image and event data to a Googles Firebase cloud, and sends a message with some message to notify that a guest has arrived.

Aims and Objectives of the project

The main objective of the project is to make a Smart door system. The other objectives are: –

  • To include an access button to allow the user to open/close the door

Materials

The main components of the Intelligent Door Access Management System are as follows:

  • Raspberry pi 3    
  • Push-button 
  • Logitech Camera                                                     
  • Stepper motor

Working

The first step was to make an interface between the Push button and the Camera using Raspberry Pi so that when the button was pressed the camera would take a picture. The next step is to connect the camera to the Firebase Cloud to upload the images in the Firebase Storage and send the image’s URL to the Firebase Database.

Next using Android Studio, a Mobile application was designed to retrieve the image from the Firebase Database. Using Node JS push messaging is also added along with the mobile app such that when someone is at the door a notification pops out. They can Open or Close the door using the buttons in the app. When pressed the data is sent to Firebase Database and retrieved by the Raspberry Pi which then operates the door.

Flow Diagram

Block Diagram of Door Access System

Bill of Materials:

Materials

Cost (in Rs.)

Logitech camera

1350

Raspberry Pi 3B

3500

Micro-Stepper motor

400

Push Button

50

Contingency

700

Total

6000

 

Future scope

  • Face recognition can be implemented to allow family members /regular guests
  • It can be integrated with a burglar alarm and inform the police of intruders 

Conclusion

The project “Intelligent Door Access Management System” has been tested real-world scenario and the door is opened or closed by the commands given by the user

GPS-based Child Tracker with Emergency Text Alerts IoT Project

The hectic life of parents makes it very difficult to personally look after the kids. To overcome the problem of personal monitoring of children, we have come up with the idea of a GPS-based tracker with text alerts when the child is not present in the specified region.

Problem Statement:

To solve the problem of difficulty in keeping a check on children while they are playing in open areas while letting the children have their freedom to play from constantly being mocked by parents and to monitor the whereabouts of children by working parents. There is a similar project on Women Security System that can be seen here

Project Working Process:

Hardware Components

  • Arduino UNO
  • GPS Module
  • GSM/GPRS Module 

Software’s Used

  • Arduino IDE
  • Android (MIT App Inventor)

In this context, the solution we propose is a GPS-based Child Tracker with Emergency Text Alerts android application that can help parents in tracking the presence of their children. This application works with the help of android mobile-enabled with the ‘SMS’ feature and ‘Global-Positioning System (GPS)’ on the GSM network.

This Child Tracker with Emergency Notifier application works in two ways, the first is GPS-based is related to Location services, and the second is SMS-based which is related to Network services. In case when the Location-based services not working then the application alternatively use Network-based services that can send and receive messages.

Block Diagram:

CHILD TRACKER WITH EMERGENCY NOTIFIER Block Diagram

The GSM and GPS module is connected to Arduino Uno. The GSM module has a sim (data) through which we can receive message alerts and the GPS helps to track the location.

The data is sent to the cloud from GSM using AT commands and HTTP. The cloud is connected to the mobile app and the data is displayed in the app installed on the parent’s mobile.

Useful Projects on Self Security in Emergency Situations:

Self Security through GPS based Protection System

Stay Safe Women Security Android App Project Report

The GPS-based Child Tracker with Emergency Text Alerts app is integrated with maps and geo-fence.

The GPS is connected to Arduino using a VCC pin, GND pin, RX pin, and TX pin. Connections: VCC to 3V3, GND to GND, RX to TX, and TX to RX respectively. GSM is connected to Arduino using VCC, GND, RX, and TX pins. Connections: VCC to 5V, GND to GND, pin 3 to TX, pin 4 to RX respectively.

A tiny GPS++ library is included. Using IBM cloud (node-red flow editor) the data is sent to a mobile app developed using MIT app inventor.

College Student Results Analysis Android App Subject wise and Department wise

Abstract

The College Student results app is an android application. It enables the students to check and get their each semester results within their mobiles by using their College Registration ID/Hall Ticket Number.

This College Student results in mobile app system is developed for students as well as their parents to check both the internal & external examination results.

Currently, the students are using the University website which is displaying only the individual subject marks and is lacking in some other advanced features which we will supplement through our mobile application.

Primarily, by using this result app project we can generate student individual results and analyze subject-wise and department-wise analysis (toppers list, Max marks, Min marks).

Android Project Features:

  • Latest user-friendly interface with a neat layout.
  • The total marks of the student with percentage will be displayed.
  • Push notifications whenever the results are out.
  • The list of toppers in the individual departments.
  • Sharing results on social networking sites.

Hardware Requirements:

Internal Memory: 512MB RAM
External Memory: 1GB
Speed: 1GHz Processor
Device: Mobile or Tablet

Software Requirements:

Operating system: Android
Programming languages: HTML5, XML, java
Database Used: Android SQLite Database
Others: Android Studio SDK

Related Projects on Student Exam Results System:

Student Result System Desktop Application in Java
Results Through Emails Java Project

Student Exams Backlog Management System Project using PHP & MySQL

Farm Assist – An Android Application for Farmers Assistance Project

Introduction:

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

Problem:

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

Technology stack :

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

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

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

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

App Home Screen of Farmers Assistance App

AGENDA:

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

Problems faced by farmers:

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

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

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

APP Demo:

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

Crop details:

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

Insurance:

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

Agro tips:

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

Related Projects on Farmers & Agriculture based below:

Real-Time Assistance to Farmers and Health Sector Android App

Farmer’s Medium of Communication for Support Price of Crops

Farmers Buddy Java Project

Automatic Humidity Monitoring and Pumping System for Farmers

Design & Development of E – Agriculture Java project