• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Input, process, output

Extracts from this document...


Input Process Output Members 1. New Member Joins: This information will be given by the new customer. Information will be inputted manually using a keyboard and on-screen data entry forms. This will include name, address, contact details and proof of identity is required 2. An existing member's details change: Information is given by customer over the phone or in person when they want to inform jenjams about any personal details changes 3. Deleting an existing customer: Request will come from customer if they do not wish to be a member. The manger will certify any details before they are deleted 1. New member details need to be saved: after the details have been entered the will be checked and amended, then saved and added to current customer list. 2. Changes to an existing member's details need to be saved: Changes will be amended and saved and details on the current customers list will be Updated. 3. Deleted customers Membership cards need to be collected: Details of deleted member will be noted so a letter can be sent requesting membership card. ...read more.


DVD matching a members enquiries are looked up on screen: DVDs can be searched using queries that can locate movies using categories such as title, category, certificate and date released Rentals 1. A DVD is rented: A new rental is generated using the rental form. The DVD, customer and length of rental is added. The DVD and customers are not entered manually but can be searched using a combo box. The length of the rental is entered and the due date is calculated automatically. Rentals are added to the rentals list. As the shop only has 1 of each DVD when a rental is made the same DVD cannot be rented again, preventing double renting. 2. A DVD is returned: After the DVD has been returned and paid for it is marked as returned on the rental form and is now added back into the available DVD list 1. New rental needs to be saved: rental is saved to the rental list and rented DVD is marked not available 2. The rental is saved and marked as paid for. The DVD returned is now marked available and is returned to its case. ...read more.


The list is view in report form onscreen or can be printed out Query: Search for least 25 rented DVDs 1. Search for 25 least rented DVDs query is added: DVD information is needed along with rental information. A relation is made between the DVD and number of times the DVDs have been rented. 1. Producing 25 least rented DVDs: the query will select the least 25 rented DVDs over a certain period of time 1. view list: this information is organised into a report which can be viewed onscreen or it can be printed Query: Searching for DVDs due on a specific date 1. Search for DVDs due on a specific date query is added: rental information is required. Rental details hold information on DVDs, customers and due dates, so a relationship doesn't need to be made. 1. Producing DVDs rented on a specific date: the user needs to enter the date they are enquiring about. The query will then search and produce all the rentals that are due on that date along with customer and contact information 1. View list: the list will be organised onto a report, containing information of the DVD, customer contact details and the due date. This information in turn can be printed or just view on screen ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    One of the responsibilities I had on my team was to use my ICT skills to design the slideshow using Presentation software (Microsoft PowerPoint), which I succeeded at doing. Breakdown of Tasks Description of Task Expected Date of Completion Identify Problem 20th September Investigate Current System 25th September Analyse Findings

  2. Feasibility Report

    o Order options like text messages and an online order form can cause problems; the servers can easily get problems that will take time to resolve which in turn will give the customers less options to choose from for placing their order.

  1. Guide for Input Devices

    Most of the feature-laden mice use USB. USB devices are recognized and installed by Windows, and many come with software disks. Windows, however, has drivers for almost all commercially available mice. USB mice are also good choices for replacements when PS/2 ports fail. Wireless: Wireless mice use one of the other interfaces in this list.

  2. Constraints; input processing and output table for Computer Creations

    This change can only made by the manager. On this sheet, when a macro is pressed the user will be taken to the desired sheet. Quote sheet- shows the cost of all the products and allows the user to print out the details The information on this page will be

  1. Using Search Engines

    is further options if someone wants to enhance their search results by clicking on the advanced search hyperlink. This is located near the Google search bar on the right. Below is a screenshot showing the different features that the Google search engine provides.

  2. Database Coursework on a Rental System: Design

    Another possible option is to buy an off-the-shelf package. It is relatively cheap compared to the cost of bespoke software, comes extensively tested and there is much support readily available. However, the features are not tailored to the organisation and may prove to be rather limited when it comes to the extent of the features that can be used.

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