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

    1 Year FREE Onsite Warranty �1,399.00 inc VAT Product Features Intel Pentium 4 2.66 GHz 512 mb DDR RAM 80 Gb Hard Drive Digital Media Software Suite DVD / DVDRW Drive 17 inch Monitor (15.9 inch VIS) Kodak CX4300 Digital Camera Hewlett Packard DJ5552 Colour Printer PC Line 1.8M USB

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

    * Overtime is paid at the one and a quarter of the hourly rate. * The maximum number of hours that a worker should work is 60. If the number of hours goes above 60 the payroll should still be processed but an alert must be made to the manager for approval.

  1. Beanie Project.

    * Bad Points o Works does not provide as many advanced tools as the intermediate user may require. This goes as far as customisation of functions and merge facilities, which although are possible it would be nice to adapt Works to suit SQL databases.

  2. ICT Solutions for people with Special Needs.

    EFD There are many pieces of legislation, which relate to the provision of support for people with special needs. I will show the detail of the legislation. I have learnt how legislation affects the requirements for support of people with specific needs (e.g.

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

    When the member returns the book the assistant would go to the computer and delete it from the books that should be bought back. In the book the date is crossed out and replaced in the shelf for the next member.

  2. The application to be researched is a small company called RS EQUIPMENT. The company ...

    The next level down is Level 2, which is held by only the Accounts Manager. This allows access to all accounts records, information, and accounts software. Then there is Level 3, which is given to all other personnel. This only allows access to the individual workstations and their respective areas of work, such as spreadsheets, graphic design, and database.

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