ISCG7413 Testing and Quality Assurance Management

Assignment 2

Create a Test Management and Bug Tracking Database Application

Requirement

Congratulations on submitting the Business Requirements for your new testing division in your first assignment to the Cloud Accounting Company (CAC). In recognition of your good work, the Senior Management team has now asked you to design and develop a practical test management and bug tracking system for the organization. The test management and bug tracking database application should be designed and tested for general purpose of recording and tracking test cases and reported bugs (defects). You are asked to demonstrate your system in a 15 minute presentation to the senior management team. You are also required to submit a written project report based on the following instructions.

Instructions

You need to write a project report that will contain the following information:

  • A title page
  • A table of contents
  • Introduction and Project Planning
  • Requirement Gathering: Testable requirements for the tracking system (include a glossary of all the fields/columns used in the tracking system with the usage and purpose of each field briefly explained).
  • Database Design: Logical Entity Relationship Diagram (normalized to the 3rd normal form) and Database tables definitions (includes attributes, primary and foreign keys).
  • System Design & Implementation: Design and development of the management and tracking system using a database management system and application development environment of your choice.
  • Test Case Design and Development: Design and development of requirement-based test cases and/or scripts that trace back to the testable requirements.
  • Test Execution and Reporting: Execute the test cases and track the progress of your test case execution and bug reporting.
  • Project Reflection and summary
  • Reference list

There is no expected word count.

  1. You may do this assignment as a group (max three group members) or individually.

Notes

Marks will be deducted for failure to follow the Department of Computing Guidelines for Writing and Presenting Assessment Items, in particular, sections referring to referencing and plagiarism. Plagiarism will be reported to the Program Director who may award zero marks or refer the matter to the Program Committee, who has powers of suspension/exclusion.

Please make sure you keep a backup copy of your assignment.

Marks will be deducted if you fail to draw upon appropriate professional and academic literature in your writing and if the assignment is not written and presented in a professional manner.

Marking Sheet

Assessment Item

Mark

Report Presentation:

Professional, All sections present

Introduction and project planning

Reflection and Summary

10

Requirement Gathering:

Testable requirements for the tracking system

15

Database Design:

Entity Relationship Diagram

Database tables definitions

20

System design and implementation:

System Design; including but not limited to, screen designs, use case and state diagrams, etc...

Working or partially working application.

25

Test Case Design and Development:

 Design and development of requirement-based test cases and/or scripts that trace back to the testable requirements

15

Test Execution and Reporting:

Execute the test cases and track the progress of your test case execution and bug reporting

5

Project Demo & Presentation:

Demonstrate and test the tracking system.

NB. You need to be able to answer the questions related to your work

10