Articles

Loading

Test Plan Template

Database Testing
Author
hatcatal
Date
2011-11-02 13:12
Views
3581

Table of Contents

1      Introduction.............................................................................................................. 6

1.1        Overview of System................................................................................................ 6

1.2        Scope of Testing..................................................................................................... 6

1.3        Purpose Of This Document....................................................................................... 6

1.4        Objectives.............................................................................................................. 6

1.4.1      Unit Testing............................................................................................................................................. 7

1.4.2      Integration Testing................................................................................................................................. 7

1.4.3      System Testing...................................................................................................................................... 7

1.4.4      User Acceptance Testing..................................................................................................................... 7

1.4.5      Enterprise Integration Testing............................................................................................................. 7

1.5        Test Deliverables................................................................................................... 7

1.5.1      Unit Testing............................................................................................................................................. 7

1.5.2      Integration Testing................................................................................................................................. 7

1.5.3      System Testing...................................................................................................................................... 8

1.5.4      User Acceptance Testing..................................................................................................................... 8

1.5.5      Enterprise Integration Testing............................................................................................................. 8

1.6        References And Source Documentation..................................................................... 8

1.7        Abbreviations, Acronyms and Definitions.................................................................. 8

2      Testing Schedule..................................................................................................... 10

3      Team Development................................................................................................... 11

3.1        Testing Team Formation.......................................................................................... 11

3.2        Training................................................................................................................ 11

3.3        Roles & Responsibilities......................................................................................... 11

4      Test Environment.................................................................................................... 12

4.1        Hardware components required............................................................................. 12

4.1.1      Servers.................................................................................................................................................. 12

4.1.2      Workstations........................................................................................................................................ 12

4.2        Software Requirements......................................................................................... 12

4.2.1      Server Requirements......................................................................................................................... 12

4.2.2      Client / Workstation Requirements.................................................................................................. 12

4.3        Tools to be used................................................................................................... 12

4.4        Test Databases..................................................................................................... 12

5      Testing Approach.................................................................................................... 13

6      Standards and Procedures.................................................................................. 14

6.1        Test Case............................................................................................................. 14

6.1.1      Unit Test cases.................................................................................................................................... 14

6.1.2      Integration Test cases........................................................................................................................ 14

6.1.3      System Test cases............................................................................................................................. 14

6.1.4      User Acceptance Test cases............................................................................................................ 14

6.1.5      Enterprise Integration Test cases.................................................................................................... 14

6.2        Activities.............................................................................................................. 14

7      Test Items.................................................................................................................. 15

7.1        Inclusions- Features to be tested........................................................................... 15

7.2        Exclusions- Features not to be tested.................................................................... 15

7.3        Specific Exclusions............................................................................................... 15

7.4        Prioritization........................................................................................................ 15

8      Test Entrance / Exit Criteria................................................................................ 16

8.1        Entrance Criteria................................................................................................. 16

8.1.1      Unit Testing.......................................................................................................................................... 16

8.1.2      Integration Testing.............................................................................................................................. 16

8.1.3      System Testing.................................................................................................................................... 16

8.1.4      User Acceptance Testing................................................................................................................... 17

8.1.5      Enterprise Integration Testing.......................................................................................................... 17

8.2        Exit Criteria.......................................................................................................... 17

8.2.1      Unit Testing.......................................................................................................................................... 17

8.2.2      Integration Testing.............................................................................................................................. 17

8.2.3      System Testing.................................................................................................................................... 18

8.2.4      User Acceptance Testing................................................................................................................... 18

8.2.5      Enterprise Integration Testing.......................................................................................................... 18

9      Qualification Provisions...................................................................................... 19

9.1        Criteria for test completion................................................................................... 19

9.2        Application Release Criteria.................................................................................. 19

10         Test Suspension/Resumption Requirements................................................. 20

10.1      Suspension Criteria............................................................................................... 20

10.2      Resumption Criteria............................................................................................... 20

11         Test Analysis....................................................................................................... 21

11.1      Analyzing And Reporting....................................................................................... 21

11.2      Problem Determination And Correction................................................................... 21

11.3      Defect Measurement.............................................................................................. 21

12         Defect Management............................................................................................ 22

13         Test Metric........................................................................................................... 23

14         Status Reporting................................................................................................ 24

15         Appendix: Types of Testing............................................................................... 25

15.1      Data and Database Integrity Testing....................................................................... 25

15.2      Business Cycle Testing.......................................................................................... 26

15.3      User Interface Testing........................................................................................... 27

15.4      Performance Profiling.......................................................................................... 28

15.5      Load Testing......................................................................................................... 29

15.6      Stress Testing...................................................................................................... 30

15.7      Volume Testing...................................................................................................... 31

15.8      Security and Access Control Testing..................................................................... 32

15.9      Failure / Recovery Testing..................................................................................... 33

15.10        Configuration Testing........................................................................................ 35

15.11     Installation Testing............................................................................................... 36

Total Reply 12

  • 2011-01-02 23:42

    cool stuff


  • 2011-01-03 12:58

    Thanks for share this valuable articles with us.


  • 2011-01-12 12:08

    Thanks! I'm needing it!


  • 2011-01-12 19:29

    thankss


  • 2011-02-03 10:47

    thanks


  • 2011-02-17 00:53

    Thank you so much, I'll try to study this document 😀


  • 2011-02-28 18:34

    Almost all the information available. Thank you very much.


  • 2011-03-04 13:29

    Hello,

    Can any one send this document to my mail id svsreeks@gmail.com

    Thanks in advance


    • 2011-03-04 15:04

      Download permission granted.


  • 2011-04-16 18:56

    Why i can't download??


    • 2011-04-17 15:05

      Read this to get a downlaod permission : http://www.vietnamesetestingboard.org/zbxe/?mid=General_Question_Answer&document_srl=33567


  • 2011-04-26 16:15

    Thanks.


Total 20,613
Number Title Author Date Votes Views
20613
SileniusStor is specialized in reselling Cheap Aquafadas software online.
Softwareces | 2022.09.15 | Votes 0 | Views 45048873
Softwareces 2022.09.15 0 45048873
20612
CSStore is specialized in reselling Cheap Steinberg software online.
Softwareces | 2022.09.04 | Votes 0 | Views 44985859
Softwareces 2022.09.04 0 44985859
20611
Software Tester Community Website
ItSeTsQtBer | 2021.04.11 | Votes 0 | Views 45716043
ItSeTsQtBer 2021.04.11 0 45716043
20610
SoapUI Certification Course Content
Steveskok | 2021.02.08 | Votes 0 | Views 45402648
Steveskok 2021.02.08 0 45402648
20609
JavaScript Course Content
Steveskok | 2021.02.08 | Votes 0 | Views 45670662
Steveskok 2021.02.08 0 45670662
20608
Why most mobile testing is not continuous?
(TestExpert) | 2021.02.04 | Votes 0 | Views 46039505
(TestExpert) 2021.02.04 0 46039505
20607
8 Common Mistakes When Planning and Documenting Your Tests
(TestExpert) | 2021.02.04 | Votes 0 | Views 46799212
(TestExpert) 2021.02.04 0 46799212
20606
Types of Performance Testing
Jamessmith | 2021.01.17 | Votes 0 | Views 46153262
Jamessmith 2021.01.17 0 46153262
20605
How to Build E2E Test Cases (1)
tanthanh | 2020.05.28 | Votes 0 | Views 46320028
tanthanh 2020.05.28 0 46320028
20604
[White Paper] Delivering better software using Test Automation
tanthanh | 2020.05.28 | Votes 0 | Views 45863257
tanthanh 2020.05.28 0 45863257
20603
[Whitepaper] How to choose the right API Testing Solution
tanthanh | 2020.05.28 | Votes 0 | Views 45771333
tanthanh 2020.05.28 0 45771333
20602
[Whitepaper] How to choose the right API Testing Solution
tanthanh | 2020.05.28 | Votes 0 | Views 45539628
tanthanh 2020.05.28 0 45539628
20601
TestOps Introduction
VTB | 2020.03.23 | Votes 0 | Views 45285435
VTB 2020.03.23 0 45285435
20600
TestOps Implementation Case Study
VTB | 2020.03.23 | Votes 0 | Views 46130861
VTB 2020.03.23 0 46130861
20599
Selenium Automation Tester Certification Sample Exam Set 3
(TestExpert) | 2020.02.03 | Votes 0 | Views 46141021
(TestExpert) 2020.02.03 0 46141021
20598
Selenium Automation Tester Certification Sample Exam Set 2
(TestExpert) | 2020.02.03 | Votes 0 | Views 46039685
(TestExpert) 2020.02.03 0 46039685
20597
Selenium Automation Tester Certification : Sample Exam Set 1
(TestExpert) | 2020.02.03 | Votes 0 | Views 45673535
(TestExpert) 2020.02.03 0 45673535
20596
What is agile testing? why is agile testing? and what is the benefits? (20)
oishichip | 2019.12.26 | Votes 0 | Views 44995461
oishichip 2019.12.26 0 44995461
20595
Crowd Testing — Vantagens para testadores, plataformas e clientes [pt-br]
soikmd2 | 2019.12.14 | Votes 0 | Views 45450320
soikmd2 2019.12.14 0 45450320
20594
Software Testing Industry Report (Turkey) 2018-2019 (2)
ItSeTsQtB | 2019.08.08 | Votes 0 | Views 46076382
ItSeTsQtB 2019.08.08 0 46076382
20593
How to bypass security in integration tests in ASP.Net Core
ItSeTsQtB | 2019.08.08 | Votes 0 | Views 46895884
ItSeTsQtB 2019.08.08 0 46895884
20592
For agile testing, fail fast with test impact analysis
ItSeTsQtB | 2019.08.08 | Votes 0 | Views 46683846
ItSeTsQtB 2019.08.08 0 46683846
20591
Career Path in Software Testing
^Software^ | 2019.07.28 | Votes 0 | Views 46164187
^Software^ 2019.07.28 0 46164187
20590
Challenges in Big Data Testing
^Software^ | 2019.07.22 | Votes 0 | Views 45719544
^Software^ 2019.07.22 0 45719544
20589
Essential Necessities In Big Data Testing
^Software^ | 2019.07.22 | Votes 0 | Views 45120282
^Software^ 2019.07.22 0 45120282
20588
5 Test Data Generation Techniques
^Software^ | 2019.07.22 | Votes 0 | Views 45851838
^Software^ 2019.07.22 0 45851838
20587
CI and CD for ETL (Extract-Transform-Load) testing.
^Software^ | 2019.07.22 | Votes 0 | Views 45826493
^Software^ 2019.07.22 0 45826493
20586
Quest for Quality Conference : 5-6 Nov 2019 at Dublin, Ireland
VTB | 2019.07.08 | Votes 0 | Views 45729447
VTB 2019.07.08 0 45729447
20585
TestBash Essentials Conference 2019
VTB | 2019.07.08 | Votes 0 | Views 45836537
VTB 2019.07.08 0 45836537
20584
UKSTAR Conference : 11-03-2019
VTB | 2019.07.08 | Votes 0 | Views 45826839
VTB 2019.07.08 0 45826839
20583
Testing in Context Conference Australia (TiCCA) 2019
VTB | 2019.07.08 | Votes 0 | Views 45115760
VTB 2019.07.08 0 45115760
20582
European Testing Conference 2019
VTB | 2019.07.08 | Votes 0 | Views 45805179
VTB 2019.07.08 0 45805179
20581
Automation Guild Online Conference 2019
VTB | 2019.07.08 | Votes 0 | Views 46695320
VTB 2019.07.08 0 46695320
20580
Software Quality Days 2019 : 15 Jan 2019 (1)
VTB | 2019.07.08 | Votes 0 | Views 46080282
VTB 2019.07.08 0 46080282
20579
Skills required to become a Software Tester (1)
IT-Tester | 2019.07.08 | Votes 0 | Views 45846538
IT-Tester 2019.07.08 0 45846538
20578
Automated Unit Testing with Randoop, JWalk and µJava versus Manual JUnit Testing
IT-Tester | 2019.07.08 | Votes 0 | Views 44788504
IT-Tester 2019.07.08 0 44788504
20577
Scrum Testing Guide Book (2)
IT-Tester | 2019.06.26 | Votes 0 | Views 45102945
IT-Tester 2019.06.26 0 45102945
20576
Acceptance Testing Definition in Testing vs Scrum
IT-Tester | 2019.06.26 | Votes 0 | Views 45887530
IT-Tester 2019.06.26 0 45887530
20575
User Acceptance Testing Checklist
VTB | 2019.06.20 | Votes 0 | Views 45920746
VTB 2019.06.20 0 45920746
20574
Firewalls and Types (1)
VTB | 2018.11.14 | Votes 0 | Views 45290602
VTB 2018.11.14 0 45290602
20573
Senior Test Engineer (1)
VTB | 2018.11.05 | Votes 0 | Views 45760640
VTB 2018.11.05 0 45760640
20572
Junior Test Analyst
kornadian2 | 2018.11.04 | Votes 0 | Views 45708544
kornadian2 2018.11.04 0 45708544
20571
Senior Test Engineer
kornadian2 | 2018.11.04 | Votes 0 | Views 45535304
kornadian2 2018.11.04 0 45535304
20570
Programme Test Manager, 12m, Immed Start, $NEG
kornadian2 | 2018.11.04 | Votes 0 | Views 46972116
kornadian2 2018.11.04 0 46972116
20569
Junior Test Analyst
kornadian2 | 2018.11.04 | Votes 0 | Views 45991837
kornadian2 2018.11.04 0 45991837
20568
Dev & Test Manager
kornadian2 | 2018.11.04 | Votes 0 | Views 46666704
kornadian2 2018.11.04 0 46666704
20567
Senior Test Analyst (Performance Tester)
kornadian2 | 2018.11.04 | Votes 0 | Views 46615694
kornadian2 2018.11.04 0 46615694
20566
QA Automation Test Analyst
kornadian2 | 2018.11.04 | Votes 0 | Views 45686389
kornadian2 2018.11.04 0 45686389
20565
Software/Field Testing Engineer
kornadian2 | 2018.11.04 | Votes 0 | Views 45573772
kornadian2 2018.11.04 0 45573772
20564
Compliance Technician (Tester)
kornadian2 | 2018.11.04 | Votes 0 | Views 45201268
kornadian2 2018.11.04 0 45201268