• 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
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  • Level: GCSE
  • Subject: ICT
  • Word count: 3462

The information handling problems of MovieZone a small video rental shop in Stoke-on-Trent. The owners of the shop want me to design and set up a more efficient way of storing and handling information about videos, members and loans

Extracts from this document...

Introduction

Sample Project MOVIEZONE VIDEO RENTAL SYSTEM Contents Analysis Project proposal Consulting the users of the current system Describing the current system Data flow diagrams Possible solutions Chosen solution System objectives Performance criteria Current resources Design Chosen software Resource requirements System flowchart Table design Entity relationship diagrams Data entry form designs Menu form designs Query designs Report designs Test plan Implementation Implementation plan Implementation commentary Testing User guide Evaluation Project Proposal Project title MovieZone Video Rental System Aims of project To investigate and try solving the information handling problems of MovieZone a small video rental shop in Stoke-on-Trent. The owners of the shop want me to design and set up a more efficient way of storing and handling information about videos, members and loans. Input Processing Output Member details (member number, name, address, date of birth). Video details (video number, title, category, certificate). Loan details (video number, member number, length of loan, date due back). Look up member details. Look up video details. Look up loan details. Search for videos matching member's requirements. Search for overdue videos. Member details. Video details. Loan details. Reports listing videos matching member's requirements. List of overdue videos. Letters to members who have overdue videos. MovieZone Customer Questionnaire This questionnaire will help us find out what you think about the service currently offered by MovieZone and try to improve it. Your opinions are very important to us. As a thank you for completing this form we will give you one night's free rental of any new release. 1. What is your favourite type of movie? ? Action ? Comedy ? Horror ? Science fiction ? Thriller ? Romance ? Other -- please state _____________________________ 2. How many times a week do you rent a movie? ? Once ? Twice ? Three times ? More -- please state _____________________________ 3. How easy is it to find out if we have a particular movie available for rental? ...read more.

Middle

to answer customers' enquiries by entering search criteria and finding matching video records; * it must take no more one minute to find and delete a member, video or loan record; * it must take no more two minutes to find and edit a member, video or loan record; * it must take no more two minutes to create a new member, video or loan record; * on screen data entry forms must be clearly laid out to make data entry; * on screen data entry forms must use automatic data validation to reduce data errors on input; * it must take no longer than 2 minutes to search for videos due back on a certain date and produce a list that can be printed out; * it must take no longer than 5 minutes to search for all the members with overdue videos at the end of the week and produce a summary report on screen; * reminder letters to customers with overdue videos should be clearly laid out and include all the details of videos that need to be returned; * Current Resources Mr and Mrs Marshall already have a computer with the following specification: * Windows 95 operating system * A Pentium II 200 MHz processor * 16 Mb of RAM * A 2 Gb hard disk with 821 Mb of free space * A floppy disk drive * A CD-ROM drive * MS Office 97 Standard (this includes Word 97 and Excel 97) Mr and Mrs Marshall can spend up to �1000 on new hardware and software if necessary. Choice of Software The database packages that I could use to set up the new system are PinPoint and Access 2000. These packages are available on the computers at school and my PC at home. Mr and Mrs Marshall don't have these packages on their computer but they are willing to spend up to �1000 on new hardware and software. ...read more.

Conclusion

and loans tables to search for records matching the following condition: * Every video on loan with a DateDue less than the current date. These fields need to be displayed for the records that are found: * MemberNo * First Name * Surname * Address Line 1 * Address Line 2 * Town * County * Postcode * VideoNo * Title * DateDue These records need to be sorted into ascending order of MemberNo Report Designs Test Plan Implementation Plan To set up the MovieZone system I must complete the following tasks: 1. Create a new blank database; 2. Create a table to store information about members; 3. Create a table to store information about videos; 4. Create a table to store information about loans; 5. Set up relationships to link the members, videos and loans tables together; 6. Create a data entry form for the members table; 7. Create a data entry form for the videos table; 8. Create a data entry form for the loans table; 9. Create a query to search the videos table for all videos with a certain category; 10. Create a query to search the videos table for all videos with a certain certificate; 11. Create a query to search the videos table for all videos with a certain category and certificate; 12. Create a query to search the videos table for all the videos with a certain title; 13. Create a query to search the loans table for videos that are overdue; 14. Create a report to display information about overdue videos; 15. Create a menu form to display the main menu options; 16. Create a menu form to display the find video options; 17. Prepare a letter that can be used in a mail merge to generate reminders for members with overdue videos; 18. Create a macro to generate reminder letters for members with overdue videos; Implementation commentary Test Results Modifications Evaluation User Guide ?? ?? ?? ?? Sample Project Appendix A Sample project - 1 ...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

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    Anything you need to know is located on this site. You can learn about events, shops, clubs, schools and many more. People can use the site to find out all they want about the area they live in. People have access via this site to do things related to fines, taxes and other such things.

  2. Different types of technology How I use ICT at home and at school

    The interactive aspect the whole class go through also make them more conscious of what they're learning. It involves them more directly into the teaching and helps send the information straight into their heads. It replaces boring classroom lectures, taking notes etc.

  1. ICT PROJECT

    The report will work by using Vlookup formulae, which will be show in three sets of Lookups. These are: looked up and calculated form pivot table B, student names looked up from sheet 10 and grade looked up, using average mark, on sheet 8 Sheet 10-Student List The student list will hold all of the students' details only.

  2. Creating a computer system for a video rental shop

    Basically everything including customers, videos, staff and rentals are all written out manually onto a standard form every time something needed to be updated. There are a few problems with this filing system: Keeping track of when videos are due back.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    * Access the members master file if the book not returned on time Specific administrative tasks include: * Statistics regarding overdue books and other recourses * financial information regarding the library * ordering of new book * books taken out for repair * help with stocktaking * print out reservations

  2. I will design a new video database for the video shop that will also ...

    Staffs records the details on paper-based information which means new forms have to be filled in. If the data is recorded incorrectly, it can be a hassle to re-enter data as the whole database has to be re-written or new forms have to be filled out to correct the fault.

  1. Introduction to information skills and system. An information system is a system that accepts ...

    The study of human body and technology is referred as ergonomics. The following are a few health problems the can arise form the use of information system: Tools for information process - Collecting: The collecting process involves deciding what to collect, where to collect form and how to collect.

  2. Database Design Guideline

    It is a common link between the two tables. It gives your database a good overall structure. I will be creating a relationship between the doctors and patients table; in Microsoft Access for my database. The relationship will be showing what the two tables have in common as I will identify and explain below.

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