PROJECT

DESIGN AND IMPLEMENTATION OF ONLINE CASH RECEIPT GENERATING SYSTEM FOR A SUPERMARKET

By

-----------
---------------

SUPERVISED BY
------------------

A PROJECT RESEARCH SUBMITTED TO THE
DEPARTMENT OF COMPUTER SCIENCE,------- UNIVERSITY IN PARTIAL FULFILMENT TO THE AWARD OF BSc IN COMPUTER SCIENCE

MARCH, 2012

APPROVAL PAGE

This is to certify that this project written by ---------- with Registration Number ------ has been approved by the Department of Computer Science, ------ University ----, in partial fulfillment for the award of BSc in Computer Science.

……………………………. ………………. Date
(Project Supervisor).

……………………………. ………………. Date
Head of Department

……………………………. ……………….
Dean Date
Faculty of Natural Science

……………………………. ……………….
External Supervisor Date

DEDICATION

I dedicate this work to Almighty God.
ACKNOWLEDGEMENT

Very sincerely, my first greeting goes --------------------
ABSTRACT

This project was centered on online cash receipt generating system. The current process of cash receipt generation is being operated manually and due to this procedure numerous problem are been encountered. A design was taken to computerized the manual process in order to check this problem. The problems were identified after series of interviews and examination of documents after which analysis was made and a computerized procedure recommended. This project will also suggest how to successfully implement the computerized procedure and to overcome the obstacle that would hinder the successful implementation of the system. The new system was designed using Microsoft asp.net server side language and HTML. This language was chosen because of its object oriented features and wealth of .NET class libraries for developing online based applications.

TABLE OF CONTENTS
Title Page
Dedication
Acknowledgement
Abstract
Table of content

CHAPTER ONE
Introduction
Statement of the problem
Purpose of the study
Aim and Objectives
Scope Delimitation

CHAPTER TWO: REVIEW OF LITERATURE 9
2.1 History of On-line Cash transaction
2.2 Concept of On-line Shopping
2.2.1 Concept of Computer Networking and The Internet
2.2.2 Internet Access
2.2.3 Concept of Internet Gateways
2.2.4 The World Wide Web and Its Benefits
2.3 Merchant Account

CHAPTER THREE: RESEARCH METHODOLOGY, SYSTEM ANALYSIS AND DESIGN
3.1 Introduction
3.2 Research Methodology
3.3 Analysis of Case Study
3.3.1 Organizational Structure
3.3.2 Sources of Data
3.4 Problems Associated With The Current System
3.5 New System Design
3.5.1 System Proposal
3.5.2 Design Objectives
3.5.3 Input/Output Specifications

CHAPTER FOUR: SYSTEM DEVELOPMENT AND IMPLEMENTATION
4.0 Introduction
4.1 Main Menu
4.2 Web Development
4.2.1 Language Development
4.2.2 System Flowchart
4.3 Program Hardware Requirements
4.4 Documentation

CHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATION
5.0 Introduction
5.1 Summary
5.2 Conclusions
5.3 Recommendations Appendix
References

CHAPTER ONE
1.0 INTRODUCTION
Cash receipt generating system is a viable source in any business organization and venture and so on, its main purpose is to maintain more reliable records of money going in and out from the firm. This is look upon the view that the business organization must have business associates that exchange market with each other. It is a sure fact that the most have been a contract of which, there is an obligatory task that stands the terms of agreement, it could be a payment to their client or partners or from their client who pays into their own account. Another thing matters weather it will be cash without remark balance or install mental, and how many installment it is going to be.
This is clear stated in the organization activities and manner of operation. Whenever there is payment, there is also the issuing of receipts this is centered on the writing of what each party has in stock.

1.1 JUSTIFICATION OF THE PROJECT
For there to be a computerized business operation, the business must be look upon in a new way of existence. Not only being concerned with customers, prices output and so forth one should also consider the fact that data forms, information flows procedures etc. it is momentous on the basic that computers are used as a co-existing element to information system. This application is effective and productive because it enhance to process amore better information system. (Automated)
On this work, we shall basically look upon the possibility of making the outline orderly model of designing effect change. The process of changing system is systematic such that it is a repetition process. It is a fact to say that every system has what is called life cycle especially information system. By reviewing and modifying them, we say,

It is a system development cycle. The routine is always cyclical. It is on the system development that the familiar input processing output-feedback pattern of all system. The system development contains the output which consists of various organization information systems. The feedbacks components help evaluate the effectiveness of the systems terms of changing requirements.
IN THE PROCESSING COMPONENTS WE HAVE THREE PARTS
System analysis
System design
System implementation.
None of these parts can be considered apart from the other two. To be courtesy, I would say that the activities involved in system development is interlinked set.

1.2 DEFINITION OF PURPOSE
The rate of accepting different sources of receipt by the topic of this project paper into an organization, keeping track of the files can at any operates the organization and client’s financial report.

1.3 PROBLEM DEFINITION
Cash receipt system of Rorban Stores LTD. Is to keep records of all receipts of purchase and sales made.
By so doing, they keep information concerning each transaction such as the name of client, address, data of transaction, description of goods. Quantity of goods, model number of the goods, the amount of the goods.
Inside this record the company can the know the financial reports of both the client and the organization itself.

1.3 SCOPE (DELIMITATION) OF THE PROJECT
This project is basically restricted to Rorban Stores LTD, as a case study for the project paper. Looking Rorban stores, the cash receipts system is restricted only to the.

1. Purchase receipts and/or invoice
2. Sales receipts and/or invoice

Other organization may run a different receipts system. At this project paper we shall base only on sales and purchases.
SCOPE OF PURCHASES
Out of this interview with the accountant and sales manager of Rarban stores LTD, I discovered that the organization do not keep any record on credits when purchases are made. Therefore the term paper nullifies the idea of computing credit in the purchase.
It will be right to say that Rorban stores do not go into purchasing on credit to avoid keeping much records that most often conflict matters.
SCOPE OF SALES
There is a particular sales file for all buyers and dealers (companies that buy from them) that buy on cash. It also maintains a separate buyer’ sales creditors files, and a separate buyers sales debtors files, that is kept by the company.
Therefore the term paper is basically on the above mention area as in sales. By this the company maintains one purchase data base file and three sales data base files, a total of four data base files.
DEFINITION OF TERMS
ACQUIRING BANK: This is a bank or financial institution that accepts payments for the product or services on behalf of a Merchant.
ASP.NET: This is a powerful server side scripting language for creating dynamic and interactive website.
COMPUTER: This is an electro-mechanical device that is capable of accepting data as inputs, stores it, processes the data and outputs it as result or information.
CREDIT CARD: It is a payment mechanism that enables consumers to make their online purchase.
DATA: Data are raw facts which undergo processing and become information. They are also the simplest unit of information that can stand on its own.
DIGITAL CERTIFICATE: It is a certificate that enables a merchant to do on-line business and it is been issued by a corporate body.
GATEWAY: This is a device that connects two computer networks that cannot be connected in any other way.
HYPERTEXT DOCUMENTS: They are documents written with HTML, ASP, ASP..NET, PHP, JAVA SCRIPT PAGES (JSP), CODE FUSION, PROGRAMMING LANGUAGES.
INTERNET: It is an interaction of computer networks connecting other networks from computers, companies, houses etc.
ISP: (Internet Service Provider):This is a company(s) that provides internet access to homes or business users.
MERCHANT ACCOUNT: It’s a contract under which an acquiring bank extends a line of credit to a merchant who wishes to accept payment card association brand
MS SQL: This is relational database server that is ideal for both small and large applications.
ON-LINE SUPERMARKET: It is representation of material or real shop on the internet or on the web.
ON-LINE SHOPPING: This is the buying and selling of products through the internet or web.
PROGRAM: A program is a sequence of instructions written in a computer to execute a certain task and solve a problem. A program must possess clarity, be specific, effective and user friendly.
WWW (World Wide Web): It is a multimedia interface that connects us to resources such as documents, e-mails, chat, web sites that are available on the internet with the computer.

CHAPTER TWO
LITERATURE REVIEW

1.0 INTRODUCTION
The review of literature discusses or deliberates on the inspection and examination of the various areas in this chapter that will appear or contribute in the writing of this project such as the concept of online cash transaction, concept of computer networking and the internet, internet access, concept of internet gateways, the world wide web and its benefits and the merchant account.
All these will in one way or the other be part of the breaking down of this project topic.
2.1 HISTORY OF ON-LINE CASH TRANSACTION
This brief history of on-line cash receipt generation is taking its roots from the parent system which is the E-commerce also known as electronic commerce. Online cash receipt generating is the buying and selling of products specifically over the internet. Unlike the general name E-commerce which involves buying and selling of all other goods and services. It is interesting to say that the relationship between them is that there is an exchange of goods instead of at the location of the store; it is conducted on-line and makes use of technologies such as electronic data interchange, E-mail, electronic fund transfers or smart cards to receive payment and keep track of transactions.
As history has it, at the close of the 20th century the bulk of Online cash receipt generating as a part of E-commerce transactions were retail transactions as security and encryption technology over the internet improved. It was affected by the explosive growth in E-commerce due to the expansion of the medium (internet) in the late 1990s.
It almost moved faster than other segments of E-commerce transactions due to the ease and interest in people to be more knowledgeable. It spiced up the transactions in E-commerce because from the statistics E-commerce grew from $11.2 billion in 1998 to $31.2 billion in 1999, and in the year 2003, the transactions were predicted to grow to $380 billion. All these came to be as online cash receipt generating started to become one of the fastest growing segments of E-commerce. As it is said its transactions are business-to-business. Soon after then, companies like eBay created a new aspect of E-commerce which is the consumer-to-consumer transactions.
Conclusively, online cash receipt generating joined as E-commerce became the ideal medium for markets to experiment with adjustments in their store environments and promotions to reach the most effective market target.
2.2 CONCEPT OF ON-LINE SHOPPING
Literally, the word shopping denotes the activity of going to shops and buying things (0xford Advanced Learners Dictionary).
According to Kiely T. (1997), On-line shopping is the buying and selling of goods or services on-line or via the internet or other networks. While Microsoft Encarta premium (2009) is of the opinion that it is the exchange of goods or services by means of the internet or other computer networks. This follows the basic principle of traditional commerce i.e the buyers and sellers coming together to exchange goods for money and profit. This concept provides an opportunity or avenue for consumers and retailers to communicate with each other and carry out their objectives i.e conduct business.
Rani Kalacota (1997) defined On-line shopping as part of an on-line business where consumers meet their suppliers for goods and services while Christopher M.H and Chris F. K (1994), defined On-line shopping as the process of managing on-line financial transactions by individuals and companies. This however, includes business-to-business (B2B), business-to-consumer (B2C) and business-to-government (B2G) transaction. However, On-line shopping launches its focus on the systems or methods and procedures whereby all financial documents and information are exchanged. The on-line financial statements are not left out. According to Christopher M. and Chris F. K’s (2002) comments on this, on-line shopping is particularly concerned with the technologies that enable EPI systems function well on the internet.
But Batty, J.B and Lee R.M. (1995) were of the opinion that there is no working and internationally recognized and agreed definition of on=line shopping. On-line shopping however has got to be defined with the three factors involved, which are the network which is the medium through which the relevant activities are carried out; the processes which are involved and to be included in the general domain of on-line shopping and lastly the actors which are the buyers or customers involved in the transactions.
2.2.1 CONCEPT OF COMPUTER NETWORKING AND THE INTERNET
According to Microsoft Encarta premium (2009), computer networking is simply a system used in linking two or more computers. Networking itself is a group of connected computers that allow people share information and equipment. Computer networking uses a communication link or node through which the E-mails, files resources and other applications are sent and received. A computer system and a printer can both serve as communication links in a network. However, there are other devices.
It has layers, and criteria, parts and connection types, topology and types of networks, network peripherals and at areas of applications. All these a computer networking process must pass through to ensure effective on-line business.
Networks are specified through broad and narrow definitions. The broad definition considers an on-line transaction to be the sale or purchase of goods or services either between businesses, households, individuals, government, other private or public organizations.
The role of networking in on-line shopping is that of conveying, providing computer system and other resources and connecting them for the on-line transactions.
The internet on the other hand is a computer based global information system. It is composed of many interconnected computer networks. Each network may link tens, hundreds or even more. The satellite systems are vital tools/equipments in internet computer network. Its role is of paramount importance. It includes advertising the books selling, buying delivery and providing other customer services. Meanwhile, the narrow definitions of Batty J.B and Lee R.M (1995) have it that internet transaction (on-line shopping) to the sale or purchase of goods and services whether between businesses, households individuals governments and other public or private organizations are conducted over the internet. The goods and services are ordered over the internet, but the payment and the ultimate delivery of goods or services may be conducted on or off line.

2.2.2 INTERNET ACCESS
According to Microsoft Encarta premium (2009) Internet Access technological refers to the communication between residence or a business and the ISP (internet services provider) that connects them to the internet. They are of three types namely; dedicated, dial up and wireless internet access.
It is therefore the communication that is going to exist between the customer, the ISP and the supermarket through the internet. It is all about the easy accessibility the customers will enjoy
2.2.3 THE CONCEPT OF INTERNET GATEWAYS
The computer system hardware contains software that connects networks that use different protocols (the rules the hardware components and the software components use to communicate) or that transfers data between two incompatible applications on a network. It reformats data so that it is acceptable to the receiving network application. The term internet gateway is usually used to describe any computer that transfers data from one computer system to another.
2.2.4 THE WORLD WIDE WEB AND ITS BENEFITS
This is the multimedia interface that connects us to resources or the customers to the documents, goods, services, e-mails, chats about the books and other websites available on the internet. The World Wide Web which is abbreviated www is the window from which we see the information in the internet.

It all began in 1992, prior to it, the internet was just an ordinary text, documents without pictures, sounds or video, it is through the website that we will carry out the on-line shopping. The benefits accruing from the use of the World Wide Web are so numerous. To mention but a few, the ease it has given to people to send and receive messages to study and even purchase goods on-line and to know and see things and other people in other parts of the world.
2.3 THE MERCHANT ACCOUNT
According to (Duncan et al), merchant account is a contract under which an acquiring bank extends a line of credit to a merchant, who wishes to accept payment card transaction of a particular card association brand. Without such a contract, one cannot directly accept payments by any of the major credit card brands. When using an intermediary payment services provider (such as pay pal), the merchant account is held by the service provider itself. Here, the contract of the Acquiring bank with the merchant is informally referred to as a merchant account. It is rather a line of credit and not a bank account.
Under this contract, the acquiring bank exchanges funds with issuing banks on behalf of the merchant, and pays the merchant for the net balance of their daily payment card activity.
CHAPTER THREE
2.0 INTRODUCTION
This section of the project deliberates on the source of information about the current system organization and maintenance. The organizational chart, representing the organizational structure of the supermarket in a hierarchical order will be illustrated. The problems of this system will be outlined carefully.
Finally, the proposal of the system to be developed, its exploration, input and output specifications, requirements and the scope will be expressed.
3.1 RESEARCH METHODOLOGY
The main method of research concerning this project is by observation and interview with the supermarket members of staff. After frequent visits to the supermarket, it was easy to draw out conclusions from some observation about the current system. Brief interviews with some customers who agreed having an idea of the online cash receipt generating system were also of great help to this project.
3.2 ANALYSIS OF CASE STUDY
The Rorban supermarket is a supermarket like other supermarket established with the aim of generating some worthwhile revenue through the sale of products and services to customers.. The supermarket is located in owerri. Its missions are to provide customers with quality and edifying products and services for their use with ease at affordable prices.
3.2.1 ORGANIZATIONAL STRUCTURE
3.2.2 SOURCES OF DATA
The data that were collected in this research were from the primary sources. Observations were made during the visit to the supermarket. The sales manager was extensively interviewed for first hand information. Other sources of data, were of the secondary source, which includes gathering information from textbooks, journals and magazines, materials from internet, Microsoft Encarta premium, seminars, lectures and personal researches.
3.3 PROBLEMS ASSOCAITED WITH THE CURRENT SYSTEM
It is a clear statement and a well-known adage that two heads are better off than only one. Hence the need for the research works.
Apart from the problems existing from being manned by one man, there are other problems, namely;
Difficulty in keeping record of products and daily transactions: Due to the quantity of products that come there, difficulty in keeping accurate records occurs.
Time wastage: This problem results in a waste of time in sorting out products
Poor equipment: There are little or no shelves or counters to keep products for easy reach and retrieval. It makes the whole hall untidy because products are scattered on the floor.
Slow services: There is always problem of slow service because of one shop keeper.
3.4 THE NEW SYSTEM DESIGN
In the process of evaluating the solution and the specifications of a detailed on-line based solution, there is need for the system design. In designing the new system, the software and hardware aspects were taken into considerations in order to produce a workable website that will allow effective and efficient communication between the customer, the merchant and the acquiring bank or acquirer.
Also the customer can make an order, make payments for the goods ordered, and the goods will be shipped to hin/her.
DATA DESIGN: This involves the choice of data structure and database. The website uses MSSQL server as the database. This sophisticated database allows the administrator to monitor effectively and run some query language in the server. It is equipped with maximum security to prevent hacking.
USER INTERFACE DESIGN: It is a system that permits the interaction between human beings and the computer. The project has a user interface design because of the level of interaction the buyer or credit or master card wants.
PROCEDURAL DESIGN: This involves the design of an efficient algorithm that will satisfy the functional description of the various sub systems of on-line shopping.
PROGRAM MODULE SPECIFICATIONS
These are the program module:
i. Home page ii. About Us iii. Products Category iv. Products
v. Shopping Cart
REQUIREMENT SPEIFICATIONS System requirements are a description of the needs, and devices a customer needs for an information system. Here, unique requirements of a system are identified as user requirement. These are the URL address of the site, as he wishes to make an order.
CHOICE OF PROGRAMMING LANGUAGE
This project is implemented with the following programming languages.
C#
ASP.NET
XHTML
MSSQL
INTERNET INFORMATION SERVICE SERVER
WML (Wireless Markup Language): It is a tag based markup language designed after the model of HTML for web contact. The designers of WML and its companion scripting language (WML script) created an environment that demands less memory and processing power from the browsers than HTML and JavaScript. This language was used because it includes features that project it for relatively processor) small display sizes of today’s wireless devices.
ASP.NET It was considered suitable or this project because it is a powerful server side scripting language for creating dynamic and interactive website. ASP.NET is widely used, free and efficient alternatives to competitors such as PHP. ASP.NET is perfectly suitable for web development and can be embedded directly into the HTML code. It is often used together with Internet information service(web server) on various operating systems. It also supports ISAPI and can be used with Microsoft IIS(Internet Information System) on windows. Scripts in a ASP.NET file are executed on the server that is why it is more sophisticated than other programming languages. It runs on different platforms, (windows, linux, unix etc).
MS SQL: MSSQL is a database server that is ideal for both small and large applications like the project of this type. It supports standard SQL and it compiles on a number of platforms INTERNET INFORMATION SERVICE SERVER: This is used to deploy the on-line site.
3.4.1 SYSTEM PROPOSAL
This emphasizes on the purpose of the newly designed system so as to facilitate the operations of the shopping system. This system proposal here has come to scrutinize the old manual system, improve it and propose a new one which will prompt the supermarket to be more effective and efficient in their operations.
3.4.2 THE DESIGN OBJECTIVES
The purpose of this project is to design an on-line system where customers; from anywhere can purchase their products with reduced stress and at cheaper rate. The purpose of designing this system includes the following,
To be able to conduct business 24 x 7 x 365. That asserts that the system will operate 24 hours a day, 7 days of the week and 365 days of the year.
Access the global marketplace meaning that the internet spans the world and is possible to do business with any business man who is connected to the internet. This global opportunity is assisted by the fact that unlike traditional communication, user or business men are not charged according to the distance over which they are communicating.
Speed electronic communications always allow people to do their transactions faster without waiting for the shop keeper to sort them out.
Strategic place here is this global market on the internet, students can easily go and make their orders without having to search long for it.

INPUT/OUTPUT SPECIFICATIONS
These are the data needed from the student/customer making the purchase.
i. Surname ii. Other names iii. City iv. Zip code
v. E-mail address vi. Country vii. Mobile phone viii. Destination/location address ix. Gender
x. Office address xi. Submit xii. Reset

CHAPTER FOUR

3.0 INTRODUCTION
Having heard and read all from chapter one about the old system and this new method that will be designed to restructure it. We have come to this chapter, the fourth chapter where the system will be developed and implemented. Also, before the end of this chapter, the main menu, web development, language development (selection), system flowchart, program flowchart, program source codes, hardware requirements and finally the documentation, all will be discussed in this chapter.

4.1 MAIN MENU
This is the home page of the website that has been developed. The home page of any website is the first page that appears whenever you open a website. It contains the name of the site, logo as the case may be and other icons known as hyper links that will help you navigate to other areas. it also contains other hyperlinks made for free and easy access and use by even those that are not programmers. These hyperlinks can also be called web pages, when clicked links user to other resources.

4.2 WEB DEVELOPMENT
Web as it is known is always associated with the spider. It is an intermingling of things, wires, ropes etc. Technologically, it is multiples of network connections, or network. The web was developed with the name of the firm, the reason for the website and other additions such as the functions of the firm. All these contributed to the development of this web.

4.2.1 LANGUAGE DEVELOPMENT/SELECTION
The language here in question is not the language spoken by human beings. The computer has a set of symbols, digits and instructions written in sequence known as programming language which the computer operator used to communicate with the computer. Here among the programming languages the one considered most suitable by the system developer/programmer and used to write the source program and the code was ASP.NET). It was used due to its user friendliness and worthwhilness.
4.2.2 PROGRAM FLOWCHART

4.3 PROGRAM/HARDWARE REQUIREMENTS
The computer hardware are the physical components of the computer system. The hardware requirements of this website are a
Minimum of Pentium III processor with 1.4 GHZ speed
512 MB of RAM
Hard disk of at least 40GB
SVGA monitor
Network card (adapter)
Then the software applications that are necessary for the implementation of this application are
Windows 2003 (server edition windows XP (Home or Professional edition) windows vista, unix or linux.
Internet Information web server
ASP.NET
MS SQL
4.4 PROGRAM DOCUMENTATION
Documentation is actually the last step in system implementation phase. It is the process of collecting, organizing, sorting and otherwise maintaining on paper or on some relative medium for reference purposes.
A completion of document of the system marks its changes in status from project under development to a functioning body capable of operating without guidance and controls of its designers. It can now be understood, operated and modified by others as the need arises.
CHAPTER FIVE

4.0 INTRODUCTION
An adage says that every beginning has an end. With everything being under total submission to nature, we have finally arrived at the last chapter of this project work, this chapter discusses in brief all that have been said in the first, second third, fourth, and the fifth chapters. Also included are the summary, conclusions and recommendation parts of this chapter.

5.1 SUMMARY
On-line cash receipt generating system a unit of E-commerce is a website that will synthesize and increase the functionality of product sales. Although a lot of websites have been designed and hosted to achieve a lot of goals in different businesses, this one exclusively designed for Rorban supermarket will go a long way in boosting and unveiling the fortunes of the supermarket, and their method of operation which has not yielded sufficient profit as expected.
This the web designer/developer noticed and took up as a topic. All the steps starting from the first chapter are all designed to make the website project come through. For future references and modifications, the source code is also included showing the language steps used to design the website.

5.2 CONCLUSION
In conclusion, this is a user friendly website designed for on-line buying and selling of products with the capabilities of generating receipt. It is a site that inculcates the new web technology in its full design. When this is fully implemented it will promote and improve the standard of operations of the supermarket which is entirely manual. Furthermore, as the whole wide world walk towards living in a global community, the supermarket, will now fit into the global market community and be recognized. The inconveniences faced by our customers and unsatisfactory turnover will now be history.

5.3 RECOMMENDATION
Having presented all that is required for the successful implementation of this project research work, the following are suggested by the programmer aimed at improving and eliminating the problems encountered each day by both customers and the management. The measures are as follow;
The server should be managed by a database administrator who has undergone training on using MSSQL database.
A merchant account should be obtained from any of the financial institutions.
There should be a regular update of the website so as to compete and give round the clock service to the people.
There should be no hesitation in attending to the needs of the new system designed.

References: 2.2.1 CONCEPT OF COMPUTER NETWORKING AND THE INTERNET According to Microsoft Encarta premium (2009), computer networking is simply a system used in linking two or more computers 2.2.2 INTERNET ACCESS According to Microsoft Encarta premium (2009) Internet Access technological refers to the communication between residence or a business and the ISP (internet services provider) that connects them to the internet