• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12

Design a computer system for a video hire shop.

Extracts from this document...

Introduction

I work for a video shop called 'Vinnie's Vid's' and he has been moaning about the files. He is complaining that he needs a better way to store files about the users, videos and who has what video on loan. I will make a database for each of the problems and connect them. I will collect the information about users and videos from Vinny. His current system is a paper and pen system, which is too slow and inefficient. It could be lost at any time with only the one copy he will have to start the records all over again. A PC based system is fast, accurate and good for presentations. He has asked me to create a database by using Microsoft Access Objectives: * Make a database, which can find a certain type of film in 30 seconds. * Make a database which can automatically show who has the rented videos. * Make a database which shows who has overdue videos and how much they owe Introduction Choice of Problem: I have noticed that keeping customer records on paper can be time consuming and neither practical or easy to use. ...read more.

Middle

203 Green Lanes N8 HFD 8292 4130 YES 20.01.02 Trees Lawn 08 Susan Croft 13 Durahm Road N11 9GJ 8340 4813 NO Vegatables Lawn Hedhe 09 Cherri Benn 98 South view road N13 9HY 8888 8182 YES 2.11.01 Trees Lawn 10 Microsoft Excel: * You can enter information into separate fields * You can get a print out. * You can collate some of your information into a pretty graph. * You can put some of your information into alphabetical order. * You can't query. * You can't carry out searches. * You can only enter data in one format. * It is not easy to add fields or records. * You can only look at it in one view. * It has limited features and is a spreadsheet program Microsoft access: * Easy to search for information * You can bring up one specific field * You can enter information into separate fields * You can get a print out. * You can sort the information. * It is easy to add fields or records. * You can look at the information in several views. * It is a database program with many useful database-making features. ...read more.

Conclusion

The database will have an encrypted modification password and it will be write-protected so it cannot be deleted. If a staff member needs to access the database to modify it, then a staff password is needed. It will not open until the password is correct Information Flow Error Checking To ensure that the information is correct the staff will send the members an invoice with their details they have inputted and attached is another form to fill in the correct information and then collect it and update the database. For the videos the staff will do daily checks on the database to see any obscure looking information in the database and will edit this info by getting the video and re-entering the video data again. Or the staff will do two copies of information identical to each other because the information will be inputted twice and if they are not identical then one or the other or both are changed with the correct information. Skills The user is a competent pc user and will not need any sort of training, he would like it to be user friendly though, so if any new staff join, it will be easy to pick up. ICT coursework 2. Database Project ...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

    Information Retrieval tools. I have used a database to carry out my searches. ...

    3 star(s)

    The strengths of Emerald are that it has reduced redundancy, which is great because nobody wants unnecessary data. This also prevents information overload. The weakness is that if the database is hacked or changed, it will affect the whole system .

  2. ICT coursework: Designing and implementing a book rental system

    The reason why I would say it is the best way is because it would solve Book Zone's problems. The disadvantage of this is that it is very expensive Book Zone might not be able to pay for it. I think that Book Zone would need a program such as

  1. Designing a booking system for an Estate Agent.

    Whilst talking to Raj I asked whether they have an organisational chart structure and he answered no. All the workers are on the same level and they work independently whilst still keeping in contact with colleagues. The audience are the clients who booked an appointment for property viewings.

  2. Home Office LTD company. Database

    it has an auto filter for the four top headings that allows the user to organise and list the products in any way they want to i.e. ascending alphabetically or numerically or with least quantity remaining. It also has the main menu button in the top right.

  1. ICT Solutions for people with Special Needs.

    people in the UK covered by the Disability Discrimination Act, which represents around 15 per cent of the population * Some 70 per cent of economically active disabled people became disabled during their working lives * Over 5.2 million disabled people are of working age which represents 18 per cent

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

    When an overdue DVD is returned they are charged �2.99 for each days the film is overdue. All in all the overdue process is overly inefficient and time consuming.

  1. Video World Database as ICT project.

    Gary has no problem with the amount of storage available. Access will be able to perform efficiently with the amount of RAM available. The graphics card will allow complex screens to be refreshed at fairly fast rates. The Development will be performed mostly at home.

  2. ICT Security Report

    * Obstruct the communication media between the intended users and the victim so that they can no longer communicate adequately. However, a DoS attack may not be the main element in a service attack. They may be used as a component, though it may be a large part of the attack.

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