Bilawal - Generation

GENERATION ELECTRONIC

INTRODUCTION

Generation is a gaming organization which was introduced in 2000. Since 2000, the store has been specialized in selling highly sophisticated game. The company is a sole tradership. The owner of the generation game shop is Mohammed Ahmed. The shop is located in hall road in Lahore. The shop specializes in selling highly sophisticated games, which come under the category of action, sports, adventure, etc. They run on unique game consoles such as Xbox 360 by Microsoft and Playstation by Sony. The Shop is also equipped with the high tech gaming equipment which allows buyers to have a first hand experience of the game before purchase. The shop also sells computer hardware devices such as USB and speakers. It also provides customers with all the accessories needed to run a game console and also sells DVD and blue ray games. The shop also provides services such as repair, replacement and even provides a short term credit to its regular customers.

The most crucial problem the company is facing at the moment is that it is keeping its records on registers which makes it exceedingly difficult for the shop to keep a record of the employees payroll, business transactions, record of games and accessories and various computer hardware devices. And so after the development of information technology the shop found it even hard to keep up with a manual information system and as a result the owner of the shop entrusted upon me the duty of fixing the problem and computerizing their database.







AIMS

My aim is to computerize the business transactions which involves from the buying and selling of the games and accessories. Also my aim will be to keep a detailed record in form of a database which gives information about the inventories in store.

OBJECTIVES

 To make an efficient system which will result in the selling of more products
 To create a database management system which would increase the security of the system by ID and password
 To create a data validation process which would automatically correct any errors before the data is entered (Data validation does not ACCEPT wrong data.. it does NOT correct.)
 To create the debtors and creditors table separately to improve financial management
 To keep a record of spoilt or destroyed goods
 Improve financial management by developing a database management system, to assist inputs and outputs in carrying routine tasks (Rephrased)
 Easily access of reports so that the owner can check on the running of the business is successful or not (Not access, GENERATION of reports is what you should aim at..)
 Example: Easy generation of reports so that the owner can check on the running of the business is successful or not
 To improve records of the employees and their payrolls
 To improve inventory control system by developing an optimal information system, which is easily updated and managed on day to day basis
 To create a back up of data to secure work
 To make the system user friendly
 to create a table which shows the goods to be bought from the suppliers (Can be rephrased as develop a separate form to manage minimum quantity on shelf)