• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21

supermarket database-computer coursework

Extracts from this document...


A-LEVEL COMPUTER EXAM COURSEWORK SUPERMARKET SYSTEM Content 1.Indroduction 2.Problem anlaysis and specififcation 2.1 Problem of the old system 3.Solution of the problem 3.1 Introduction of the new system 3.2 advantage of the new system 4.Design of the system 4.1 software consideration 4.2 hardware consideration 5. Online system Introduction There are many supermarkets around us, but there do you know how it works. In this coursework., we will anyalsis the problem of the old supermarket system and how to solve this problem. Besides, in this coursework, it will introduce a new supermarket system, introduce its advantage, how to set up, how to use it and what is its' advantages. Old supermarket system Disadvantage: piles of papers are used to keep the records it is hard to back up the records, if you really do so, the cost of the ink and the papers can make you bankrupt the payments are calculated by men, if your mathematics is poor, you will bankrupt again you need to spend nights after nights to turn the pages by your hands in order to search the data of the customers and supplier snail mail is used, which means time and money is wasted your customers cannot immediately get the most update news of your product, simply the million-dollar contract will fly to other companies the piles of paper won't remind you when your product is expired, you need to search through the papers it is not easy to comunicate to your branch stores. ...read more.


The information that is contained includes: * What tables and column are presented. * The names of the current tables and columns. * Any validations on the values of certain columns. Data Item Description Data Type Validation * item description The description of the product Text * bar code The bar code of a product Text Letters only * item code The code of a product Text Letters only * item location in store The location of the product in the supermarket Text Letters only * price The price of a product Numbers * maximum (amount to order) The number of product in the supermarket Numbers * current stock Whether the book is hardback or paperback Text Letters only * date ordered The order of the product by the customer Number * date received The order of the product ordered by the customers Number After create the above table, by using the "Microsoft Access", a new table will be created to input the data of each product. Besides, to show the out and in of each product, by using the "Microsoft Access", a report can be created. Shopping from the Internet Some customers will order products from the internet. Therefore a website should be set up for their confident. In order to get associate with the system, some more items are needed to create in order to record the information of each customer. ...read more.


If some product has been ordered, and it takes a while for that product to arrive, we do not want the same product ordered several days in a row. The system must contain some sort of list of items on order. As the items received come in, they should be taken off this list. The objectives of the proposed system are: * To make buying things an easier process. * To produce reports on overdue books. * To check which products are currently available in the supermarket. * For the staff to be able to obtain information of who has ordered a particular product. * To keep a record of customers and their details. * To be able to add, edit or deleted details concerning the customers * For each customer to have a unique id in case two people have the same name * For each product have a unique id * The system should only allow authorised people to the data. Problem of this system When using the "Microsoft Access" to setup the programme, it will take a long time to set up. As it needs to create a lot of tables, besides, each table is linked together and totally linked to the server to the internet. When linked to the internet,it is difficult to get a good domain name. Also, it is easily linked wrong. Solution of the problem To solve the problem * First, set up the system more carefully. * Try to buy a good Domain ...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 Computer Science 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 Computer Science essays

  1. Peer reviewed

    Principles of Computer Networks

    3 star(s)

    Type 2 is a connection-oriented operational mode. It uses sequence numbering similar to the TCP/IP guarantee it guarantees that the order they are sent in is the order they receive it in and no frames are lost. Finally Type 3 is an acknowledged connectionless service which only supports communication to single destination or point-to-point communication.

  2. Visual basic

    that are needed to store data depends on the type. Data Errors * Storing information in an incorrect data type can result in both logical (e.g., data loss through truncation) and runtime (e.g., type mismatch) errors. * The Val function converts text to numbers (double)

  1. What is transaction processing?

    One of the disadvantages of Email is if the recipients address has been incorrectly typed but is a recognised Email address, then the required information which could have been urgent will not get to the correct person. This could also lead to the problem of security of company or personal data.

  2. Flexible Architectures in Communication Security Application

    We detail the design and implementation of the CryptoManiac processor and analyze its performance using architectural and physical design models. My research contribution to this work was the design, implementation, and evaluation of the CryptoManaic co-processor; this work was published in [42].

  1. Spare Parts Database Project

    New data will be added to the database at a convenient time, possibly at the end of the week. The procedure that the user will fellow is described in the design section. 4.2 TABLES AND RELATIONSHIPS Tables and relationships were set up as specified in the design section.

  2. Purposes and Features of a Relational Database

    This means that a company can not only keep track of details, but also add, modify and remove them, in a user friendly, easy to use manor. This also prevents data redundancy and lost/ disorganised data, because everything is completed in real time.

  1. Ways of Promoting a Website

    Internet Based Media Many people use the internet today for viewing media and listening to music. You tube and such sites are all big in this field and therefore would be ideal places to advertise my website. Many people visit these sites on a daily basis and for many different reasons.

  2. Basic Database Building

    So in my case the most relevant information that needed charting was the equipment that had been used, this could actually however have been on many things, * Chart on peoples ages * Chart on what membership type people have * Chart on location lived All of these would have

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