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

Design a computer system for a video hire shop.

Extracts from this document...


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.


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.


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)

    To avoid misleading information, I will talk about information retrieval tools and will explain in depth of what Information science is and how the ideas from information science are being applied in the world. Information management means gathering information and managing information. It basically focuses on information as a resource.

  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. Planning a payroll system for a martial arts school.

    Justification of reasons for the Solution At the moment the current system consists of manually calculating the details on a form that the employee fills in and is signed by their manager. The employee fill in a form with his details (employee number, surname and forename, grade, hours worked...)

  2. I was hired by Mr Davies to create a website for a newly built ...

    �2,500 Regional Posters in bus stops 3 months 6 �800 Local town Posters on the side of a taxi 1 month 4 �390 County wide Newspapers advert 4 weeks 1 �250 Local Last year for the first time Sam earned enough money to have to register for VAT.

  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. Database Design

    Customer Address Employee Address Product ID Product description Supplier address Shipped date City City Unit Price Supplier ID Supplier phone number Order ID Postcode Postcode Quantity Stock Ship address Date of birth Phone number Order date City Telephone number Hire date Required date Postcode Birth date Country Salary per month

  1. The purpose of this document is to provide a design for an electronic payment ...

    Design diagrams will be drawn to show how to implement the system, and in the case of the user interface, prototype screenshots will be produced but because of time constraints the system will not by physically implemented. S3G group designed and implemented the original system but did not include any

  2. I have been asked by a General Sports shop using a manual system to ...

    You are less likely to make mistakes as well. Computers aren't as likely to make mistakes than humans because we put the record in the wrong place accidentally; a computer is not likely to do this. It is also easier to amend (edit)

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