• 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 could also add in other sheets to the spreadsheet I have already, like a sheet displaying the discounts available of each holiday or a sheet showing the cost of a holiday to each destination for one adult, two adults, three adults etc.

  2. Producing documents for a company. Spreadsheet, Invoice and Website.

    This will be used for the invoice. And finally the poster will be used for advertisement and notifications. Data validation When we don't want people to enter invalid data. We use data validation that restricts the data that can be entered. E.g. the product reference number, to make sure that the user selects a valid reference number

  1. Smarts Leisure Park Database Booking System

    now work and I need to add a final paragraph which will explain all of what the report is about. To do this I used a label. I have now finished my customer report and I have saved it as "rptCustomer" Now that I have created my first report I can now create the Bookings report.

  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. Ict Powerpoint Coursework

    This graphics card would help the PowerPoint Presentation look at its best and also perform at its best. The highest quality images and audio, video, flash files would be able to play with a huge amount of 3000mb rendered memory for all needs.

  2. How will ICT help to solve the problem?

    on a side of a bus, there is no way of controlling who sees this. This is not necessarily a bad thing as then the problem at hand is therefore being solved, as news of the supermarket is being spread and people are hearing about this exciting new development.

  1. Solving the reprographics problem at St.Mary's College.

    firstly the size of the run and secondly the quantity of the paper. Additional charges will be paid towards jobs such as front covers, stapled work and side/comb binders, which makes the current system complicated but for a computerised system it would be much easier.

  2. Computing Project – Designing a Ticketing System for a Cinema.

    The data stores Screen + film, Date + Time, Ticket Price, and Seats taken are where Data is retrieved from. These data stores have had data entered into them before any ticket request has been undertaken, with the exception of date + time where this is more like a clock.

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