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

Test Plan for my database

Extracts from this document...

Introduction

Test Plan Databases Test No. Related Objective Purpose of Test Test Data (Extreme or Valid data) Expected Result Actual Result Screenshot reference Query - Overdue DVD using Range Check 1 Find out the DVDs, which should have been retuned, in the last week. (15/03/07) Extreme 15/03/07 1 entry 1 entry Screenshot_! 2 Extreme 22/03/07 3 entries 3 entries Screenshot_! 3 Valid 19/03/07 1 entry 1 entry Screenshot_! Query - Parameter Query - Surname 1 2 The query searches for any customer when the surname is entered into the parameter box. Jackson 0 entries There are no customers with the surname "Jackson" Pass - There are no customers with the surname "Jackson" on file. 2 Smith 1 entry Pass - There is one customer with the surname "Smith" on file. Screenshot_A 3 Roberts 1 entry Pass - There is one customer with the surname "Roberts" on file. Screenshot_B Query - Parameter Query - Certification 1 The query searches for any DVDs with the certification entered into the parameter box. ...read more.

Middle

Screenshot_J 3 15/06/1994 0 entries Pass - There are no customers with the DOB 15/06/1994 on file Data Validation - Initial Capital Letter 1 The data validation ensures a capital letter is used at the start of a word. (e.g. first name and surname). Patrick 1 entry Pass - "Patrick" matches the specified requirements of the input mask as the field automatically starts with a capital letter Screenshot_K 2 PATRICK Fail Pass Automatically changes the data to the specified requirements of the input mask. 3 pATRICK Fail Pass- Automatically changes the data to the specified requirements of the input mask. 4 PaTrIcK Fail Pass Automatically changes the data to the specified requirements of the input mask. Command Buttons 1 Command buttons allow the user to navigate within the database. "Add New Customer" Pass Pass - Performs the action specified by the name of the command button which adds a new customer to the database. ...read more.

Conclusion

Screenshot_S 9 "View Next Loan" Pass Pass - Performs the action specified by the command button which displays the information about the next loan in the database. Screenshot_T 10 "View Previous Loan" Pass Pass - Performs the action specified by the command button which displays the information about the previous DVD. Screenshot_U 11 "Add New Loan" Pass Pass - Performs the action specified by the command button which displays the information about the previous DVD. Screenshot_V 12 "Delete Loan" Pass Pass - Performs the action specified by the command button which displays the information about the previous Loan. Screenshot_W 13 "Close Database" Pass Pass - Performs the action specified by the command button which closes the database. Screenshot_X Macros 1 Performs more than one action at the same time. This macro is on each form except the switchboard and allows the user to navigate within the database "Back to Main Menu". Pass Pass - Performs the following actions: Saves the open form, Closes the current form and opens up the switchboard (main menu). Screenshot_Y ?? ?? ?? ?? Jess Kimber ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Background and investigation for designing a database for a DVD rental shop.

    When an overdue DVD is returned they are charged �2.99 for each days the film is overdue. All in all the overdue process is overly inefficient and time consuming.

  2. Project Plan Forecast

    team and SAP team Oral Formal: Oral Presentation, staff round table, question and answer Oral Informal: Individual and Group Discussion Regularly-scheduled team meetings (2/weeks): and as needed 2 Network Design Stage July 1, 2007 July 30, 2007 Programmer and IT consultant Written Formal: Hard copy document Oral Formal: Video conferencing,

  1. Home Office LTD company. Database

    The solution is to insert a new line above the new entry. This allows there to be a space in the sheet for the next new client. This is because when creating the macro the information was pasted into row 14, and with the inserted line above the data transferred,

  2. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    In initial stage there were small problems in the implementation, which is common in most of the CRM initiatives. Eventually all of these problems were efficiently solved. Yet due to the company's internal viral complainers, these minor problems became major problems and even the system killers.

  1. Intermediate GNVQ Sample Database Assignment - Bolton Tools Database

    will do the following tasks: * The system must keep track of every tool for hire. He must be able to add new tools, delete ones that are no longer used (e.g. broken) and change the details of any particular tool.

  2. The Development of Object-Oriented Database Systems.

    and as such do not allow for user-defined data types. In comparison to the simplistic model of a relational database system, object-oriented database systems include features that allow for a user-extensible type system, and complex composite data values, thus enabling the modelling of much more complex real-life business and non-business systems.

  1. Video World Database as ICT project.

    Basically everything including customers, videos, staff and rentals are all written out manually onto a standard form every time something needed to be updated. There are a few problems with this filing system: Keeping track of when videos are due back.

  2. The application to be researched is a small company called RS EQUIPMENT. The company ...

    department; * General observation of the system The various methods which will be used are: * Interviews - Interviews are more accurate and specific, as they involve a direct conversation with the individual concerned. For the most part of my visits, I will try to have as many interviews as possible with the staff.

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