• 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 1 is an unacknowledged connectionless mode which allows frames to be sent o signal destination also known as point-to-point or unicast transfer. It allows multiple nodes on the same network known as multicast and finally allows sending it to all nodes on the network known as broadcast.

  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 I designed in order to produce a promotion package for her newly formed ...

    If you wish to search for people living on Newman Street and Milton Street, the user of my system will do the following search: newman OR milton As a result of the search the following data will be shown: - 7 UDDIN AZIR M 24/10/84 WALSALL 5 Milton Street Cash

  2. Purposes and Features of a Relational Database

    Also if duplicate records are taken for whatever reason, these can be detected and eradicated, or adequately marked as duplicate. If the database is designed correctly these records can be automatically pulled out. Features Tables, Records & Fields The information stored in a database is recorded into tables.

  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

    Total Facilities - This is used for showing the total uses in general for all users of the sports facilities All the reports can be seen in the screen shots below; Data Dictionary Ricki Lambert 16 May 2008 Table: Facilities Page: 1 Properties DateCreated: 09/05/2008 10:10:02 DefaultView: Datasheet GUID: {guid

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

    Capture the essentials Many models consist of documentation for businesses, such as invoices, orders, receipts. If it only consisted of documents, what would happen if the business changes? Most businesses today are dynamic - meaning that they have to respond to increasing competition and to he changes in the environment around them.

  2. Smart Card System

    damaged in transmit, or it could send a message to the wrong place. It is both more efficient and safer to have TCP compute a separate checksum for the TCP header and data. IP addresses are used to deliver packets of data across a network and have what is termed end-to-end significance.

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