CS 327/329 2002-2003 PROJECT WEBSITE

dbViZ Documentation



Inception Phase Documents

Name Version Last Updated Author Archive Reviews
Vision 1.2 12/09/2002 Abhay Sathe Vision by Brian Sidharta
by David Hampsire
Risk List 1.2 12/09/2002 Ross Paul & Sonia Kaura Risk List by Brian Sidharta
by David Hampsire
Glossary 1.2 12/07/2002 Jianmei Fan Glossary by David Hampsire
Development Case 1.1 12/08/2002 Brian Sidharta Development Case by David Hampsire
Software Development Plan 1.4 02/09/2002 Brian Sidharta & Aleksandra Faust Software Development Plan by David Hampsire
Interation 2 Plan 1.0 10/24/2002 Brian Sidharta    
Interation 2 Assesment 1.0 10/29/2002 Brian Sidharta    


Use Cases

Name Priority Version Last Updated Author Archive Reviews
Use Case Model   1.3 02/28/2003 Brian Sidharta Use Case Model by David Hampsire
Install the DbViz Low 1.2 03/07/2003 Larry Knox Install the DbViz by Brian Sidharta
by David Hampsire
Start the DbViz High 1.1 12/10/2002 Abhay Sathe Start the DbViz by Brian Sidharta
by David Hampsire
Connect to a Database Medium 1.1 12/09/2002 Abhay Sathe Connect to Database by David Hampsire
Import schema into the DbViz High 1.1 12/10/2002 Sonia Kaura/Abhay sathe Import schema by David Hampsire
Import schema from SQL File High 1.0 12/06/2002 Sonia Kaura   by Brian Sidharta
by David Hampsire
Import schema from Database Low 1.1 03/16/2003 Uday Kale Import Schema From Database by Brian Sidharta
by David Hampsire
Load a saved ER Diagram into the DbViz Low 1.1 12/10/2002 Abhay Sathe Load Saved ER Diagram  
Create Entity-Relationship Diagram High 1.1 12/12/2002 Brian Schoudel Create ER Diagram by Brian Sidharta
by David Hampsire
Remove table from Entity-Relationship Diagram High 1.1 12/12/2002 Brian Schoudel Remove Table from ER Diagram by Brian Sidharta
by David Hampsire
Add table to the Entity-Relationship Diagram High 1.1 12/14/2002 Aleksandra Faust Add table to the ERD by Brian Sidharta
by David Hampsire
Undo-Redo Low 1.0 12/05/2002 Jianmei Fan    
Print Diagram Low 1.1 12/05/2002 Brian Sidharta & Jianmei Fan Print Diagram  
Add Column to the Query Medium 1.1 12/12/2002 Brian Schoudel Add Column to Query by Brian Sidharta
by David Hampsire
Remove Column to the Query Medium 1.0 12/14/2002 David Hampshire    
Execute the Query Medium 1.1 12/12/2002 Brian Schoudel Execute the Query by David Hampsire
Exit the DbViz High 1.1 12/12/2002 Brian Schoudel Exit the DbViz by Brian Sidharta
by David Hampsire
Auto Arrange Diagram Low 1.1 03/13/2003 Aleksandra Faust Auto Arrange Diagram  
Save/Load Diagram Medium 1.0 03/30/2003 Uday Kale Save/Load Diagram  


Elaboration Phase Documents

Name Type Version Last Updated Author Archive Reviews
Interation 1 Assesment Document 1.0 12/05/2002 Brian Sidharta    
Interation 2 Plan Document 1.0 12/07/2002 Brian Sidharta    
Software Architecture Document 1.5 12/13/2002 Ross Paul & Sonia Kaura & Jianmei Fan Software Architecture by Brian Sidharta
by David Hampsire
Package Package Diagram 1.0 10/13/2002 Brian Sidharta & Ross Paul    
Schema Package Class Diagram 2.0 02/13/2003 Brian Sidharta & Ross Paul Schema by David Hampsire
GUI Package - Part 1 Class Diagram 2.0 02/13/2003 Brian Sidharta & Ross Paul Gui  
GUI Package - Part 2 Class Diagram 2.0 02/13/2003 Brian Sidharta & Ross Paul Diagram  
Main Package Class Diagram 2.0 02/13/2003 Brian Sidharta & Ross Paul Main  
Imports Package Class Diagram 2.0 02/13/2003 Brian Sidharta & Ross Paul Imports  
Coding Standards Document 1.1 12/12/2002 Ross Paul Coding Standards by Brian Sidharta
by David Hampsire
SQL Grammar Specification Text Document 1.1 12/12/2002 Aleksandra Faust SQL Grammar Specification  
Import Schema Sequence Diagram 1.0 12/11/2002 Abhay Sathe    
Master Test Plan Document 1.1 03/02/2003 Saurabh Gandotra Master Test Plan  
dbViz Project Review Report 1.0 12/12/2002 Jianmei Fan    


Construction Phase Documents

Name Version Last Updated Author Archive Reviews
Iteration Plan 1 1.1 03/02/2003 Brian Sidharta
Iteration Assessment 1 1.1 03/06/2003 Brian Sidharta

Transition Phase Documents

Name Version Last Updated Author Archive Reviews
Iteration Plan 1 1.1 04/29/2003 Brian Sidharta


Use Case Realization Documents

Name Version Last Updated Author Archive Reviews
Import Schema From SQL File 1.1 12/11/2002 Aleksandra Faust Load Saved Schema by David Hampsire
Import Schema from Database 1.0 12/06/2002 Sonia Kaura    


Test Cases

Name Description Last Updated Author Archive Reviews
Successfully tested against SQL Importer Subset of Sandra's SQL 12/16/2002 Brian Schoudel    
Valid Test Data for SQL Import   12/01/2002 Aleksandra Faust    
Invalid Test Data for SQL Import Invalid CREATE TABLE statement 12/01/2002 Aleksandra Faust    
Invalid Test Data for SQL Import References table that doesn't exist 12/14/2002 Aleksandra Faust    
Invalid Test Data for SQL Import References field that doesn't exist 12/14/2002 Aleksandra Faust    
Invalid Test Data for SQL Import Foreign key to a field that is not a primary key. 12/14/2002 Aleksandra Faust    
AutoArrangeFunctional.doc Auto Arrange Tables - Functional Test Case 05/04/2003 Aleksandra Faust    
AutoArrangeVolume.doc Auto Arrange Tables - Volume Test Case 05/04/2003 Aleksandra Faust    
ImportFromSQLFile.doc Import from SQL File - Functional Test Case 05/04/2003 Aleksandra Faust    
ImportFromSQLFileVolume.doc Import from SQL File - Volume Test Case 05/04/2003 Aleksandra Faust    
TCStartDbViz.doc Start dbViz - Functional Test Case 05/12/2003 Aleksandra Faust    
TCCloseDbViz.doc Close dbViz - Functional Test Case 05/12/2003 Aleksandra Faust    
TCInstallWindows.doc Install for Windows dbViZ - Functional Test Case 05/12/2003 Aleksandra Faust    
TCSwitchDiagrams.doc Switch Between Diagrams - Functional Test Case 05/12/2003 Aleksandra Faust    
TCCloseDiagram.doc Close Diagram - Functional Test Case 05/12/2003 Aleksandra Faust    
TCSaveDiagramBig.doc Save Diagram - Volume Test Case 05/12/2003 Aleksandra Faust    
TestCasePrintBigDiagram.doc Print Diagram - Volume Test Case 05/08/2003 Ross Paul    
TestCasePrintPreview.doc Print Preview - Volume Test Case 05/08/2003 Ross Paul    
TestCaseUndoRedo.doc Undo/Redo - Functional and Volume Test Case 05/08/2003 Ross Paul    
DbimportTestCase.DOC Import Schema from Oracle Database - Functional Test Case 05/03/2003 Uday Kale    
SaveLoadTestcase.DOC Save/Load Diagram - Functional Test Case 05/14/2003 Uday Kale    
TestCaseHelpAbout.doc Help-About - Functional Test Case 05/01/2003 Brian Sidharta    
TestCaseAddRemoveTablesF.doc Adding/Removing Tables - Functional Test Case 05/01/2003 Brian Sidharta    


Configuration Management

Name Version Last Updated Author Archive Reviews
Configuration Management 1.0 02/07/2003 Group #1    
Change Management 1.0 02/07/2003 Group #2    


Software Metrics

Name Version Last Updated Author Archive Reviews
DbViz Project Metrics Report 1.2 05/09/2003 Jim Rarick Metrics Report Archive  
Unused Objects & Percent of code as comments 1.0 02/20/2003 Brian Schoudel    
DIT & NOC 1.0 02/20/2003 Jim Rarick    
Lack of Cohesion of Methods & RFC 1.0 02/20/2003 Larry Knox    
WMC & CBO 1.0 02/20/2003 Uday Kale    
NCSS, MPC, Cyclomatic Complexity per method and class, Efferent and Afferent Couplings, LOC and System defects 1.0 02/20/2003 Group 2