Proposed Design of an Inventory Database System at Process Research ORTECH System Design Prepared by Andrew Ramadeen Manojav Sridhar Kunendran Deivendran Junaid Yousuf Monday, April 16, 20012 Introduction......................................................................................... 5 Identifying the Problem....................................................................... 5 Requirements ..................................................................................... 6 Functional Requirements ..................................................................................6 Nonfunctional Requirements .............................................................................7 Design Phase ..................................................................................... 8 1. Global System Architecture........................................................................8 Hardware................................................................................................................................. 8 Networking .............................................................................................................................. 9 Software Platform ................................................................................................................... 9 Hardware............................................................................................................................... 10 Network – LAN...................................................................................................................... 10 Software – MS Windows and MS Applications..................................................................... 10 2. Diagrammatic Modeling............................................................................11 State Diagrams ..................................................................................................................... 12 Activity Diagrams .................................................................................................................. 13 E-R Diagram ......................................................................................................................... 14 3. Software Architecture...............................................................................16 Three-Tier Design ................................................................................................................. 16 Repository-Based Design ..................................................................................................... 16 4. Database Design......................................................................................17 5. User Interface Design ..............................................................................20 Conclusions...................................................................................... 22 Appendix 1 ....................................................................................... 24 Brainstorming Session 1 – March 27th 2001....................................................24 Appendix 2 ....................................................................................... 25 Explanation of Appendices – March 27th 2001 ................................................25 Appendix 3 ....................................................................................... 26 Organizational Chart – March 27th 2001..........................................................26 Appendix 4 ....................................................................................... 27 PRO Inventory System Flow Chart – March 27th 2001....................................27 Appendix 5 ....................................................................................... 29 Functional Requirements – March 27th 2001...................................................29 I. Details of data storage ................................................................................................. 31 II. Details of output ........................................................................................................... 31 III. Details of input.............................................................................................................. 32 IV. Details of Information Processing ............................................................................ 32 Appendix 6 ....................................................................................... 33 Non-functional Requirements – March 27th 2001 ............................................33 1. Software Requirements................................................................................................ 34 2. Hardware Requirements .............................................................................................. 34 3. Security Requirements................................................................................................. 34 4. Reliability/Survivability Requirements .......................................................................... 34 5. Interface Requirements................................................................................................ 35 6. Lifecycle Requirements................................................................................................ 35 7. Economic Requirements .............................................................................................. 35 Appendix 7 ....................................................................................... 363Brainstorming Session 2 – March 29th 2001....................................................36 Appendix 8 ....................................................................................... 37 Information Gathering Summary – March 30th 2001........................................37 Appendix 9 ....................................................................................... 38 Current Computing Capabilities – March 30th 2001.........................................38 1. Server Computer - (Glass box) .................................................................................... 38 2. Client Computer(s) - (Glass box) ................................................................................. 38 3. Networking Components.............................................................................................. 39 4.
View Full Document