JSQL Edit v 1 0 Requirements Presentation JSQL

JSQL Edit v 1. 0 Requirements Presentation JSQL Edit Team | 03. 15. 02 >Introduction JSQL Edit team Kanwar Hazrah & Rana Khartabil & Irwin Kwan & Benson Chan

JSQL Edit v 1. 0 Requirements Presentation JSQL Edit Team | 03. 15. 02 >Customer & Problem The Customer - Cognos Inc. , business intelligence software maker - Gururaj Deshpande, user-interface manager The Problem - Developers are using an array of SQL editors - Need to simplify the process of working on the diverse databases (consistent GUI)

JSQL Edit v 1. 0 Requirements Presentation JSQL Edit Team | 03. 15. 02 >Solution overview System Description - Java and JDBC-based SQL editor - Connectivity to Oracle & My. SQL (for final deliverable) - Provides consistent easy-to-use GUI Value to customer - Streamlined database-querying for different DBMS’ - Shorter learning-curve for developers working on different DBMS’ - Proof-of-concept for use of JDBC capabilities

JSQL Edit v 1. 0 Requirements Presentation JSQL Edit Team | 03. 15. 02 >Requirements Main Functional Requirements - Connectivity to Oracle & My. SQL through JDBC - Intuitive GUI - Edit SQL statements - Query databases - View results in tabular form - Tree-view of database

JSQL Edit v 1. 0 Requirements Presentation >GUI_Scenario Use-case scenario JSQL Edit Team | 03. 15. 02

JSQL Edit v 1. 0 >GUI_Scenario Requirements Presentation JSQL Edit Team | 03. 15. 02

JSQL Edit v 1. 0 >GUI_Scenario Requirements Presentation JSQL Edit Team | 03. 15. 02

JSQL Edit v 1. 0 Requirements Presentation JSQL Edit Team | 03. 15. 02

JSQL Edit v 1. 0 >GUI_Scenario Requirements Presentation JSQL Edit Team | 03. 15. 02

JSQL Edit v 1. 0 Requirements Presentation JSQL Edit Team | 03. 15. 02

JSQL Edit v 1. 0 >Architecture high-level view Requirements Presentation JSQL Edit Team | 03. 15. 02

JSQL Edit v 1. 0 Requirements Presentation JSQL Edit Team | 03. 15. 02 >Details Technologies used - Java 1. 4 w/ Swing - JDBC 2. 0 - Source. Forge. net for project management tools

JSQL Edit v 1. 0 Requirements Presentation JSQL Edit Team | 03. 15. 02 >Testing QA process description - Unit testing, System testing, GUI evaluation & manual testing - Built-in testing in code for automation - Test data/validation data design based on requirements & dummy data from customer - Testing/regression testing in every project phase - Usability test sessions at Cognos

JSQL Edit v 1. 0 Requirements Presentation JSQL Edit Team | 03. 15. 02 >Project Plan Brahma Phase (Creator God) May 2002 V. 02 Alpha 1 Client prototype Connectivity & basic querying Vishnu Phase (Preserver God) September 2002 V. 06 Beta 1 Release GUI: Basic Tree-view, tool bar SQL parsing for edit box Mahesh Phase (Giver God) December 2002 V. 1 Client Release GUI: Complete Tree-view, drag & drop

JSQL Edit v 1. 0 Requirements Presentation >Q&A JSQL Edit Team | 03. 15. 02