Design And Implementation Of Computerized Price Checking System
abstract of Design And Implementation Of Computerized Price Checking System
The business-to- consumer aspect of an online shopping is the most visible business use of the World Wide Web. The primary goal of an online shopping site is to sell goods and services online. This project deals with developing a computerized price determining system for shop ware. It provides the user with a catalogue of different goods and services available for purchase in the store. In order to facilitate online purchase a price checking website is provided to the user. The system is implemented using a 3- tier approach, with a backend database, a middle tier of Microsoft Internet Information Services (MIIS) and PHP, and a web browser as the front end client. In order to develop an e- commerce website for online shopping, a number of Technologies must be studied and understood. These include multi- tiered architecture, server and client side scripting techniques, implementation technologies such as ASP.NET, programming language (such as C#, VB.NET), relational databases (such as MySQL, Access). This is a project with the objective to develop a basic website where a consumer is provided with a price checking application and also to know about the technologies used to develop such an application.
table of contents Design And Implementation Of Computerized Price Checking System
CHAPTER ONE. 1
1.0 Introduction. 1
1.1 Statement of the Problem.. 1
1.2 Purpose Of The Study. 2
1.3 Objectives Of The Study. 2
1.4 Scope Of The Problem.. 3
1.5 Limitation Of The Study. 3
1.6 Assumption. 3
1.7 Definition Of Terms. 4
CHAPTER TWO.. 5
LITERATURE REVIEW… 5
2.0 Review Of Related Literature And Studies. 5
2.1 Related Literature. 5
2.2 Related Studies (Foreign). 9
2.3 Advantages Of Computerized Price Checking System.. 10
CHAPTER THREE. 12
3.0 Description Of The Existing System And Design Of The New System.. 12
3.1 General Description Of The Existing System.. 12
3.2 Fact Finding Method Used. 12
3.3 Objectives Of The Existing System.. 12
3.4 Organizational Structure. 13
3.5 Input, Process, Output Analysis. 13
3.5.1 Input Analysis. 13
3.5.2 Process Analysis. 14
3.5.3 Output Analysis. 14
3.6 Information Flow Diagram.. 15
3.7 Problems Of The Existing System.. 15
3.8 Project Design. 16
3.8.1 Design Of The New System.. 16
18.104.22.168 Input Specification and Design. 17
3.9 File Design. 17
CHAPTERS FOUR. 20
4.0 System Design. 20
4.1 User Interface Design. 20
4.2 Implementation Technologies. 20
4.3 Internet Information Services (IIS). 21
4.4 ASP.NET. 22
4.4.1. Authentication in ASP.NET. 22
4.5 MySQL Database. 23
4.6 Integrating IIS and ASP.NET. 24
4.7 Integrating the Website and Database. 25
4.8 Web Page Programming Options. 26
4.8.1. Server-side processing. 27
4.8.2. Client-Side Processing. 31
4.9 Web Based Application Development. 33
4.10 Database Connectivity. 34
4.10.1 ADO.NET. 34
4.10.2 Connecting ASP.NET application to a Database. 40
CHAPTER FIVE. 43
5.0 Summary of Result. 43
5.1 Conclusion. 44
5.2 Recommendation. 45
DISPLAY ILLEGAL.. 49
KG = 1 TO 999. 50
PRINT WEIGHT & PRICE.. 50
PSEUDO CODE. 52
chapter 1 of Design And Implementation Of Computerized Price Checking System
With the write of their great capacity and speed in technology, computers have helped workers in business perform their jobs more efficiency, since their introduction in the 1980s. Routine functions such as sending memos can instead be done by email. Workers can research information from the Internet with a click of the button. The importance of computers in business also has many other positive benefits in the work force. Computers also help the businessman save time. For example, a businessman can write a report, do a spell check, edit it and distribute the report in just a few hours–even long distance. Previously, companies used typewriters for reports where redactions were made on various pages. These pages then needed to be retyped until the report was error free. Managers then needed to copy the reports and mail them to employees in different cities. Consequently, the report writing process took much longer with a typewriter than a computer. Also, utility and cable companies can pinpoint a customer’s problems more readily with computers.
It is no wonder, insecure, that many managers, planners’ administrators, educationists, researchers, chief executives and business men now feel an urgent need for computer in their respective organization. In the save view, the objectives of this project is to incorporate computer into the processing of information at LEADMART STORES. Computerization of the store can remove wastage, guarantee quick service at service points of vital importance to the public and improve productivity. Such computerization effort often costs for less than the money and time it will save both the public and the organization.
Every organization (LEADMART STORES) encounter numerous problems, which include keeping goods, maintaining, checking and having goods account records for goods in stock.
Despite the good maintenance in the manual stock control system at LEADMART STORES, there will arise great inefficiency in its accounting system, as well as its record updating system.
However, the main aim of this study is to incorporate computer into the daily operations of the store with reference to mainly it’s accounting system, as well as its stock control system and its day to day commercial operations.
With introduction and application of computer into the operations of the STORE the organization will be able to improve dramatically on its daily information and accounting system.
The above problems discovered therefore prompted to a software design to be able to add to existing stock and delete goods in stock collectively referred to as updating, as well as producing an accurate accounting system for the STORE.
The purpose of this study is to design and implement a system that will eliminate the above problems such as misplacement of vital information, documents, records, duplications of efforts etc.
A computerized accounting system and organization allows the user to enter the transaction into the program at once, and all accounts are updated as necessary without delay and unexpected mistakes of records and transactions.
The aims and objectives of this project report is to study how the organization (LEADMART STORES) operational aims and other activities and how they are executed.
It saves time;in cases where a shop maintains all data manually, its manager must reconcile each sales receipt with every piece of physical inventory. Depending on the size of the establishment and how many different products are sold, this can be a daunting and time consuming task.
To ensure accuracy in the inventory system;when an inventory list is maintained by hand, the margin of error widens with each update. If one mathematical calculation is wrong or one typo is made, disaster may occur. For instance, if a clerk accidentally adds a zero to the end of a purchase order, a business could potentially end up paying for 10,000 units of merchandise as opposed to the 1,000 that is actually needed.
In areas of misplacement of vital documents a computer will be used to record, store, retrieval of large volume of documents; which will reduce the duplications efforts due to in-accuracy in activities and time taken in locating of files when it is required for processing.
The researcher is limited to the study of computerized price determining system (LEADMART STORES).
The study is also limited to the limitation that is being acquired from (LEAMART STORES), more information were gathered from the write-ups of the existing system of back-up the study and design of the new system.
One to lack of time and resources, the study is limited to certain area concerning problems being encountered and gathering of information’s on how goods are being sold or kept and how to process them using a computer.
This research was carried out with the assumption of the combusting that might arise in tackling stocks problem and computation inefficiencies.
For this purpose, the assumption reached was to design and implement a price determining software package that will eliminate and arrest any difficulties that involved in manual computation.
ALGORITHM: – A logical of instructions, which are carried out in a fixed order to find the solution to a problem.
COMPILER: A system software package that converts a problem oriented language to the language a computer understands.
COMPUTER: An electronic data processing machine which can store and process information at very high speeds.
COMPUTERIZATION: The use of computer to control an operation or system.
DATA: These are units of observation which do not curvy any meaning
DOS: An operating system that uses disk devices for permanent storage.
FLOWCHART: A diagram in which particular shapes and connecting lines are used for showing how each particular action in a system is connected with one another.
INFORMATION: Consists of facts resulting from processed data, providing knowledge relating to events or situation.
PASSWORD: A secret word, which one has to know before he can access to a particular system.
PROGRAM: Set of instruction, which is used to solve a problem.
SOFTWARE PACKAGE: A phrase used to define one or more programs or set of instructions.[email protected][email protected]