A Database 2 Project Presented to
The Faculty of the College of Engineering and Computer Studies
St. Michael’s College
Iligan City
In partial fulfilment of the requirements
For the Degree of Bachelor Science
Major in Information Technology
Ben Bryan Abijay
Jamil A. Calandada
October 2015
CHAPTER 1
1.1 INTRODUCTION
Nowadays, using computers in companies and other establishments in transacting with their clients is a big factor. Some of the companies or stores are still using the manual process in running business. By using the manual way, it consumes more time and energy and susceptible to errors in finishing work. So, companies now are making system to be computerized because in this way it can minimize time and efforts consumed by using manual system. One way to save time and effort is to start using Sales and Inventory System.
In Penshoppe’s Sales and Inventory System, a sale refers to the exchange of product or services for an amount of money or its equivalent while making Inventory in a business is a total amount of goods and the act of counting them. Inventory is merchandise in-stock and on hand, also known as stock. Inventory is basically the total amount of goods and materials held in stock by a factory, store and other business. In its simplest sense it can be done manually by counting at the end of each day. In this way it is possible to keep a record of the goods coming in to the business and goods being sod. A company owner must know the precise number of items in their storage areas in order to place and control losses. Computerizing both Sales and Inventory System will make and easier and faster transaction with the customers as well as monitoring the stocks of the product.
1.2 STATEMENT OF THE PROBLEM
The purpose of this project is to check and track inventory sales, orders and deliveries. The researchers aim to help in improving the Penshoppe’s Inventory system by fitting solutions to the problems