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

ICT database newer identify

Extracts from this document...


Background to the problem Mr Something runs a small business called A Chip off The Old Block-Bluster. Mr Something is the makes of Blockbusters son. He has only left him a little bit of inheritance and wanted him to produce a business that was just as good as his. He currently has a shop in slough High Street. He only gets a few customers a day. He keeps track of people's record manually and would like to use his father's money to set up an electronic system that only requires a few manual entries. The Current System Mr Something currently uses cards to manage his business. He has 2 types of cards. 1 card is his business card to hand out to people to show where his shop is, his name, telephone, his email and his fax. The other type of card is a customer card. The customer card has the shop logo on it and the customers name on it. It is a card made out of card and is laminated to protect it from damage. ...read more.


If it continues then the police will be involved. Mr Something calls it the record sheet. The record sheets are stored in a briefcase that is locked and is stored in a cupboard that is overhead that is also locked. This reduces the chances of burglars getting their hands on the customer's details. Problems with the system The current problems with the system are: * It takes time for Mr Something to enter in the customers details onto the record sheet. * The laminated cards that he gives to his customers are easily damaged by peeling away the laminated layer * The cleaning liquid is expensive to buy and therefore makes little profit * The manual methods take very long which hold up the customer. The end user's requests The end user would like: * a computerised system * a homepage that can navigate through the whole system easily * searches that can be easily used * a window that can search through records * something that can add files to the records file * something that can show the charges of overdue DVDs Possible Solutions A non-ICT solution could be to use cards. ...read more.


Each DVD would have to be repeated every time it was lent. This would be quite frustrating and time consuming. Using a relational database seems like the best solution for the DVD rental. It can be used to store lots of data and reduce the amount of repetition of it. Queries can be used to extract data quickly and easily. This could be used to find overdue DVDs, solving the problem of undetected overdue fines. Separate tables can be made easily, which can be linked in a relationship. Wizards can be used to make queries and reports quickly without mistakes. Databases also contain validation tools which stop input errors. Length check can be used on the fields to stop mistakes. Primary keys can be made to number DVDs and members. Objectives The system should have the following: * it should be neat and tidy for easy reading * There should be a report to show the overdue DVDs and their price. * Charges should be calculated automatically. * The navigation should be easy with clearly labelled command buttons. * The system should be able to save data on customers and DVDs without confusion. ?? ?? ?? ?? GCSE Database project coursework Identify Suraj Mudhar ...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)

    The information that needs to be found can be found quickly with no hassle. Future Developments There are other spreadsheets that could be useful to the company. There could be a spread sheet that shows the different costs of different airline companies or train companies to find out the cheapest way to get to your destination.

  2. Video Rental Shop I.T. System

    It's a good way of entering programs and working your way around the GUI. It's also relatively quick to use as well as being simple to use. They don't cost much and are useful, that's why I choose a mouse.

  1. a level ict project

    causing a lot of visual pollution as space needs to be prepared constantly to accommodate more files meaning that space that could be used for a more productive purpose is lost. In addition, the old system does put a strain on the tangible as well intangible resources of the company.

  2. Smarts Leisure Park Database Booking System

    Query One - "qryCustomer" This query is the customer query. I will extract all of the information for this from the table "tblCustomer". This is how id did it: I first clicked on "Create a Query using Wizard": I know that I want to extract all of the information for tblCustomer.

  1. Ict Powerpoint Coursework

    suitable for the task Mr Akram has associated the presentation to be. After all the above stated methods have been completed the input process would be finished and off the highest standard possible for this task. Output I have chosen to show the PowerPoint Presentation in all of the S.A.

  2. GCSE ICT Coursework Write-up

    Inputting Data Input devices are devices used to give instructions to a computer, for example, a keyboard or mouse. Accuracy is important when inputting data as if it is inputted incorrectly, then it may affect other parts of tasks as well as being incorrect and so affecting the task.

  1. Different types of technology How I use ICT at home and at school

    The allure of brick-breaker is too much, I'd say. The only improvement to avoid distraction is not with the blackberry but with your own mind. Focus on your work, Sadian. Focus. It is also quite an expensive piece of technology. By itself, it might not seem too daunting compared to the pricey iPads, HTCs, Androids and other smart phones

  2. Designing a database to manage stock in a clothes shop.

    1.6 Objectives *Create main menu for easy navigation through the queries *Create a Report to show orders taken. *Create a Database with queries to manage orders more quickly. * Add buttons and make sure they work so that we can see the forms easily and briefly.

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