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

    One can study all the forms and documents in a business to discover what information will be required by the new system. A thorough examination of the documents in Fred's Car Rentals will ensure that each of the documents actually fulfils a purpose and that the information that is recorded or transmitted is actually used at some stage.

  2. Feasibility Report

    new system, various amounts of hardware and software will have to be purchased in order for the Perfect Pie Company to get the most of the new system; this will put a strain on the financial budget. Although Antivirus and Spyware software can remove nearly any virus that steps in

  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

    The Online service is open 24/7 and is very commonly used. The key feature is that there are no pop-up ads and no untargeted banners. You see only relevant text ads and links to related web pages of interest. The website it self is very simple at first but there

  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