Collection Collection Inventory Inventory SoftwareSoftwareMay06-04 (CIST)May06-04 (CIST)

Eric AndersonEric AndersonAdam KovarAdam Kovar

Dustin LundeDustin LundeMatt MoellerMatt MoellerBrian StegerBrian Steger

February 28th, 2006

AdvisorsDr. J. Lamont P.E.

Professor R.E. Patterson III

ClientDr. D. Stuart

Presentation OverviewPresentation Overview Project OverviewProject Overview

DefinitionsDefinitions Problem StatementProblem Statement Intended Users/UsesIntended Users/Uses AssumptionsAssumptions LimitationsLimitations Expected End ProductExpected End Product

Project ActivitiesProject Activities Resources and ScheduleResources and Schedule Closure MaterialsClosure Materials

DefinitionsDefinitions

Attribute: A column in the databaseAttribute: A column in the database FreeDB: Free online database for CD FreeDB: Free online database for CD

informationinformation HSQLDB: Hyperthreaded Structured HSQLDB: Hyperthreaded Structured

Query Language Database Query Language Database Item: A row in the databaseItem: A row in the database Phase I: Dec04-01 senior design teamPhase I: Dec04-01 senior design team Phase II: May06-04 senior design teamPhase II: May06-04 senior design team

Problem StatementProblem Statement

People enjoy collecting items such as People enjoy collecting items such as music, movies, and booksmusic, movies, and books

There is a desire to organize and There is a desire to organize and inventory what is wanted and what inventory what is wanted and what is already ownedis already owned

Personal systems are often time-Personal systems are often time-consuming and limited in useconsuming and limited in use

Intended UsersIntended Users Professional and amateur collectorsProfessional and amateur collectors Novice to advanced computer usersNovice to advanced computer users

Intended UsesIntended Uses Efficient collection managementEfficient collection management Easy data retrieval through searching and Easy data retrieval through searching and

sortingsorting Importing/exporting collection informationImporting/exporting collection information

AssumptionsAssumptions

The work and source code from The work and source code from Phase I will be made availablePhase I will be made available

Windows, Linux, and Mac platforms Windows, Linux, and Mac platforms to be supportedto be supported

Multiple collections will be available Multiple collections will be available on one systemon one system

Internet access will be available for Internet access will be available for the use of FreeDBthe use of FreeDB

LimitationsLimitations

The work of Phase I will be used The work of Phase I will be used when possiblewhen possible

The level of user expertise will range The level of user expertise will range from novice to advancedfrom novice to advanced

Collection size will be limited to Collection size will be limited to available disk space on the user’s pcavailable disk space on the user’s pc

Software will only run on Java Software will only run on Java Runtime Environment 5.0Runtime Environment 5.0

Expected End ProductExpected End Product Fully functional and thoroughly Fully functional and thoroughly

tested Collection Inventory Softwaretested Collection Inventory Software Incorporated user manual and help Incorporated user manual and help

documentationdocumentation

Presentation OverviewPresentation Overview

Project OverviewProject Overview Project ActivitiesProject Activities

Present AccomplishmentsPresent Accomplishments Approaches ConsideredApproaches Considered ActivitiesActivities

Resources and ScheduleResources and Schedule Closure MaterialsClosure Materials

Present Present Accomplishments (1/2)Accomplishments (1/2)

Review of the existing codeReview of the existing code Focused the requirementsFocused the requirements Design review and refinementDesign review and refinement Finalized development platformFinalized development platform Primary functionality Primary functionality

Finalized Finalized ImplementedImplemented

User manual developedUser manual developed

Present Present Accomplishments (2/2)Accomplishments (2/2)

Interface redesignInterface redesign Detail PanelDetail Panel Search performed on main screenSearch performed on main screen

Working implementation of desired Working implementation of desired featuresfeatures CD lookupCD lookup Dynamic importing/exportingDynamic importing/exporting

Search PanelSearch Panel

Attribute List

Search Item

Comparator

Detail PanelDetail Panel

Action Buttons

Collection Statistics

Item Visibility

Item Details

CD LookupCD Lookup

Search Options

Search Results

CD Details

ImporterImporterImport File

File Structure

Attributes & Separators

Attribute Creator

Approaches Considered Approaches Considered – Development Platform– Development Platform

Approach 1 – JavaApproach 1 – Java Pros: Pros:

Multi-system Multi-system compatibilitycompatibility

FamiliarityFamiliarity Cons:Cons:

More difficult GUI More difficult GUI developmentdevelopment

Approach 2 – C#Approach 2 – C# Pros:Pros:

Easy GUI developmentEasy GUI development Cons: Cons:

Bound to WindowsBound to Windows Less robustLess robust

Selected – JavaSelected – Java To fulfill requirement of To fulfill requirement of

multi-system supportmulti-system support

Approach 1 – Editable Approach 1 – Editable tabletable Pros:Pros:

Ease of use and Ease of use and understandingunderstanding

Cons:Cons: Erratic behavior when Erratic behavior when

sortingsorting Too many columns to displayToo many columns to display

Approaches Considered Approaches Considered – User Input– User Input

Approach 2 – Detail PanelApproach 2 – Detail Panel Pros:Pros:

Clean display of all attributesClean display of all attributes Consistent location for data Consistent location for data

entryentry Cons: Cons:

Increased user navigationIncreased user navigation

Selected – Detail Selected – Detail PanelPanel Provides the user with Provides the user with

a consistent and easy a consistent and easy method of data inputmethod of data input

Approach 1 – Main Approach 1 – Main windowwindow Pros:Pros:

Ease of useEase of use

Cons:Cons: Developmental Developmental

difficultiesdifficulties

Approaches Considered Approaches Considered – Search– Search

Approach 2 – Alternate Approach 2 – Alternate windowwindow Pros:Pros:

Distinct search resultsDistinct search results Cons: Cons:

Increased user navigationIncreased user navigation

Selected – Main Selected – Main windowwindow Provides an easily Provides an easily

understood search understood search mechanismmechanism

ActivitiesActivities

Name of ActivityName of Activity CompletCompleteded

Project definitionProject definition 100%100%

Research/Phase I code reviewResearch/Phase I code review 100%100%

Project designProject design 100%100%

ImplementationImplementation 85%85%

TestingTesting 50%50%

Other (user manual, Other (user manual, documentation, etc.)documentation, etc.)

70%70%

Presentation OverviewPresentation Overview

Project OverviewProject Overview Project ActivitiesProject Activities Resources and ScheduleResources and Schedule

Estimated ResourcesEstimated Resources ScheduleSchedule PersonnelPersonnel FinancialFinancial

Closure MaterialsClosure Materials

Estimated Resources Estimated Resources (1/4)(1/4)

Project Schedule - OverviewProject Schedule - Overview

Completed activities (green): Definition, Technology Considerations and Selection, DesignCompleted activities (green): Definition, Technology Considerations and Selection, Design Current activities (blue): Product Implementation, Testing, Documentation, ReportingCurrent activities (blue): Product Implementation, Testing, Documentation, Reporting Remaining activities (red): DemonstrationRemaining activities (red): Demonstration

Estimated Resources Estimated Resources (2/4)(2/4) Project Schedule - DetailedProject Schedule - Detailed

Estimated Resources Estimated Resources (3/4)(3/4)

Personnel - HoursPersonnel - Hours

0

20

40

60

80

100

120

140

160

180

Anderson, Eric Kovar, Adam Lunde, Dustin Moeller, Matt Steger, Brian

Project Reporting

End-ProductDemonstration

End-ProductDocumentation

End-Product Testing

End-ProductImplementation

End-Product Design

Tech. Considerationsand Selections

Problem Definition

Estimated Resources Estimated Resources (4/4)(4/4)

FinancialFinancial$45.00 $1,974.00

$1,932.00

$2,124.00

$1,890.00

$2,064.00

Parts and Materials Anderson, Eric Kovar, Adam

Lunde, Dustin Moeller, Matt Steger, Brian

Expenses: Expenses: Report binding and printingReport binding and printing Poster board and laminationPoster board and lamination Labor @ $12.00/hr.Labor @ $12.00/hr.

Free Resources: Free Resources: Java developmentJava development Computer labs/personal Computer labs/personal

computerscomputers

Presentation OverviewPresentation Overview

Project OverviewProject Overview Project ActivitiesProject Activities Resources and ScheduleResources and Schedule Closure MaterialsClosure Materials

EvaluationEvaluation CommercializationCommercialization Additional WorkAdditional Work Lessoned LearnedLessoned Learned Risk ManagementRisk Management

Project EvaluationProject Evaluation

Testing program functionalityTesting program functionality Test casesTest cases Beta testingBeta testing

What lessons were learnedWhat lessons were learned Where did we succeed?Where did we succeed? Where could we have done better?Where could we have done better?

CommercializationCommercialization

Decided by Phase I and Phase II Decided by Phase I and Phase II (separately) to be offered as freeware(separately) to be offered as freeware

Hypothetical commercialization:Hypothetical commercialization: Cost of Production (including labor): $10,000Cost of Production (including labor): $10,000 Maintenance (including labor): less than Maintenance (including labor): less than

$2000 per year$2000 per year Cost of Product: $19.99Cost of Product: $19.99 Potential Market: Collectors with computer Potential Market: Collectors with computer

accessaccess

Additional WorkAdditional Work

Product redesign and additions:Product redesign and additions: Base level database structureBase level database structure Port to a personal digital assistant Port to a personal digital assistant

(PDA)(PDA) Enhanced importer and exporter for Enhanced importer and exporter for

xml and html formatsxml and html formats Enhanced printing functionalityEnhanced printing functionality

Lessons LearnedLessons Learned

Phase I’s mistakes we plan not to Phase I’s mistakes we plan not to repeatrepeat Code had little documentationCode had little documentation

We shall document the critical code to help We shall document the critical code to help future developers’ understandingfuture developers’ understanding

Code was unorganizedCode was unorganized We shall organize the code into correct We shall organize the code into correct

packages and move methods into separate packages and move methods into separate classes to allow for robustnessclasses to allow for robustness

Risk Management (1/2)Risk Management (1/2)

Risk: Loss of team member Solution: The remaining work will be

divided among the remaining members Risk: Loss of pertinent data

Solution: All data related to the project (source code,

documentation, manuals) shall be stored in a CVS repository

The repository will track all changes and different versions that the software and documents go though

Risk Management (2/2)Risk Management (2/2)

Risk: The client may not be satisfied with the end product Solution:

Multiple client/advisor feedback opportunities

Software prototypes and quality documentation made available to all stakeholders

ConclusionConclusion Project OverviewProject Overview

A collection A collection management management systemsystem

Usable by anyone Usable by anyone and everyoneand everyone

Project ActivitiesProject Activities Present Present

AccomplishmentsAccomplishments Approaches Approaches

ConsideredConsidered ActivitiesActivities

Resources and Resources and ScheduleSchedule ScheduleSchedule PersonnelPersonnel FinancialFinancial

Closure Closure MaterialsMaterials Lessons LearnedLessons Learned Risk Risk

ManagementManagement

Questions?Questions?

Application available at: Application available at: http://seniord.ece.iastate.edu/may0604http://seniord.ece.iastate.edu/may0604

//