• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

William Smith is the owner of a small corner shop in Wakefield. He has little experience with computers - He can use Microsoft Word to type up an article, and he can play games as well.

Extracts from this document...

Introduction

Introduction William Smith is the owner of a small corner shop in Wakefield. He has little experience with computers - He can use Microsoft Word to type up an article, and he can play games as well. He once ran the London Marathon dressed as Tony the Tiger. His main hobby is visiting restaurants with his friends. William also has a rare condition - basically he has a bad short-term memory. His favourite band is 'The Pet Shop Boys'. Mr. Smith has many friends, and enjoys taking his friends out to many restaurants - It's kind of a hobby among then. However, some of his friends don't like certain foods, some are allergic to certain foods, some don't earn enough money to be able to afford certain restaurants, and they all work different hours, therefore Mr. Smith has problems in deciding who would be most appropriate to take. He also needs the phone numbers and addresses of his friends so he can easily get in touch with them. There are also many, many restaurants in the Wakefield & Leeds vicinity, and William cannot keep track of which type of food each restaurant specifies in. ...read more.

Middle

friend and all his/her attributes * Delete a friend * Easily specify a time, type of food, price range and type of restaurant The application should then do the following (Cross-Referencing): * Eliminate any restaurants that are not open or will not accept a reservation at the specified time. * Eliminate any restaurants that are too expensive for the specified price range * Eliminate any restaurants that do not fit the specified 'type' of restaurant. * Eliminate any restaurants that do not fit the specified 'food type' * Eliminate any friends that are allergic or do not like the specified 'food type' * Eliminate any friends that are not available at the specified time * Eliminate any friends that do not enjoy the particular 'type' of restaurant specified * Eliminate any friends the can not afford the specified 'restaurant price range' The application should then: * Produce a document or report showing the names, addresses and telephone numbers of all the Restaurants and Friends that were not eliminated, also detailing which friends are the most suitable. * This document/report should be easily printable. What program should be used to create the application? ...read more.

Conclusion

As I will be developing this database on different computers (At school, and at home), Access will be ideal. The final advantage that access has, is that it is easy to make a backup of a database - Simply copy the file, because there is, after all, only one file that holds the entire database, instead of several. By no means is Access perfect though - It has many disadvantages. For a start, it is limited to small databases, because Access was designed to efficiently manage relatively small numbers of database records. The file size limit is 2gb, but I don't think the database that Mr. Smith will be using will ever reach that capacity. Also, because the database is stored in only one file, this means that it can be slow at bringing up results when many people are accessing it at the same time, via a network for example. Again, this won't be a problem for Mr. Smith, as he will be the only user. Access is definitely the relational database management system to use. How will the data be sorted???? Start to produce ideas for your table. ICT Project - James Ellison - 12AR - Page 1 ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Marked by a teacher

    Hardware and Network issues in e-commerce

    5 star(s)

    The development of a Public Key Infrastructure (PKI) enables the four critical aspects of security- privacy, authentication, integrity and non-repudiation. For added security the PKI is facilitated by the provision of security certificates, registration and validation systems. The combination of these facilities help to ensure tight security for a majority of m-commerce transactions.

  2. Marked by a teacher

    The Internet is an important part of our everyday lives however it is not ...

    4 star(s)

    Education and work can be restructured to teach and propagate the skills of concentration and focus.

  1. Standard Operating Procedures (Sop) recruitment policies and procedures.

    Generate the Certification List � The certification menu is in the Recruitment menu, the Certification List Sub-Menu, and Merge Eligible List Sub-Menu. � Type in the Certification ID# and TAB. � Type in the date, the amount of vacancies and "2" in the "Status" field and also type in

  2. Home Office LTD company. Database

    Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("B14").Select Sheets("Order form").Select Range("B5").Select Application.CutCopyMode = False Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("C14").Select Sheets("Order form").Select Range("B6").Select Application.CutCopyMode = False Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("D14").Select Sheets("Order form").Select Range("B7").Select Application.CutCopyMode = False Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("E14").Select Sheets("Order form").Select Range("B8").Select Application.CutCopyMode = False Selection.Copy Sheets("Cust_datab").Select ActiveSheet.Paste Range("F14").Select Sheets("Order form").Select Range("B9").Select Application.CutCopyMode = False

  1. ICT Solutions for people with Special Needs.

    Disability Discrimination Act 1995 The Disability Discrimination Act 1995 introduces rights for Visually impaired people in the areas of employment; getting goods and services; buying or renting property and access to goods and services. It would give people with visual impairments new rights in three main areas: 1. Employment 2.

  2. Designing a booking system for an Estate Agent.

    How do you organise a client viewing? The client calls us up and asks to view a property. We ask them which specific type of property they are looking for, the price range and the times that they are available.

  1. Background and investigation for designing a database for a DVD rental shop.

    Ashley currently selects all the DVDs that need to be returned, this means he will be using the systems quires to select DVDs to return back to choice UK. Anything that that needs to be removed or deleted has to be authorised by MR Bradshaw, in the proposed system only Mr.

  2. Customer experience

    The customer has to be looked after from when the look at the website until the final payment has been paid. WWE Euroshops' method of doing this is simple; the way in which they look after the customer before purchase is making the website easy to use, and purchasing is

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