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

    IEEE 802.3 This standard defines the MAC layer for bus network using CSMA/CD. It is considered as a LAN technology and uses very few WAN applications. Connections between node and infrastructure are made using various fibre cable connecting switches and hubs together.

  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. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    Some examples might help to explain what analogue and digital mean in technology. A simple example of analogue and digital technology Clocks are examples of analogue and digital technology. An analogue clock face can display the time without numbers. The hands keep moving all the time and they continue to rotate, just like the earth around the sun.

  2. I have been given the task to design a database for a company called ...

    * Data on the parcel which the customer is sending, this will include, parcel ID, width of parcel, length of parcel, height of parcel, total dimensions, weight and price which will be calculated by the computer. * Data on the customer, this will include, customer ID, customer's title, customer's surname,

  1. Spare Parts Database Project

    OK 3 Click on 'Exit' The program must close. OK Module: Main Menu TEST NO. TEST EXPECTED RESULT REMARKS 1 Click on 'Customer File' command button. Customer File must appear on the screen. OK 2 Click on 'Item File' command button. Item File must appear on the screen. OK 3 Click on 'Transaction File' command button.

  2. What is transaction processing?

    They are the things that actually hold the data. A database cannot exist without there being a table as a database is meaningless without data. A record is a complete set of data about one item in the table, for example in a table containing names and addresses a record would be all the information relating to one person.

  1. Purposes and Features of a Relational Database

    do and the work on the actual data can be started quicker. Discover Data Discrepancy A database has validation rules in its tables. This means that data will correct, but also two records can be pulled up next to each other and double checked, in case of fraud and incorrect details.

  2. Smart Card System

    The following characteristics differentiate one LAN from another: * Topology: The geometric arrangement of devices on the network. For example, devices can be arranged in a ring or in a straight line. * Protocols: The rules and encoding specifications for sending data.

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