cDNA Systems Analysis

1
cDNA Systems Analysis

• Seth Klement
• Matthew Macormic
• Gabe Brueggemann
• Dan Lester
• Clay Turner
• Jason Durbin

2
Overview

• Current System
• Background
• Problems and Constraints
• Features of New System
• Alternative Solutions
• Recommendations and Conclusions

3
Background Information

• Non-profit Organization
• Full length cDNA clones in coding human coding
  transduction proteins
• Provide services that complement other related
  businesses to avoid being a threat
• 2 reasons for competitiveness
• Price
• Quality

4
System Background

• Orders can be completed online (cDNA.org), fax,
  or telephone
• Transaction Process
• Customer orders clone(s)
• cDNA enters information into Database
• cDNA re-enters data into Fed-Ex.com
• cDNA enters tracking number into Database
• Shipment as expected

5
Problems and Constraints

• Problems
• Human Error in data entry
• Finance issues
• Redundant data entry
• Constraints
• Target market
• UMR Policies

6
New System

• Few physical changes
• Automating aspects of a working system
• Integration of database applications

7
Business Rules (New System)

• Must be one and only one customer per order
• Customer does not need to make an Order, but
  could make multiple Orders
• An Order does not need to be shipped (can be
  picked up).
• An order can only be shipped once
• An Order needs to exist to create a shipment.
• Multiple Orders can be put on one shipment
• An Order must have at least one item ordered, but
  an Order may contain many items
• An Item does not need to be ordered, but an item
  can be ordered multiple times

8
Context DFD
9
Level-0 Diagram
10
(No Transcript)
11
Questions ?
12
Decomposition DFD processes
13
Alternatives and Recommendations

• High end vs. Low end alternatives
• High expensive software architecture for the
  company
• Low Recommended System Structure
• Database structure with Microsoft Access or
  Oracle
• Appropriate for small companys daily business

14
Lessons Learned

• Business expenses are large when there are system
  inefficiencies
• Having one centralized system as opposed to
  manual data entry into multiple databases
• Integrative technologies provide the framework
  for cDNA