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

    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. Different types of technology How I use ICT at home and at school

    can also be quite expensive * In terms of playing media, certain types of files like MKV aren't compatible * Games can be quite violent and easy to access for kids not following the age requirement * Just shown by the recent PSN hackings, all your important detail you store


    I have shown the macro codes behind this the user form below User Form 2(Add New Student) When the end user clicks on "add new student" a macro goes to the student list sheet and inserts a new row. It then loads a user form.

  2. ICT Report 2b: ICT in Organisations

    Boots takes full advantage of speakers for advertisement where they can have a person speak special offers around the store. However, more importantly, Boo ts utilize this in the production facility and R&D Department where orders are fired off form over head speakers in assembly lines, for example, to inform

  1. Database Analysis and Database Design Project - DVD library for moving images.

    id]&"*" like"*"&[enter actor name]&"*" Like"*"&[enter DVD title]&"*" On the report, the user must use the navigation buttons to move from record to record. The report will look like this: > DVDs REPORT BASED ON THE QUERY On this one, the same criteria that we use on the query like in

  2. Ict Powerpoint Coursework

    as the users of the PowerPoint would get a better understanding of both the descriptive text and the images by seeing one another. Test No. Description of test Expected result Actual Result 1. The S.A. Foods logo should be on the first slide The S.A.

  1. Database Coursework

    Its best to go with the 1GB RAM because it's very unlikely that it would freeze. Printers: There are two main types of printers: Inkjets, and lasers. Inkjets are much less expensive than lasers, and tend to produce better quality on inkjet colours.

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

    I will need a computer with normal capabilities, for example two gigabytes of ram, a keyboard, a mouse, a screen to display the output and a 5.1 megapixel camera to take out photos of my products. 2.2 Software To accomplish my solution, besides hardware will also need some basic software.

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