Project Report on easy billing system, Study Guides, Projects, Research of Computer Programming

Download Project Report on easy billing system and more Study Guides, Projects, Research Computer Programming in PDF only on Docsity!

Pinkle Makhijani

BCA Final Year

Visual Basic Project Report

A WORK REPORT SUBMITTED

IN PARTIAL FULLFILLMENT OF THE REQUIREMENT FOR THE DEGREE

Bachelor of Computer Application

Dezyne E ´cole College

106/10, CIVIL LINES

AJMER

RAJASTHAN - 305001 (INDIA)

(FEBRUARY, 2018)

www.dezyneecole.com

SUBMITTED BY

PINKLE MAKHIJANI

BCA 3rd^ year

Acknowledgement

The satisfaction that accompanies that the successful completion of any task would be incomplete without the mention of people whose ceaseless co-operation made it possible, whose constant guidance and encouragement crown all efforts with success.

The project on Supermarket Billing System was developed in Visual Basic Language at Dezyne E´cole College.

During the making of this project we have learnt a lot and we are extremely grateful and remain indebted to our guide MR. Tarun Sharma for being a source of inspiration and for his constant support in the design, implementation and evaluation of the project.

We are thankful to them for their constant constructive criticism and invaluable suggestions, which benefited us a lot while developing the project on “Supermarket Billing System”.

He has been a constant source of inspiration and motivation for hard work. He has been very co-operative throughout this project work.

Through this column, we express our warm thanks to him for their encouragement, co- operation and consent without which we mightn’t be able to accomplish this project.

I cannot move on beloved without thank beloved Principal Mrs. Vinita Mathur for creating the required academic environment which made my task appreciable.

We would like to thank the other faculty member also, at this occasion. Last but not the least, we would like to thank our friends & family for support and encouragement they have given us during the course of our work.

We also thanks our colleague Mr. Rakesh Bijawat who have helped in successful completion of the project.

With due regards

Ms. Pinkle Makhijani

BCA 3rd Year

Synopsis

The project Supermarket Billing System gives us the facility to manage the supermarket

billing system. This application is helpful for staff or admin for billing of products and

managing products details. This application is access by only staff and admin. Members can’t

access it directly.

The project is very useful for those who want to know about Supermarket Billing System. This

application maintains the records related to Products, Employees, and Sales etc.

We can enter the details of new products or employees and retrieve the details of products

and employees available in the System. We can generate the bills for the customers. We can

also maintain the records of customers .In this project we can maintain the GST calculation of

every product. GST can be issued according to Govt. specified categories of all the products.

Total sales can also be maintain in this project. All necessary requirements for the

Supermarket Billing System has presented in this project.

Main Project Undertaken (During College Study):

 C Language Assignment : This Project includes many C programs for e.g. String Diamond, Power Calculator, Armstrong Calculator, Prime Number Calculator, Perfect Number Calculator, Student Mark sheet Printer, Palindrome Calculator, etc.

 C++ Language Assignment : This Project includes many C++ programs for e.g. ATM Machine System,Sorting of Array, Human to Machine , Palendrome Calculator etc.

 C++ Language Assignment : This Project includes manage transaction of Money and Users Account like Deposit, Withdrawal, Transfer, Mini Statement, User Account Information etc. and it has two parts that 1 for Exist User and 2 for Create New User. This project is useful to manage Multiple Users Bank Account and their transactions.

 Java Language Assignment : This Project includes Wrapper class description which is created in MS-Word.

Declaration:

I hereby declare that particulars given here are true and complete to the best of my knowledge and belief.

Chapter – 1 Introduction of Information Technology (IT)

Information Technology –

Set of tools, processes, and methodologies (such as coding, programming, data communication, data conversion, storage & retrieval, system analysis & design, system control) and associated equipment employee to collect process and present information. In broad terms, it also includes office automation, multimedia and Tele – communication.

Information Technology, a source we call the “computer” , that can show you what information via Tele-portal, scoping, working calibration for transmitting throughout the world.

More commonly known as I.T. is the most popular career and the fastest growing industry in the world. There are several success stories about people who choose this field for a career and are now on top of their game.

Few reasons for why people choose IT -

 Low cost of education The biggest advantage of choosing information technology for a career is that it has very low cost of education as compared to many other career choices. You don’t need degree to become an I.T. professional. Instead, you can get quick training to be certified in specific areas of information technology. This way you save huge amounts of money that you may have otherwise spent on years of college tuition.  Fastest changing industry The information technology industry operates at a speed much faster than any other industry and for this reason, there’s always a significant demand for highly skilled workers with the innovations in cloud computing, big data and cyber security an aspiring I.T. professional has many avenues to pursue and grow from and I.T. professional never stops learning, and must always stay on top of the latest technology trend in order to be successful in the field. The more training and knowledge the I.T. professional has the more employable he or she will be.

 Better income It is well known fact that information technology professionals are paid well, compared to other professionals. An I.T. professional with the right mix of certifications & experience can find a permanent position in either the public or private sector. Recently many companies have been extensively hiring experts in cloud computing, cyber security and network security to help enhance their current systems.

o Relational database management system (ORACLE / SQL) o E - Commerce o Computer Network and Mobile Computing o Internet tools & website development (JavaScript, ASP) o Management Information System

Chapter – 2 Introduction to Project

The project is Supermarket Billing System software for monitoring and controlling the transactions in a supermarket.

The project Supermarket Billing System is developed on visual basic language which mainly focuses on basic operation in a supermarket like – adding new employee, adding new products, updating information of employee, searching products and employees and facility to generate bills of customers and calculate total sales amount of the supermarket.

Supermarket Billing System is a windows application designed to help staff or admin to maintain & organize supermarket system. Our application is easy to use for both beginners & advanced users. It features a familiar and well thought – out, an attractive user interface, combined with strong searching, insertion & deletion capabilities. It can also calculate GST amount on every product.

The application Supermarket Billing system has four main module –

 Insertion, Deletion, Updation to database module – User friendly input screen.  Extracting from the database module – Attractive output screen.  Generate bill module – generate bill of purchased products.  Search facility system Module – Search for products and employees.

Many Supermarkets use this type of billing system for make their work easy. It is also improved according to requirements of sellers and users. In this Billing System we can maintain the security feature also.

Why it is made –

The main objective of this project is to provide a friendly environment to maintain the details of products and employees and generate bill for customers. The main purpose of this project is replace the manually work.

What Language –

Visual Basic 6.0 Language

Visual basic (VB) is a 3rdgeneration event-driven programming language developed by Microsoft for their operating system windows. Visual basic is a widely understood high level programming language, written using simple English. Like – words & syntax.

It is an interpreted language. Code can be run immediately after being written. Having an interpreter makes its simpler to use, as there is no need for the computer to compile the code, possibly finding errors to fix, before the compiled version can be run. Once the code is working, it can be compiled into an .exe file so that it will run on all modern windows computers, whether VB is installed or not. The language allows a beginning programmer to produce professional – looking windows applications, as its include drawing tools to create

Chapter – 3 Project & Their Facilities

Supermarket Billing System is a project which aims in developing a computerized system to maintain all the daily work of supermarket. This project has many features which are like – Admin log or Employee login. It has also a feature of GST calculation of every product. We can easily add new products and add new employees in the database. It has secured database and admin and employee can only login with a unique ID and a password.

Overall this project is ours is being developed to help in any supermarket to maintain the billing facility in the best way possible and also reduce the human efforts.

Here is a list of some features which are in provided in this application –

 Keep records of employees and products with Unique ID of every employee.  Easily generate GST calculations on bills.  Accurate data in the database.  Easy way to Log-In and Log-Out.  Bill generation of every customer on their mobile no.  Add data of customers in the database for future use.  No need to invest heavily on hardware.

Objective of Supermarket Billing System –

1. Automation – The application automates each and every activity of the manual system and increases its throughput. Thus the response time of the system is very less and it works very fast. 2. Accuracy – The application provides the user a quick response with very accurate information regarding the bill calculation and customer detail etc. any details or system in an accurate manner, as when required. 3. User Friendly – The application Supermarket Billing System has a very user friendly interface. Thus the users will full very easy to work on it. The application provides accuracy along with a pleasant interface. Make the present manual system more interactive, speedy and user friendly. 4. Availability – All the Billing details stored permanently in the database admin can see the data, whatever needed.
2. Maintain Cost – Reduce the cost of maintenance. It is standalone application so no required of cost for maintain it.

Chapter – 4 Project Design

The project design process is not a step by step. But still much of design work depends on knowledge and experience of the designs, when we start working on project design, we will face different types of problems. However, following considerations should be kept in mind during the project design phase:

Design Objectives –

The primary objective of the design of course, is to deliver the requirements as specified already. In general the following design objectives kept in mind.

Practically –

The system must be stable and can be operated by people with average.

Efficiency –

This involves accuracy, timeliness, and comprehensiveness to the system output.

Cost –

It is desirable to aim for a system with a minimum cost subject to the condition that it must satisfy all requirements & maintain maintenance.

Flexibility –

The system should be modifiable depending on the changing needs if the user. It should also be portable to different computer system but not other than Windows OS.

Security –

This is very important aspect of the design and should cover areas of hardware reliability, fall back procedures, physical security if the data. System design involves first logical design and then physical construction of the system.

Major Project Design Activities –

Several development activities are carried out during structured design. They are database design, implementation planning, and system interface.

Design Process –

The system design process is an exercise of specifying how, the system will work. It is an interactive process which is based on what the system will be do as shown in the report. Mainly following two parts have been included in the system design process.

 DFD Level 3

 DFD Level 4

 

Admin (^) Supermarket Billing System

Employee

Employee details Product details Sales details Customer details

Add new, Update, Search, and Remove Sales between

Admin Supermarket Billing System

Employee

Bill Generation Today’s Sales

Chapter – 5 Database Development

This activity deals with the design of the physical database. A key is to determine how the access path art to be implemented.

As a programmer, we are expected to design and develop any program that works correctly efficiently and the time is easy to be used by every person, who may or may not be well versed with computer and its capabilities.

The project is based on the Supermarket Billing System, Being the Information System it requires extensive use of some Database Management System to store, manipulate & handle the huge and complex record. In DBMS we can act various attributes with the database like editing the records, modifications, deletions of the records, view the records in various formats, listing the database etc.

MS Access –

Microsoft Access is an office product that allows the user to create relational databases that have tables of data. MS Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications & databases. It’s an easy to use tool for quickly creating browser based database applications.

In very simple term, MS Access is an Information Management tool that helps you store information for reference, reporting & analysis.

Microsoft Access helps you analyze large amount of information, and manage related data more efficient than MS Excel or other spreadsheet applications.

In our project we create 12 tables in MS Access-

 Admin

 Customer Details

 GST

 Product Category

 Product Details

 Product Type

 Recover Employee Details