• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

A Relational Database system to assist the stock control operation of Rai's Newsagents.

Extracts from this document...

Introduction

1 Title: A Relational Database system to assist the stock control operation of Rai's Newsagents. 1.1 Keywords: The keyboards from the title are; Database, Stock Control and Newsagents. 2 Problem definition: 2.1 The problem is that the shop owner does not know the quantities and value of the stock on the selves and in the storeroom. As a result of this the owner does not have the accurate numbers of how much stock is needed. This results in the owner (Mr Khan) running out of stock and other items when he could have sold more if he had more. 2.1.1. When making an order to the wholesalers Mr Khan has to phone and make the orders manually. This sometimes takes a lot of time and can result in wrong orders or the wrong stock being ordered. Mr Khan has then got to send the incorrect stock back to the wholesalers and wait longer for the correct stock. This can cause losing valuable customers as they may have orders for certain items, which they have especially reserved. 3 Aims: * To produce a relational database which will be able to order stock for Mr Khan and in the correct numbers. ...read more.

Middle

It is customary that Mr Khan has complete control over the order of confectionary items as well as newspaper and magazine deliveries, information of such consistent item quantities are difficult to get hold of. The nearest competitor to Rai's Newsagent is within a 500-metre radius, and demand for items among local residents is high. Mr Khan's newsagent is situated on a main road in Ealing, West London. This newsagent sells a variety of products that range from Tobacco, confectionery and stationery. The small organisation has formed a relatively good relationship with its local customers. The majority of sales revenue is gained from the counter sales. 7 Research method: In order to realize and implement a relational database to ease the stock control of items such as confectionary and stationary, attention must be given to the user requirements. Therefore I will interview certain representatives from Rai's Newsagents and will try to discover the user's needs. Due to the user's I.T incompetence, research into user-friendly interfaces and how this can be accomplished within a database environment will also be conducted. A variety of database software will have to be consulted before deciding on the correct environment that would help satisfy user requirements. ...read more.

Conclusion

11 Resources The resources I will need for my system will be an up-to-date computer with the latest edition of Microsoft Windows XP. This will be necessary because Windows XP is very basic to use and very reliable to understand. Windows XP is also a plug and play operating system, which basically means that any hardware attached to its USB ports will instantly be recognised by the system. This means the owner will be able to back up all the relevant information on a storage device such as a portable hard drive which look like lipsticks. The software package that will be installed with the system will be Microsoft Office XP. I will be using this package as this offers the best database developer in Access. With Access XP the owner will be able to: * Produce the correct tables, which will be able to store information on stock * Produce the correct forms for deliveries * Produce the correct Reports * Produce the correct Queries, which will show which items need to be ordered With Microsoft Office the owner will also be able to use its other features and resources such as Word and Excel. 12 Reference List: Broad, (2004), http://www.businesslink.gov.uk/bdotg/action/detail;jsession. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Management & Manipulation of Information essays

  1. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    Nintendo's colourful, compact machine does just one thing: games. The idea is that fans will flock to a console that's not loaded with gimmicks they'll probably never use. Nintendo is moving away from the prevailing trend of increasingly complex games to "simple and fun" entertainment games that are both easy to play and cheaper for designers to write.

  2. Designing a booking system for an Estate Agent.

    They will require printed appointment slips when they come to arrange appointments in the office in person. This would mean that the system would need to be able to produce appointment slips in form by creating forms using access. The appointment slip should include the time and date of appointment,

  1. Standard Operating Procedures (Sop) recruitment policies and procedures.

    Post announcement and make sufficient copies for public distribution. 5. Make available sufficient amount of study guides for the position. 6. Answer customer inquiries regarding announcement, testing components, and study guides. Evaluation of Applications: 1. Adhere to confidentiality and security measures by always keeping applications and candidate documents in a secure area.

  2. Planning a payroll system for a martial arts school.

    * The program should use a menu system with three options of: o Entering and processing an employee's details. o The pay slips details with the ability to print. o Exiting the system. * The operator need not be computer literate so it should be easy to enter with suitable validation procedures and be as simple as possible.

  1. Beanie Project.

    o Because Word is not a database program as such, it does not group together certain chosen data. It also does not support data entries in the way of separate, accessible pages. Microsoft Excel: * Good Points: o Excel has great functions for user data input.

  2. The purpose of this document is to provide a design for an electronic payment ...

    UK acquiring banks for Visa, Mastercard, Switch, Solo, Delta, JCB, American Express and Diners Club. From: http://www.secpay.com SEG 3 This is the group who produced the original online payment system. There alias is S3G. S3G See above. UML A non-proprietary, third generation modelling language.

  1. The application to be researched is a small company called RS EQUIPMENT. The company ...

    VIRUSES All terminals on the network have an anti-virus application installed namely Norton Anti-Virus, which is launched on start-up. This software was chosen because of its ability to perform regular checks when files have been downloaded or opened in other applications.

  2. ICT Solutions for people with Special Needs.

    facilities (including transport), adaptations or special equipment needs in the home or workplace to help with convenience or for safety, holidays, meals and telephone (and special equipment to use it if needed). Disability Discrimination Act 1995 (Conclusions) The Disability Discrimination Act 1995 introduces rights for Visually impaired people in the areas of employment.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work