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

Introduction

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.

Middle

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.

Conclusion

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

    These are the children that will control the future and being so desensitised to violence might be good, but might also corrupt the generation. PSN is a place used to not only go online and talk with friends but to purchase stuff from Sony.

  1. ICT PROJECT

    This is the screen shot of Data Form for edit grade boundary This is the grade boundary sheet, which I name it "Grades". Marking Archive This is the sheet where the grades are going to be stored from the input student's marks.

  2. ICT Report 2b: ICT in Organisations

    The components all fit together easily and Boots is aware, that without a computer, mouse and keyboard (even one is missing) the rest of the components would be practically useless to operate on. The PS/2 port is advantageous to Boots PLC because it is small and can be obtained with

  1. ICT Coursework (MarcoS)

    Then stop recording. * In the cell J11, write "Help", then right click on it, and select insert comment, and then copy the text as shown in the right picture. * In the same worksheet there will be a part where there are the other macros to link the different worksheets, as show in the picture.

  2. GCSE ICT Coursework Write-up

    Saving an untitled document (one which hasn't been saved before) 1. Either click on "file" in the top left of the screen (as indicated by hand no. 1) or hold down "alt" and press "f" and the file menu will appear.

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

    > DVDs QUERY On the query for the DVDs, I used four different parameter of criteria to search if none of the criteria is enter then it will displays all the DVDs on the system. Here is asking for the DVD id and I set up this parameter by written

  2. Database Coursework

    The user should be able to print a list of overdue DVDs which are low of stock in less than 1 minute. * The system will automatically tell me which DVD's are overdue. System related objectives * The system will be protected by a password, so that only authorised personnel will be able to access customer, DVD's and Rental details.

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