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

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

  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. I have been asked by my company (Standard engineering components LTD) to investigate the ...

    Ancient history Paper space dimensioning is a reality in AutoCAD 2002. You can now select model space objects from paper space, and dimensions no longer rely on defpoints. In fact, there are now three levels of dimension : - what used to be called non-associative dimensions (i.e., individual lines, text and arrows)

  2. Beanie Project.

    o These sorts of animations can also have advanced tools with them, which create amazing customised effects, and the later versions of PowerPoint have more and more tools added to them every year. o This wizard-based interface that PowerPoint uses makes PowerPoint an extremely easy and versatile program to use,

  1. ICT Solutions for people with Special Needs.

    For many of them, new computer technology can dramatically improve their quality of life, their ability to communicate and their opportunities for independence and employment. The definition of disability The Disability Discrimination Act defines a disabled person as someone with "a physical or mental impairment, which has a substantial and

  2. Planning a payroll system for a martial arts school.

    The booking system will inform the senior instructors when their next training session will take place and which members has registered for it. The senior instructors are the main target audience the booking because the output will be directed to them.

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