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

Introduction

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.

Middle

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.

Conclusion

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)

    The last data-collection method I could potentially use is direct observation which would provide a unique insight into the system that would be unattainable via other means. Procedures can be observed as they are carried out, so that any problems and irregularities can be noted.

  2. Feasibility Report

    back up copy, so if the copy on paper was to be misplaced or lost, the scanned document can be easily accessed and reprinted. Possible Constraints With Hardware And Software There will be many possible constraints with the Perfect Pie Company becoming computerised, as well as the design of the

  1. Guide for Input Devices

    This is because there are many devices that use USB ports, but only one that can use a PS/2 mouse port, so you might as well save the USB port for some other device. Most of the feature-laden mice use USB.

  2. 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.

  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