• 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
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  • Level: GCSE
  • Subject: ICT
  • Word count: 2163

Designing a database for a supermarket. The current main problem is that the manager or the employees arent getting to know when the food is going stale or is running out of date. Im being asked to create or to find some kind of solution to solve th

Extracts from this document...


SPAR INDEX 2 IDENTIFY 3 1,1 The problem and how I discovered it- 3 1,2 The Business- 3 1,3 The real User- 4 1,4 The current problem and inefficient- 4 1,5 The manual and PC way- 5 1,6 Objectives- 5 ANALYSE 6 2,1 Hardware- 6 2,2 Software- 6 2,3 Data Input- 6 2,4 Data processing- 8 2,6 back up and security- 11 IMPLEMENTATION 13 13 4,1 3 to 5 printouts with errors- 13 4,2 Screenshots 14 17 18 4,3 Test Results 18 4,4 Objectives 20 IDENTIFY 1,1 The problem and how I discovered it- I discovered the problem when I was buying in this standard supermarket and I saw that some of the products where expired and were stale. I also noticed that some of the buyers or consumers were taking this product without knowing the consequences of them on their body. This is a picture of the supermarket. 1,2 The Business- This business is of a supermarket which is located in Alejandra del Castillo in San Fernando in the south of the Island of Gran Canaria. I was doing a survey on the supermarkets as a consumer when I discovered that some of the products were stale. I told the manager about the problem they asked me for help. ...read more.


Normally a word document of 10 -12 pages with three to four coloured pictures would weigh 294 KB (302.026 bytes), this means you would be able to save three thousand more files like this on a one gigabyte pendrive. Yes, I will set up passwords to my document incase a hacker or spammer brakes in and steals my data, this way I will be sure to have a unique solution to the problem. I can set passwords to documents by going on Tools>Options>Security and set up the password. The Data Protection Act means the right to protect your own data, this is a part of legislation. We might use this because we need to consider the rights we have to protect our own typed data. IMPLEMENTATION 4,1 3 to 5 printouts with errors- -Error 1- The first error committed was that some of the pictures of the products are missing. This could lead to confusion and would seem difficult to identify the product. -Error 2- The second error was that some of the dates aren't in the correct format. The Dash to separate the day from the month and year are missing. ...read more.


I did this by the 'hyperlink' option under the insert option. I have included product images but they have been collected from the internet and aren't accurate and therefore not reliable. 5,2 Test- 1. Do you think the objective number 1 has been accomplished properly? vv 2.Is the solution correct? 3.Is the layout or format correct? 4.Do you think the objectives could be improved? Or if others could be added and which? 5. Is the idea of the images correct? 6.Would it be a good idea to highlight formulas? 7.Which of the objectives do you think are invalid? 8. Which of the methods used to accomplish objectives could be improved? 9.Do you accept that it would be a better idea to create a graph rather than a table showing the products expired? 10. Do you think that the images should be taken of the actual product and not the internet? 5,3 I could improve... I think that if I took the actual photo of the product it would be more reliable as it is taken of the actual article and maybe the internet gives the incorrect picture which could lead to confusion and problems. It would also be better if I check the spelling using a dictionary rather that the computer's dictionary as word feed into it might be incorrect and mean something else. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Marked by a teacher

    Evaluation of my ICT Database, Spreadsheet and Newsletter

    3 star(s)

    I have displayed the prices in an appropriate manner, with techniques such as bold, underlining. I think the theme I used for my newsletter fits well with the Holiday theme because it?s not dark. My newsletter is more appealing to Adults, because of the cruise.

  2. How will ICT help to solve the problem?

    Member Database and Application Form - A member database is created on Microsoft Access and is extremely useful to supermarkets. Twinkle Berries supermarket could contact its members through means of flyers etc on special offers or new products, which would be of use or interest to their members.

  1. ICT and airport and supermarket

    The luggage has to go with the passenger at the same time. Bar code is used which are placed on the bags allow the staff to figure out that which bag will go on which flight. The barcode includes the senders identity, the recipients identity and the date and time.

  2. Write up an Analysis for an ICT solution for an organisation that has a ...

    the tax people, as producing this by hand is time consuming and prone to inaccuracy and error.


    Fade In Timing 2 Textbox (Data Describing Company Background) Fade In Timing n/a Picture 2 (BMW Logo) Fade Timing n/a Picture 1 (Creator Of System) Fade Timing 2 Table Expand Timing 1 Series Slide 2: 1 Series Hatchback Order Object Animation Timing or mouse click 1 Header (Picture)

  2. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    These include; renting out games, putting returned games backs and checking for any overdue games. To rent a game out at the moment this is what the staff/manager has to do. Inside every game cover there will be a piece of paper stuck on it with a red envelope.

  1. I am now going to analyse my clients current system in order to get ...

    They can also highlight the main problems and why that is so. * Everyone can give his or her opinion without fear of reprimand. Disadvantages: * They might not say anything bad about their colleagues in case they upset them and therefore they are not wholly truthful.

  2. Ict Powerpoint Coursework

    Photoshop costs quite a lot of money; this isn't such a big problem as the quality of the software just pas for itself. The advantages are you could basically edit anything which is really good as Mr Akram is trying to find a good way to present the promotions etc...

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