Test Plan for my database

Authors Avatar
Jess Kimber Test Plan Databases Test No.Related ObjectivePurpose of TestTest Data(Extreme or Valid data)Expected ResultActual ResultScreenshot reference Query – Overdue DVD using Range Check1Find out the DVDs, which should have been retuned, in the last week. (15/03/07)  Extreme 15/03/07 1 entry 1 entry Screenshot_!2Extreme22/03/073 entries 3 entriesScreenshot_!3Valid19/03/071 entry 1 entryScreenshot_! Query – Parameter Query - Surname12 The query searches for any customer when the surname is entered into the parameter box.   Jackson0 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_A3 Roberts 1 entry Pass – There is one customer with the surname “Roberts” on file.Screenshot_B Query – Parameter Query - Certification1The query searches for any DVDs with the certification
Join now!
entered into the parameter box.  127 entries  Pass Screenshot_C2110 entries  Pass – There are no DVDs with certification “11” as it an invalid DVD certification.3 1514 entriesPassScreenshot_D4 183 entriesPassScreenshot_E Query – Parameter Query - Genre1 The query searches for any DVDs with the genre entered into the parameter box.  Family  6 entries  PassScreenshot_F2 Science Fiction 0 entries  Pass – There are no “Science Fiction” DVDs, however an abbreviation of this would be “Sci Fi” which is a valid genre.3Comedy6 entriesPass – There are 6 “Comedy” DVDs on fileScreenshot_G4 Sci Fi6 entries Pass – There are 6 “Sci Fi" DVDs on ...

This is a preview of the whole essay