• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 3589

Moviezone video rental system.

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

longer than two minutes 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

order of VideoNo Query: Overdue This query will use the members, videos 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 ...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. Different types of technology How I use ICT at home and at school

    It caters more to everyone. For someone like me, who literally cannot learn anything through watching silently through a video, reading through a book, writing notes or listening to a lecture, actually participating in the lesson helps actually put the facts into my head.

  2. ICT PROJECT

    I will validate all cells, into which marks are inputted as these needs to be as correct as possible. Format checks will be used on cell so that the user inputs the information in the correct format, if the user input the wrong format the spreadsheet would tell the user to correct the mistake.

  1. Creating a computer system for a video rental shop

    If he knew how many videos his staff sold each month he could perhaps reward them with bonuses or even employee of the month awards. Stock levels. It can also be a nuisance for Abdullah to go into the storeroom to get a video only to find that the video has already been rented out.

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

    Since they don't have a computer it maybe difficult to get it as cost effective as possible. New System The new system should be able to: * Make rentals. * Store basic Customer details. * Store basic Staff details. * Stop Staff from overbooking rentals.

  1. Database design.

    All forms Do the macro buttons work I clicked on the buttons The command button will carry out the task that is anticipated The command button carried out the task that was anticipated 8.

  2. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    The piece of paper will be where we stamp on when to bring it back and inside the red envelope is a green card. That green card has the name of the game, the manufacture, the genre and the game number on it.

  1. Benefits of using my IT system in the Travel Agents.

    The details were added to the letters successfully. The only change should be that it would be easier if there was screenshots or images. Saving First I am going to click on File then I will select save as. After that I will choose the location where I want the file to be saved in and if I

  2. Computer project Alevels

    The following is a picture of a toolbox. * Add command buttons In order to add command buttons you must first the 'control wizards' button which is represented by a wand. Once you have selected this button you must then select the command button which looks like this.

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