Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

STR

VIEWS: 34 PAGES: 27

									    SYSTEM TEST REPORT
              Prepared By




                  for the
Inventory and Employee Management System
                    for
              Sac Air Games




               Version 1.0




           ~Novo Solutions~                1
                                Software Test Specification Document
                                                           Table of Contents
1      INTRODUCTION ................................................................................................................. 3
    1.1     PURPOSE ........................................................................................................................... 3
    1.2     SCOPE ............................................................................................................................... 4
    1.3     DEFINITIONS, ACRONYMS, AND ABBREVIATIONS ............................................................. 4
      1.3.1     Definitions ............................................................................................................... 4
      1.3.2     Acronyms ................................................................................................................. 5
      1.3.3     Abbreviations ........................................................................................................... 6
    1.4     REFERENCES ..................................................................................................................... 6
    1.5     OVERVIEW ........................................................................................................................ 6
2      SUMMARY ............................................................................................................................ 7
    2.1        LOGIN/LOGOUT ................................................................................................................ 7
    2.2        VIEW CONTACT LIST ........................................................................................................ 7
    2.3        CHECK SCHEDULE ............................................................................................................ 8
    2.4        VIEW/EDIT AVAILABILITY................................................................................................ 8
    2.5        VIEW/ADD/EDIT INVENTORY ........................................................................................... 9
    2.6        VIEW EVENT DETAIL ........................................................................................................ 9
    2.7        SCHEDULE/MODIFY EVENTS .......................................................................................... 10
    2.8        ADD/EDIT EMPLOYEES ................................................................................................... 10
3      VARIANCES ....................................................................................................................... 11
4      COMPREHENSEVNESS OF THE TESTING PROCESS ............................................. 11
5      APPROVALS ....................................................................................................................... 12
APPENDIX A: TEST LOGS ...................................................................................................... 13
    TEST LOG 1 .............................................................................................................................. 13
    TEST LOG 2 .............................................................................................................................. 19
    TEST LOG 3 .............................................................................................................................. 21
APPENDIX B: SOFTWARE PROBLEM REPORTS ............................................................ 25




                                                          ~Novo Solutions~                                                                       2
                               SYSTEM TEST REPORT
                                     Novo Solutions
                                 CSC 191 Senior Project
       Department of Computer Science - College of Engineering and Computer Science
                         California State University, Sacramento
                                       Version 1.0


1      INTRODUCTION

This is the System Test Report for Sac Air Games (SAG) Inventory and Employee Management
(IEM) software sponsored by the Digital Marketing Group, Inc. (DMG).

The Novo Solutions development team is undertaking this project. The team is comprised of
undergraduate students majoring in Computer Science at California State University,
Sacramento. The team members are enrolled in a two-semester senior project course required of
all undergraduate majors. Successful delivery of the desired software product will fulfill the
senior project requirement for the student team members.

PROJECT SPONSOR:
Scott Drummond – President / CEO
Digital Marketing Group, Inc
(916) 804-1166
sdrummond@DigitalMG.com

DEVELOPMENT TEAM:             Novo Solutions
www.NovoSolutions.org


Dong Nguyen                                    Mike Starovoytov
sac77329@saclink.csus.edu                      mike_starov@hotmail.com
916 - 807 – 3019                               916 - 308 - 8678


Wes Krasko                                     Elliott Trevino
wes@worldwidewes.com                           thetrevinos@peoplepc.com
916 - 698 – 3246                               530 - 677 - 7695


Hsiaolin Chu                                   David Burton
hsiaolin@hotmail.com                           dburton@csus.edu
916 - 743 – 6716                               707 - 448 - 1765


The remainder of this section is intended to introduce the reader to the document and to serve as
a high level, executive-like summary to the document.


1.1 Purpose
The System Test Report summarizes the results of the designated testing activities identified in
the System Test Specification document and provides evaluations based on these tests.


                                      ~Novo Solutions~                                              3
1.2 Scope
The System Test Report includes only the results and evaluations from testing the
implementation of each of the system’s Use Cases. The testing reported is that which was
specified in the System Test Specification document.


1.3 Definitions, Acronyms, and Abbreviations
This subsection serves as a glossary for the document. All technical terms used as well as all
acronyms and abbreviations used are arranged in alphabetical order. The purpose of this
subsection is to provide the reader with quick access to the technical references used throughout
the document.


1.3.1 Definitions

Actor          An entity that uses the system. Every Actor has use cases associated with it.

Baseline        A baseline is a work product that has been formally reviewed and accepted by the
involved parties. A baseline is changed only through formal configuration management
procedures. Software Requirements Specification. Documentation of the essential requirements
(functions/features/uses, performance, design constraints, and attributes) of the software and its
external interfaces.

MySQL        An open source relational database management system that uses Structured
Query Language (SQL) for adding, accessing, and processing data in a database.

Task           The smallest unit of work subject to management accountability.

Use Case        The use case model consists of actors, use cases, and relations among them.
Actors represent everything that must exchange information with the system, including what are
typically called users. When an actor uses the system, the system performs a use case.

Software       A document reporting on any event that occurs during the testing process which
Problem        requires investigation.
Report

Test case       A document specifying inputs, predicted results, and a set of execution conditions
for specification. A test item.

Test design A document specifying the details of the test approach for a software feature or
specification. A combination of software features (i.e. a Use Case) and identifying the
associated tests.

Test item      A software component (or components) that are an object of testing.

Test log       A chronological record of relevant details about the execution of tests.

Test plan        A document describing the scope, approach, resources, and schedule of intended
testing activities. It identifies test items, the features (i.e. Use Cases) to be tested, the testing
tasks, who will do each task, and any risks requiring contingency planning.


                                        ~Novo Solutions~                                                4
Test          A document specifying a sequence of actions for the execution of a test.
procedure specification.

Test report A document summarizing testing activities and results. It also contains an
evaluation of the corresponding test items.


1.3.2 Acronyms

CD-MM          Software Maintained Manual – Contents of the Project CD

CSS            Cascading Style Sheets

DMG            Digital Marketing Group, Inc.

EER              Enhanced Entity Relationship – A method of modeling relationships between
entities in a relational database.

IEEE           Institute of Electrical and Electronics Engineers

IIS            Internet Information Server, Web-server, part of the Windows NT/2000/2003
Server

ISP           Internet Service Provider, the organization responsible for hosting and
maintaining the Project Sponsor’s server.

J2RE           Java 2 Runtime Environment

JDBC           Java Database Connectivity

JSP          Java Server Pages - a scripting language based on Java for developing dynamic
Web pages and sites.

HTML        Hypertext Markup Language. The document format language used on the World
Wide Web. Web browsers read HTML and display the page.

HTTP           Hyper Text Transport Protocol is the communication protocol used to connect to
servers on the World Wide Web. The primary function of HTTP is to establish a connection with
a Web server and transmit HTML pages to the user's browser.

HTTPS          HTTP with SSL (secure socket layer) encryption for security

.NET            Microsoft's framework for Web services and component software introduced in
2000 and pronounced "dot-net." .NET is Microsoft's approach to a comprehensive development
and runtime environment similar to J2EE. .NET supports all the Web-based features and
functions, including XML and the Web services protocols such as SOAP and UDDI (see Web
services). .NET applications run on intranets as well as public Internet sites, thus .NET is an all-
inclusive Web-oriented software architecture for internal and external use. Subsequent versions
of Microsoft products (browsers, applications, Windows) were enhanced with support for .NET
in some manner.

SAG            Sac Air Games

                                        ~Novo Solutions~                                               5
SDS            Software Design Specification

SSP            Software System Proposal

SRS            Software Requirements Specification

SQL            Structure Query Language – a language that is mainly to store and retrieve
information from a database.


1.3.3 Abbreviations

IEM            Inventory and Employee Management software

CSUS           California State University, Sacramento

ECS            (CSUS) The College of Engineering and Computer Science


1.4 References
The following documents and books were used in the preparation of this document.

[1] Buckley, R. Guide to Preparing the Software Project Management Plan. Version 3.29.04.

[2] Webopedia, Online Dictionary and Search Engine. 9 Mar, 2005
<http://www.webopedia.com>


1.5 Overview
This subsection briefly describes the remaining contents of the document.

Section 2 contains the summary evaluation of the test results for each of the implemented Use
Cases.

Section 3 describes whatever variances might exist between the items tested and their design
specification and/or requirements specifications.

Section 4 provides an evaluation of the comprehensiveness of the testing process against the
testing criteria specified in the system test plan contained in the System Test Specification
document.

Section 5 contains the approval page. The signatures indicate approval of the system testing
process and the results as documented in this report by all team members and the project’s
faculty adviser.

Appendix A contains the test logs for each of the testing sessions.

Appendix B contains all Software Problem Reports organized by Use Case, that is, for each Use
Case the reports are included in chronological order.



                                       ~Novo Solutions~                                         6
2   SUMMARY
This section includes an evaluation of the test results for each of the implemented Use Cases.

2.1 Login/Logout
This subsection describes test results of Login/Logout use case.

Test Items
index.jsp
login.jsp
logout.jsp

Test Cases in STS
Login (Section 4.4.1.1)
Logout (Section 4.4.2.1)

Testing Environment
Browser: Internet Explorer ver. 6.0 with JavaScript and CSS support
Internet Connection: Broadband

Test Logs
Test Log 3

Test Incident Reports
Software Problem Report 3

Testing Evaluation
The testing did not reveal any major bugs. All test cases executed successfully.


2.2 View Contact List
This subsection describes test results of View Contact List use case.

Test Items
contacts.jsp

Test Cases in STS
View Contact List (Section 4.4.2.1)

Testing Environment
Browser: Internet Explorer ver. 6.0 with JavaScript and CSS support
Internet Connection: Broadband

Test Logs
Test Log 3

Test Incident Reports
N/A

Testing Evaluation
The testing did not reveal any major bugs. All test cases executed successfully.


                                       ~Novo Solutions~                                          7
2.3 Check Schedule
This subsection describes test results of Check Schedule use case.

Test Items
sch-check.jsp

Test Cases in STS
Check Schedule (Section 4.4.3.1)

Testing Environment
Browser: Internet Explorer ver. 6.0 with JavaScript and CSS support
Internet Connection: BroadBand

Test Logs
Test Log 3

Test Incident Reports
N/A

Testing Evaluation
The testing did not reveal any major bugs. All test cases executed successfully.


2.4 View/Edit Availability
This subsection describes test results of View/Edit Availablity use case.

Test Items
availability.jsp
availability.java
add-times.jsp

Test Cases in STS
View Availability (Section 4.4.5.1)
Edit Unavailable Time (Section 4.4.5.2)
Add Unavailable Time (Section 4.4.5.3)

Testing Environment
Browser: Internet Explorer ver. 6.0 with JavaScript and CSS support
Internet Connection: Broadband

Test Logs
Test Log 3

Test Incident Reports
N/A

Testing Evaluation
The testing did not reveal any major bugs. All test cases executed successfully.




                                       ~Novo Solutions~                            8
2.5 View/Add/Edit Inventory
This subsection describes test results of View/Add/Edit Inventory use case.

Test Items
inventory.jsp
inventory.java
inv-results.jsp
add-inv.jsp
view-inv.jsp
edit-inv.jsp

Test Cases in STS
Check/Adjust Inventory (Section 4.4.6.1)
Add Item (Section 4.4.6.2)
Inventory Result (Section 4.4.6.3)
View Inventory Item (Section 4.4.6.4)
Edit Inventory Item (Section 4.4.6.5)

Testing Environment
Browser: Internet Explorer ver. 6.0 with JavaScript and CSS support
Internet Connection: Broadband

Test Logs
Test Log 3

Test Incident Reports
N/A

Testing Evaluation
The testing did not reveal any major bugs. All test cases executed successfully.


2.6 View Event Detail
This subsection describes test results of View Event Detail use case.

Test Items
event-select.jsp
event-list.jsp
event-detail.jsp
event-detail-printable.jsp

Test Cases in STS
Select Event (Section 4.4.4.1)
List Event (Section 4.4.4.2 )
Event Detail (Section 4.4.4.3 )
Event Detail Printable (Section 4.4.4.4 )

Testing Environment
Browser: Internet Explorer ver. 6.0 with JavaScript and CSS support
Internet Connection: Broadband



                                       ~Novo Solutions~                            9
Test Logs
Test Log 3

Test Incident Reports
N/A

Testing Evaluation
The testing did not reveal any major bugs. All test cases executed successfully.


2.7 Schedule/Modify Events
This subsection describes test results of Schedule/Modify Events use case.

Test Items
view-edit-event.jsp
cust-select.jsp
cust-list.jsp
cust-edit.jsp
cust-create.jsp
add-event.jsp

Test Cases in STS
View/Edit Event (Section 4.4.7.1)
Add Event for Customer (Section 4.4.7.2)

Testing Environment
Browser: Internet Explorer ver. 6.0 with JavaScript and CSS support
Internet Connection: BroadBand

Test Logs
Test Log 1

Test Incident Reports
Software Problem Report 1

Testing Evaluation
The testing did not reveal any major bugs. All test cases executed successfully.


2.8 Add/Edit Employees
This subsection describes test results of Add/Edit Employees use case.

Test Items
add-edit-employees.jsp
edit-employee.jsp

Test Cases in STS
View/Edit Employee (Section 4.4.8.1)
Add Employee (Section 4.4.8.2)




                                     ~Novo Solutions~                              10
Testing Environment
Browser: Internet Explorer ver. 6.0 with JavaScript and CSS support
Internet Connection: BroadBand

Test Logs
Test Log 2

Test Incident Reports
Software Problem Report 2

Testing Evaluation
The testing did not reveal any major bugs. All test cases executed successfully.

3   VARIANCES
The test specification and test cases were written using the content of the design specification.
There is no variance between the item tested and the design specification.


4   COMPREHENSEVNESS OF THE TESTING PROCESS
From the system test specification, a test case was developed for each implementation of a use
case. A navigation test case was created to test the navigation system of the software.
Furthermore, to illustrate the data integrity of the database, we created a matrix to validate the
referential integrity of the foreign key and primary key of each table.

Use Case                       Test Case                       STS section
Login/Logout                   Login                           4.4.1.1
                               Logout                          4.4.1.2
View Contact List              View Contact List               4.4.2.1
Check Schedule                 Check Schedule                  4.4.3.1
View Event Detail              Select Event                    4.4.4.1
                               List Event                      4.4.4.2
                               Event Detail                    4.4.4.3
                               Event Detail Printable          4.4.4.4
View/Edit Availability         View Availability               4.4.5.1
                               Edit Unavailable Time           4.4.5.2
                               Add Unavailable Time            4.4.5.3
View/Add/Edit Inventory        Check/Adjust Inventory          4.4.6.1
                               Add Item                        4.4.6.2
                               Inventory Result                4.4.6.3
                               View Inventory Item             4.4.6.4
Schedule/Modify Events         View/Edit Event                 4.4.7.1
                               Add Event for Customer          4.4.7.2

Add/Edit Employee              View/Edit Employee              4.4.8.1
                               Add Employee                    4.4.8.2
                               Software Navigation             4.4.9.1
                               Data Integrity                  4.4.10.1




                                      ~Novo Solutions~                                               11
5   APPROVALS

Signatures indicate approval of the system testing process and the results as documented in this
report. This section contains the signatures of each team member along that of the project’s
faculty adviser.

NOVO SOLUTIONS
Senior project team

Project Manager: David Burton

                 Signature________________________________ Date__________

Team Members: Dong Nguyen

                 Signature________________________________ Date__________

                 Hsiaolin Chu

                 Signature________________________________ Date__________

                 Wesley Krasko

                 Signature________________________________ Date__________

                 Mikhail Starovoytov

                 Signature________________________________ Date__________

                 Elliott Trevino

                 Signature________________________________ Date__________

CSUS Computer Science Department

Senior Project Advisor: Gopal Rao

                 Signature________________________________ Date__________




                                     ~Novo Solutions~                                          12
APPENDIX A: TEST LOGS


TEST LOG 1

USE CASE: Schedule/Modify Events _______________________________________________

TEST ITEMS
   view-edit-event.jsp
   cust-select.jsp
   cust-list.jsp
   cust-edit.jsp
   cust-create.jsp
   add-event.jsp

TEAM MEMBER: Mike Starovoytov _______________________________________________

TEST ENVIRONMENT: Web Browser: IE v. 6.0, connected to website through DSL
connection ____________________________________________________________________

TESTING ACTIVITIES

      1.   DATE: 11/14/2005 _______________ TIME: 10:39:26 PM __________________
           DESCRIPTION: Login: Username: Mike. Pass: admin _______________________
            ___________________________________________________________________
           RESULT: Welcome Screen and navigation menu with options: View Contact List,
           Check Schedule, View Event Detail, View/Edit Availability, Logout ____________
            ___________________________________________________________________
           SUCCESSFUL: Yes / No
           If unsuccessful what happened: __________________________________________
           Software Problem Report Template: Yes / No

      2.   DATE: 11/14/2005 _______________ TIME: 10:44:03 PM __________________
           DESCRIPTION: Click on the View Event Detail option on the Navigation menu __
            ___________________________________________________________________
           RESULT: Page with calendar showing current month. Dates colored as magenta
           wich are not linkable, red and green. Search by customer form. ________________
            ___________________________________________________________________
           SUCCESSFUL: Yes / No
           If unsuccessful what happened: __________________________________________
           Software Problem Report Template: Yes / No

      3.   DATE: 11/14/2005 _______________ TIME: 10:46:53 PM __________________
           DESCRIPTION: Change month and year. _________________________________
           ___________________________________________________________________
           RESULT: The calendar changed accordingly to the month, year selected. Checked
           with printed calendar. _________________________________________________
           ___________________________________________________________________
           SUCCESSFUL: Yes / No

                                 ~Novo Solutions~                                      13
     If unsuccessful what happened: __________________________________________
     Software Problem Report Template: Yes / No

4.   DATE: 11/14/2005 _______________ TIME: 10:55:06 PM __________________
     DESCRIPTION: Click on green date from calendar: Nov 01, 2005 _____________
      ___________________________________________________________________
     RESULT: One event listed: 10:00 AM Monkey Swing Yes ___________________
      ___________________________________________________________________
     SUCCESSFUL: Yes / No
     If unsuccessful what happened: __________________________________________
     Software Problem Report Template: Yes / No

5.   DATE: 11/14/2005 _______________ TIME: 10:57:28 PM __________________
     DESCRIPTION: Click on red date from calendar: Nov 05, 2005 _______________
      ___________________________________________________________________
     RESULT: One event listed in red: 03:00 PM Jimmys Birthday No ______________
      ___________________________________________________________________
     SUCCESSFUL: Yes / No
     If unsuccessful what happened: __________________________________________
     Software Problem Report Template: Yes / No


6.   DATE: 11/14/2005 _______________ TIME: 10:59:49 PM ___________________
     DESCRIPTION: Click on gray date from calendar: Nov 02, 2005 _____________
      ___________________________________________________________________
     RESULT: No Events are listed.__________________________________________
      ___________________________________________________________________
     SUCCESSFUL: Yes / No
     If unsuccessful what happened: __________________________________________
     Software Problem Report Template: Yes / No

7.   DATE: 11/14/2005 _______________ TIME: 11:03:16 PM ___________________
     DESCRIPTION: Select Last Name in Search By menu and enter name Rice. Hit
     Enter ______________________________________________________________
      ___________________________________________________________________
     RESULT: JSP Exception Report is displayed.
     java.lang.NumberFormatException: null
     java.lang.Integer.parseInt(Unknown Source)
     java.lang.Integer.parseInt(Unknown Source)
     org.apache.jsp.event_002dlist_jsp._jspService(org.apache.jsp.event_002dlist_jsp:21
     5)
     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:802) ___________________

     SUCCESSFUL: Yes / No
     If unsuccessful what happened: Probably page got submitted without parameters __
     Software Problem Report Template: Yes / No


                            ~Novo Solutions~                                        14
8.    DATE: 11/16/2005 _______________ TIME: 9:39:26 PM ___________________
      DESCRIPTION: Login: Username: Mike. Pass: admin _______________________
       ___________________________________________________________________
      RESULT: Welcome Screen and navigation menu with options: View Contact List,
      Check Schedule, View Event Detail, View/Edit Availability, Logout ____________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

9.    DATE: 11/16/2005 _______________ TIME: 9:44:03 PM ___________________
      DESCRIPTION: Click on the View Event Detail option on the Navigation menu __
       ___________________________________________________________________
      RESULT: Page with calendar showing current month. Dates colored as magenta
      wich are not linkable, red and green. Search by customer form. ________________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

10.   DATE: 11/16/2005 _______________ TIME: 9:46:53 PM ___________________
      DESCRIPTION: Change month and year. _________________________________
       ___________________________________________________________________
      RESULT: The calendar changed accordingly to the month, year selected. Checked
      with printed calendar. _________________________________________________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

11.   DATE: 11/16/2005 _______________ TIME: 9:55:06 PM ___________________
      DESCRIPTION: Click on green date from calendar: Nov 01, 2005 _____________
       ___________________________________________________________________
      RESULT: One event listed: 10:00 AM Monkey Swing Yes ___________________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

12.   DATE: 11/16/2005 _______________ TIME: 9:57:28 PM ___________________
      DESCRIPTION: Click on red date from calendar: Nov 05, 2005 _______________
       ___________________________________________________________________
      RESULT: One event listed in red: 03:00 PM Jimmys Birthday No ______________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No


13.   DATE: 11/16/2005 _______________ TIME: 9:59:49 PM ____________________
      DESCRIPTION: Click on gray date from calendar: Nov 02, 2005 _____________

                            ~Novo Solutions~                                      15
       ___________________________________________________________________
      RESULT: No Events are listed.__________________________________________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

14.   DATE: 11/16/2005 _______________ TIME: 10:03:16 PM ___________________
      DESCRIPTION: Select Last Name in Search By menu and enter name Rice. Hit
      Enter ______________________________________________________________
       ___________________________________________________________________
      RESULT: “Events for – Rice” string is displayed with empty table. _____________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

15.   DATE: 11/16/2005 _______________ TIME: 10:06:16 PM ___________________
      DESCRIPTION: Go back to calendar and click on 11/1/05 from calendar. _______
       ___________________________________________________________________
      RESULT: The table with list of events for 1/11/05 is displayed. Plus the table with
      items available on that day. _____________________________________________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

16.   DATE: 11/16/2005 _______________ TIME: 10:09:16 PM ___________________
      DESCRIPTION: Click on edit link next to first event in the list. _______________
       ___________________________________________________________________
      RESULT: Page with event details presented in editable controls. _______________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No


17.   DATE: 11/16/2005 _______________ TIME: 10:12:16 PM ___________________
      DESCRIPTION: Modify information in boxes. Put valid information. And click
      Submit _____________________________________________________________
       ___________________________________________________________________
      RESULT: Page with current month calendar is displayed. _____________________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

18.   DATE: 11/16/2005 _______________ TIME: 10:16:16 PM ___________________
      DESCRIPTION: Modify information in boxes. Put invalid information. And click
      Submit _____________________________________________________________
      ___________________________________________________________________
      RESULT: Error messages are displayed next to the edit controls with invalid data. _

                             ~Novo Solutions~                                         16
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

19.   DATE: 11/16/2005 _______________ TIME: 10:20:16 PM ___________________
      DESCRIPTION: Login as mike/admin. On the event-select page chose 11/2 date.
      Click on it, then on event list page click on add an event. _____________________
       ___________________________________________________________________
      RESULT: A form for customer searching or adding a customer appears. _________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

20.   DATE: 11/16/2005 _______________ TIME: 10:21:16 PM ___________________
      DESCRIPTION: Search for terra by first name. Click Search. _________________
       ___________________________________________________________________
      RESULT: Listing of customers appear. Terra, Sky is the only entry. _____________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

21.   DATE: 11/16/2005 _______________ TIME: 10:24:16 PM ___________________
      DESCRIPTION: Search for customer with last name Rice. ___________________
       ___________________________________________________________________
      RESULT: Same page appears but no customers listing. Instead it says that search
      returned 0 results. ____________________________________________________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

22.   DATE: 11/16/2005 _______________ TIME: 10:25:16 PM ___________________
      DESCRIPTION: Click on New Customer. ________________________________
       ___________________________________________________________________
      RESULT: Page with fields for new customer information appears. ______________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

23.   DATE: 11/16/2005 _______________ TIME: 10:29:16 PM ___________________
      DESCRIPTION: Fill in customer information. Use customer info in section 4.3.7
      of STS. _____________________________________________________________
       ___________________________________________________________________
      RESULT: New customer is saved and page for event creation is displayed. _______
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No

                             ~Novo Solutions~                                       17
24.   DATE: 11/16/2005 _______________ TIME: 10:30:16 PM __________________
      DESCRIPTION: Fill in event info. Use info in section 4.3.7 of STS. ____________
       ___________________________________________________________________
      RESULT: Event is saved and page with current month calendar is displayed. _____
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No


25.   DATE: 11/16/2005 _______________ TIME: _____________________________
      DESCRIPTION: _____________________________________________________
       ___________________________________________________________________
      RESULT: ___________________________________________________________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No


26.   DATE: 11/16/2005 _______________ TIME: _____________________________
      DESCRIPTION: _____________________________________________________
       ___________________________________________________________________
      RESULT: ___________________________________________________________
       ___________________________________________________________________
      SUCCESSFUL: Yes / No
      If unsuccessful what happened: __________________________________________
      Software Problem Report Template: Yes / No




                            ~Novo Solutions~                                      18
TEST LOG 2

USE CASE: Add/Edit Employees __________________________________________________

TEST ITEMS
   add-edit-employees.jsp
   edit-employee.jsp

TEAM MEMBER: Mike _________________________________________________________

TEST ENVIRONMENT: IE ver. 6.0 with JavaScript and CSS support ____________________

TESTING ACTIVITIES:

      1.   DATE: 11/14/2005 _______________ TIME: 9:58:23 PM ____________________
           DESCRIPTION: Login as administrator and click on Add/Edit Employees _______

           RESULT: Listing of all people currently employed by Sac Air Games ___________
            ___________________________________________________________________
           SUCCESSFUL: Yes / No
           If unsuccessful what happened: __________________________________________
           Software Problem Report Template: Yes / No

      2.   DATE: 11/14/2005 _______________ TIME: 10:00:23 PM ___________________
           DESCRIPTION: Click on Edit link next to Wes employee. ___________________

           RESULT: Form showing the employee’s information. _______________________
            ___________________________________________________________________
           SUCCESSFUL: Yes / No
           If unsuccessful what happened: __________________________________________
           Software Problem Report Template: Yes / No

      3.   DATE: 11/14/2005 _______________ TIME: 10:02:23 PM ___________________
           DESCRIPTION: Change username to mike. Password to 1234 This username is in
           use already __________________________________________________________

           RESULT: The employee listing appears again. No expected error is displayed. ____
            ___________________________________________________________________
           SUCCESSFUL: Yes / No
           If unsuccessful what happened: The system allowed to store duplicate username in
           the database._________________________________________________________
           Software Problem Report Template: Yes / No

      4.   DATE: 11/14/2005 _______________ TIME: 10:04:23 PM ___________________
           DESCRIPTION: Click on Edit link next to Bill employee. Change address to 2111
           Straight Street, Sacramento, 00000 _______________________________________

           RESULT: Employee listing appears. Clicking on Edit link next to Bill shows that
           address has been changed. ______________________________________________
            ___________________________________________________________________
           SUCCESSFUL: Yes / No
           If unsuccessful what happened: __________________________________________

                                 ~Novo Solutions~                                       19
     Software Problem Report Template: Yes / No

5.   DATE: 11/14/2005 _______________ TIME: 10:06:23 PM ___________________
     DESCRIPTION: ____________________________________________________

     RESULT: ___________________________________________________________
      ___________________________________________________________________
     SUCCESSFUL: Yes / No
     If unsuccessful what happened: __________________________________________
     Software Problem Report Template: Yes / No




                           ~Novo Solutions~                                20
TEST LOG 3

Use Case         Test Items               Tester   Testing     Date/Time   Success
                                                   Env
Login/Logout     User Name: John          Dong     Window XP   11/15/05    Yes
                 Password: Doe
                                                   1.3 Mhz
                                                   512MB
                                                   ram
View Contact                              Dong     Window XP   11/15/05    Yes
List                                               1.3 Mhz
                                                   512MB
                                                   ram
Check Schedule                            Dong     Window XP   11/15/05    Yes
                                                   1.3 Mhz
                                                   512MB
                                                   ram
View Event       Last Name: Rice          Dong     Window XP   11/15/05    Yes
                 First Name: Cooke
Detail                                             1.3 Mhz
                                                   512MB
                                                   ram
View/Edit        Date: 11/11/05           Dong     Window XP   11/15/05    Yes
Availability     Invalid Inputs:
                                                   1.3 Mhz
                 New Start Time: 2:00              512MB
                 am                                ram
                 New End Time: 1:00
                 am

                 Valid Inputs:
                 New Start Time: 3:00
                 pm
                 New End Time: 4:00
                 pm

                 Date: 11/27/05
View/Add/Edit    Invalid Inputs:          Dong     Window XP   11/15/05    Yes
                 Input: billy joel
Inventory                                          1.3 Mhz
                 Valid Inputs:                     512MB
                 Input: Candy                      ram
                 Machine

                 Item Name: Cotton
                 Active:
                 Checked
                 Description:
                            Machine
                 for making cotton
                 candy.
                 Notes :
                            Could only
                 use 2 at a time.

                 Item Name:
                           Cotton
                 Candy Mac
                 Active:           3
                 Description:
                           Use for
                 graduation only



                                         ~Novo Solutions~                            21
                  Notes:
                             Use 3 hours
                  max
Schedule/Modify   Event Information:        Dong     Window XP   11/15/05   Yes
                  Date: 16/09/2005
Events            Time: 2:00pm
                                                     1.3 Mhz
                  Event Name: Party                  512MB
                  at Suzy's                          ram
                  Even Description:
                  Party with bounce
                  house for Suzy Anne
                  Payment Information:
                  Partial payment of
                  $50.00 made.
                  Notes: Customer is
                  allergic to
                  mushrooms.
                  Customer: Suzy
                  Anne
                  Address: 1234
                  Gertrude Way
                  City: Sacramento
                  State: CA
                  Zipcode: 95821
                  Home Phone: 916
                  123-1234
                  Cell Phone: 916
                  123-4321
                  email:
                  bob@gmail.com
                  Party Location:
                  Same as customer
                  address?
                  Address: 1234
                  Gertrude Way
                  City: Sacramento
                  State: CA
                  Zipcode: 95821
                  Home Phone: 916
                  123-1234
                  Cell Phone: 916
                  123-4321
                  Host: Jimmy
                  Contractor: Jill
                  Inventory Drop-Off
                  Time Range: 11:30 -
                  12:00
                  Inventory Pick-Up
                  Time Range: 3:00 -
                  4:15
                  Items in the
                  inventory:
                  Cotton Candy
                  Machine
                  Customer
                  Information:
                  First Name: Bob
                  Last Name: Jones
                  Address: 1234
                  Rivercrest Lane
                  City: El Dorado Hills
                  State: CA
                  Zip Code: 98344
                  Home Phone: 916
                  123-5678
                  Cell Phone: 123 232
                  2323
                  Email:
                  bob@gmail.com


                                           ~Novo Solutions~                       22
           How did you hear
           about us?: Friend


           Invalid Inputs:
           Date: 16/09
           Address: 1234
           City: Sa
           State: C
           Zip code: 9582
           Home Phone: 23-
           1234
           Cell Phone: 123-
           4321
           Email: bob@gmail.
           Address: 1234
           City: Sac
           State: A
           Zip code: 958219
           Home Phone: 916
           123-
           Cell Phone: 916
           123-43
           Host: J
           Contractor: Jll
           Inventory Drop-Off
           Time Range: 12:00 -
           12:00
           Inventory Pick-Up
           Time Range: 3:00 -
           2:00
Add/Edit   Login: NewGuy          Dong     Window XP   11/15/05   Yes
           Password: passw0rd
Employee   Confirm Password:
                                           1.3 Mhz
           passw0rd                        512MB
           First Name: Bob                 ram
           Last Name: Jones
           Address: 222 Easy
           Street
           City: Sacramento
           State: CA
           Zip: 95660
           Home Phone: (916)
           999-9999
           Mobile Phone:
           Email:
           bobj@gmail.com
           Wage: 8.00
           SSN: 999999999
           Employee /
           Contractor?:
           Employee




           Invalid Inputs
           Confirm Password:
           somethingelse
           First Name: Bob
           Last Name: Jones
           Address: 222
           City: Sac
           State: CAL
           Zip: 9566
           Home Phone: (916)
           999
           Mobile Phone:
           Email: bobj@gmail.
           Wage: 8000

                                 ~Novo Solutions~                       23
SSN: 99999999
Employee /
Contractor?: manager
:




                       ~Novo Solutions~   24
APPENDIX B: SOFTWARE PROBLEM REPORTS

SOFTWARE PROBLEM REPORT                                                               Problem Report ID: 1

PROGRAM Inventory and Employee Management System                     RELEASE Alpha
            VERSION 1

REPORT TYPE                       SEVERITY                                            ATTACHMENTS: Yes
No
Coding Error Documentation        Fatal                                               If yes, list attachments
Design Error Hardware             Serious
Suggestion   Query                Minor

PROBLEM SUMMARY: An error is displayed if search event form is submitted via hitting Enter instead of
clicking Submit.

CAN YOU REPRODUCE THE PROBLEM? (Y/N) Y

PROBLEM AND HOW TO REPRODUCE: There is a problem with submission of the form that searches events
based on customer last name or first name.
Go to event-select.jsp. View Event Detail on navigation menu. Place cursor in search box and hit Enter. _____________

SUGGESTED FIX (optional) ________________________________________________________________________
________________________________________________________________________________________________
________________________________________________________________________________________________


REPORTED BY Mike Starovoytov                                                          DATE 11/14/2005

                            Items Below Are For Use Only By the Development Team

FUNCTIONAL AREA: Schedule/Modify Events _________________ASSIGNED TO Mike Starov _______________

COMMENTS: This is due to having multiple forms on this page. Enter submits the first one. Fixed by ignoring the
value of the first form if they are submitted to the next page. ________________________________________________
________________________________________________________________________________________________
________________________________________________________________________________________________
________________________________________________________________________________________________


STATUS:                                                              PRIORITY
Open             Closed                                              High             Medium             Low


RESOLUTION:                                                                   VERSION NO: 1

Pending          Deferred         Withdrawn by reporter
Fixed            As designed      Need more info
Irreproducible   Can’t be fixed   Disagree with suggestion

RESOLVED BY DATE 11/15/05

RESOLUTION TESTED BY DATE 11/15/05

TREAT AS DEFERRED: Yes No




                                            ~Novo Solutions~                                                     25
SOFTWARE PROBLEM REPORT                                                        Problem Report ID: 2

PROGRAM IEMS________________________             RELEASE Alpha________          VERSION 1________

REPORT TYPE                     SEVERITY                                       ATTACHMENTS: Yes
No
Coding Error Documentation      Fatal                                          If yes, list attachments
Design Error Hardware           Serious
Suggestion   Query              Minor

PROBLEM SUMMARY Website allows storing usernames that are already in use. The new user/password
overrides the old.

CAN YOU REPRODUCE THE PROBLEM? (Y/N) Y __

PROBLEM AND HOW TO REPRODUCE: Go to add new employee page and add a new user with username used
by some other user. ________________________________________________________________________________
________________________________________________________________________________________________
________________________________________________________________________________________________
________________________________________________________________________________________________
________________________________________________________________________________________________

SUGGESTED FIX (optional): Restrict the storage of duplicate usernames. ____________________________________
________________________________________________________________________________________________
________________________________________________________________________________________________


REPORTED BY: Mike Starovoytov                                                  DATE 11/17/2005
                       Items Below Are For Use Only By the Development Team

FUNCTIONAL AREA: Add/Edit Employees ____________________ASSIGNED TO Wes Krasko _______________

COMMENTS: The database never restricted uniqueness of the usernames. Fixed by checking if the username
already existed. ___________________________________________________________________________________
________________________________________________________________________________________________

STATUS:                                                        PRIORITY
Open            Closed                                         High            Medium             Low


RESOLUTION:                                                    VERSION NO: 1
Pending        Deferred         Withdrawn by reporter
Fixed          As designed      Need more info
Irreproducible Can’t be fixed   Disagree with suggestion

RESOLVED BY DATE 11/17/2005

RESOLUTION TESTED BY DATE 11/17/2005

TREAT AS DEFERRED: Yes No




                                          ~Novo Solutions~                                                26
SOFTWARE PROBLEM REPORT                                                                Problem Report ID: 3

PROGRAM Inventory and Employee Management System                      RELEASE Alpha
            VERSION 1

REPORT TYPE                        SEVERITY                                            ATTACHMENTS: Yes
No
Coding Error Documentation         Fatal                                               If yes, list attachments
Design Error Hardware              Serious
Suggestion   Query                 Minor

PROBLEM SUMMARY: An error is displayed if you login and then click back. This scenario is unlikely but still
should be investigated

CAN YOU REPRODUCE THE PROBLEM? (Y/N) Y

PROBLEM AND HOW TO REPRODUCE: Go to the website and login. Click on the back button. ________________

SUGGESTED FIX (optional) _______________________________________________________________________
________________________________________________________________________________________________
________________________________________________________________________________________________


REPORTED BY: Mike Starovoytov                                                          DATE 11/18/2005

                            Items Below Are For Use Only By the Development Team

FUNCTIONAL AREA: Login/Logout __________________________ASSIGNED: Wes Krasko __________________

COMMENTS: There is no expectation of the user to go back to the login that way. It is not SSL though, it's
because there is a page between login and index that processes the login, so when you hit back, it tries to go to that
page, not login.jsp. Either way, it can be easily fixed. _____________________________________________________

STATUS:                                                               PRIORITY
Open             Closed                                               High             Medium             Low


RESOLUTION:                                                                   VERSION NO: 1

Pending          Deferred          Withdrawn by reporter
Fixed            As designed       Need more info
Irreproducible   Can’t be fixed    Disagree with suggestion

RESOLVED BY DATE 11/20/05

RESOLUTION TESTED BY DATE 11/20/05

TREAT AS DEFERRED: Yes No




                                             ~Novo Solutions~                                                     27

								
To top