I.C.T. coursework on Computer games retail store.

Authors Avatar

 

CONTENTS

DESCRIPTION                                                        PAGE

Problem Specification

The organisation that I have chosen to base my work on is a computer games retail store.  It is called 3G, a small shop which just opened up recently under a very low budget.  However, they have made funds available to develop their system, as currently they have no I.C.T system whatsoever.  They do all of their receipts, stock taking and stock ordering by writing it each time it is needed.  They have asked for all new stock to be brought in, hardware and software, so everything will be compatible and should be ready for use in little to no time.  3G games buy all of its products (hardware and software) from the supplier and accept cash and/or debit cards.  Every week, the employees need to count the stock and cross-reference it with the receipts, checking if anything is lost or stolen, and then re-ordering any goods.

        In the current system, there are several different users with different access rights.  The manager has unlimited access to all parts of the system, and is able to edit, add or delete information.  The stock manager can also add, delete or edit information, whilst the workers cannot do any of this, they can only add information into the system.  There is not much knowledge within the store as it lacks the sufficient equipment.  Currently, there are no help resources for anybody to use since it is unnecessary, but there will be an implementation created to give help to who ever needs it.  

        I interviewed the manager of the store, Mr.G Grewal and asked him a series of questions about his current system and the system he wishes to install into his shop.  I also made a questionnaire for the employees, asking them what they think would help run the store more efficiently.

        Their current system is too slow, and its distracting the customers away from 3G.  The system is not always accurate, and it is not time-efficient.  In addition, with the amount of time it takes for the employees to order and count the stock, they must be paid much more than need be.  Another major problem of their system is the protection of the system; anybody could get to the receipts/reports/order forms, which is a great risk to the financial status of the company.

Feasibility Study

During this project, I will be reporting to the owner of the shop, Mr.G Grewal.  In the next 3 months, I plan to develop an access system database, which the shop can use, including tables, forms, queries and reports.  The shop is open from 9 o’clock in the morning until 5 o’clock in the afternoon, so there is 8 hours during the day that I can work on this.  There will be around 3-4 thousand pounds needed for this, to buy new software, hardware and creating a network configuration.  In addition, EPoS systems will be bought to abolish the manual stock check in store.  

        To create the database, I will need information about the sales, the suppliers, the employees and the products in store to complete tables.  From these tables, I will be able to produce forms, reports and queries (where the user can sort a column in a specific order).

Join now!

Facilities

Computers To Be Used:

Quantity: 4

Specifications:

  • 120gb storage (to store large databases, accounts, other use).
  • Intel Pentium 4 processor (to make use of high speed processing)
  • DVD/CD-RW, floppy and hard disk drives (used for storage, transferring and storing data outside the computer).
  • Pentium operating system (as it gives higher restriction and access levels, and it gives the server option across many computers).
  • 17” TFT screen (gives clear visibility to those with poor eyesight).
  • An ADSL modem with broadband Internet (to connect and communicate with other companies and suppliers at high speeds.
  • ...

This is a preview of the whole essay