• 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)

    It is restricted to networks which are carrying variable-size packets. It works with to lower layer of the OSI model. The data link layer and the physical layer. It further splits the data link layer into Logical Link Control and Media Access Control.

  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. System Analysis The aim of the Jewellery store system is to make the work ...

    While the two concepts are closely related, and have overlapping goals, a domain model is more focused on capturing the concepts in the problem domain rather than the structure of the data associated with that domain. Data flow models (DFM)

  2. Purposes and Features of a Relational Database

    For example an onine shop might have a customer table. This would have one customer per record, and each piece of data defined about said customer would be defined by the field. Here is an example. Each Row is a record (except the top one which are the field identifyers.

  1. Ways of Promoting a Website

    Nothing is downloaded to the Web browser so server side technologies do not require a plug-in. In contrast to this it is important we no of another term; C.G.I (Common gateway interface) - These scripts are server-side because they run on the Web server.

  2. Basic Database Building

    Facilities Member ID Long Integer 4 AllowZeroLength: False Attributes: Fixed Size CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DecimalPlaces: Auto DisplayControl: Text Box OrdinalPosition: 1 Required: False SourceField: Member ID SourceTable: Facilities Member Name Text 50 AllowZeroLength: True Attributes: Variable Length CollatingOrder: General ColumnHidden: False ColumnOrder: Default

  1. You have been asked to create a database to handle various account combinations of ...

    Be capable of manipulation by computer Drawing models is essentially an iterative process a model is produced, shown to the users then redrawn as many times as is necessary until the users are happy with it. Using a model that can be manipulated by computer cuts out the drudgery of

  2. Smart Card System

    1.3.1. File Transfer Protocol The File Transfer Protocol (FTP) provides the basic elements of file sharing between hosts. FTP uses TCP to create a virtual connection for control information and then creates a separate TCP connection for data transfers. The control connection uses an image of the TELNET protocol to exchange commands and messages between hosts.

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