• 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)

    How many personnel are currently in your employ? 2. What details do you hold about your employees? 3. Do your employees have any qualifications in ICT? 4. Do your employees have any past experience working with computerised systems? 5.

  2. Feasibility Report

    During the time that the new system is being put into place within the company, the Perfect Pie Company will have to close its doors to the public, this will result in another financial lose, and regular customers might chose to go elsewhere.

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

    The computer details section will be from cell A5 to C12. The laptops section will be from E5 to G9. The hardware section will be from I5 to K10. The software section will be from M5 to O8. The data on this sheet can only be changed once there is a change in the price of a product.

  2. Database Coursework on a Rental System: Design

    to make it suitable for the tasks the user will have to perform, containing all the features that they will need. There are a number of generic packages that can be chosen for this project. These include: Spreadsheet Packages: these types of packages can hold, store and manipulate numerical data but not at a particularly advanced level.

  1. Using Search Engines

    and will be describing each one of them and comparing them with each other. www.google.com Below is a screenshot of the homepage of the Google website This website is for use of quick searches that can be made very easily and the search engine itself is very simple to use.

  2. System Choice.

    Consequently, legal measures are required to ensure safety is weighty and risk is minimised regarding visual communication systems in all aspects of electrical safety. Information needed: Legal information will be needed to see if law enforces any visual communication systems in electrical safety.

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