A D S System Design on behalf of Eurosun Inc CSC340 UTM Professor Arnold Rosenbloom TA C Jull April 16 2001 Nelson Arruda Eric De Paolis Michael Scrivo Table of Contents 1 Introduction 7 2 The Current System 7 2 1 Description 7 2 2 Problems 7 2 3 Problem Scope and Solution 7 3 Software Architecture 8 3 1 Alternatives 8 3 1 1 Repository Based Architecture 8 3 1 2 Client Server Architecture 8 3 1 2 1 Two Tier Client Server Architecture 8 3 1 2 2 Three Tier Client Server Architecture 9 3 2 1 Comparison between 2 Tier and 3 Tier Architectures 9 3 2 1 1 Criteria 9 3 2 1 2 Results 9 3 2 Recommendation 10 4 Global Architecture Design 11 4 1 Global Architecture Overview 12 4 2 Distribution Issues 12 4 3 Process Cycles 12 4 4 Data Distribution 12 4 5 Process Distribution 12 5 Selections 13 5 1 Hardware Classes 13 5 2 Hardware Selection 13 5 2 1 Database Server Selection Criteria 13 5 2 2 Database Server Recommendation 13 5 2 3 Client Workstation Node Recommendation 14 5 3 Software 14 5 3 1 Database Server Operating System 14 5 3 2 Client Workstation Systems 14 5 3 3 Database 14 5 3 3 1 Overview 14 2 5 3 3 1 1 IBM DB2 15 5 3 3 1 2 Oracle 15 5 3 3 1 3 Microsoft SQL Server 15 5 3 3 1 4 Microsoft Access 15 5 3 3 2 Recommendation 16 5 3 4 Programming Language 16 5 3 4 1 Overview 16 5 3 4 1 1 Microsoft Visual Basic 16 5 3 4 1 2 Microsoft Visual J 16 5 3 4 1 3 Microsoft Visual C 16 5 3 4 1 4 Microsoft Visual Basic Visual C 16 5 3 4 2 Recommendation 17 5 4 Network 17 5 4 1 Type 17 5 4 2 Network Interface Cards 17 5 4 3 Connectivity 17 5 4 3 1 Overview 17 5 4 3 1 1 Workgroup Hub 17 5 4 3 1 2 Workgroup Switch 17 5 4 3 1 3 Router 18 5 4 3 2 Recommendation 18 5 4 4 Network Wiring 18 6 Input Output Procedures 18 6 1 System Modules 18 6 1 1 Administration Module 18 6 1 1 1 Add Employee 19 6 1 1 2 Add Supplier 19 6 1 1 3 Add Flight 19 6 1 2 Financial Reports Module 19 6 1 2 1 Pay Supplier 19 6 1 2 2 View Financial Reports 19 6 1 3 Booking Module 20 6 1 3 1 Create New Booking 20 6 1 3 2 Cancel Booking 20 6 1 3 3 Add Flight to Booking 20 6 1 3 4 Add Hotel Reservation to Booking 20 6 1 3 5 Add Car Rental to Booking 20 3 6 1 3 6 Add Customer Account 20 6 1 3 7 Look Up Customer Account 21 6 2 Security 21 7 Database Design 21 7 1 E R Diagram 21 7 1 1 E R Diagram Optimization Overview 21 7 1 2 Database Schema 22 7 1 2 1 Entities 22 7 1 2 2 Relationships 23 8 Interface Design 24 8 1 Designing the Interface 24 9 Conclusion 25 Appendix A1 Repository Based Software Architecture 27 Appendix A2 Two Tier Client Server Architecture 28 Appendix A3 Three Tier Client Server Architecture 29 Appendix B1 Server Comparison 30 Appendix B2 Client System Configuration 31 Appendix C Database Comparison 32 Appendix D1 ACID Compliant Database 33 Appendix D2 Relational Schema using Normal Forms 34 Appendix E1 Database Cost Model 35 Accesses 35 Appendix E2 Cases of Redundancy 38 Cost Comparison 40 Results 40 Appendix F1 Initial E R Diagram 41 Appendix F2 Optimized E R Diagram Tables in Database 42 Appendix F3 E R Data Dictionary 43 Appendix G1 Revised Use Case Diagram 45 Appendix G2 Use Case Diagram Data Dictionary 46 Appendix H1 Revised Class Diagram 47 4 Appendix H2 Class Diagram Data Dictionary 48 Appendix I1 State Diagram Add Hotel Reservation To Booking 50 Appendix I2 State Diagram Add Flight to Database 51 Appendix J Sequence Diagram Generate Supplier Report 52 Appendix K Collaboration Diagram Creating a New Booking 53 Appendix L Characteristics of a Good Interface 54 Appendix M1 User Interface Main Program 55 Appendix M2 User Interface Flights Window 56 Appendix M3 User Interface Querying Database Sorting Filtering 57 Appendix M4 Administration Tools 58 Appendix N Requirements Analysis 59 1 Functional Requirements 59 1 1 Input 59 1 1 1 New Supplier Information 59 1 1 2 New Customers 59 1 1 3 Create Bookings 59 1 1 4 Financial Management 59 1 2 Data Management 59 1 2 1 Bookings 60 1 2 2 Cost of Goods Sold and Inventory 60 1 2 3 Monitor Sales for Time Periods 60 1 2 4 Customer and Travel Agencies 60 1 2 5 Transactions 60 1 3 Output 60 1 3 1 Reports 60 1 3 2 Cheques 60 2 Non Functional Requirements 60 2 1 Interface 61 2 2 Performance 61 2 2 1 Reliability 61 2 2 2 Usability 61 2 2 3 Resources 61 2 2 4 Efficiency 61 2 2 5 Security 61 5 2 3 Operating 62 2 3 1 Maintenance 62 2 3 2 Backup 62 2 3 3 Restart Requirements 62 2 3 4 Environmental Conditions 62 2 4 Life Cycle 62 2 4 1 Quality of Design 62 2 4 2 Limits on Development 62 2 5 Economic 62 2 6 Server Platform 63 2 6 1 Operating System 63 2 6 2 Memory 63 2 6 3 Storage 63 2 6 4 CPU 63 2 6 5 Peripherals 63 2 6 6 Network 63 2 7 Client Systems 64 2 7 1 Operating System 64 2 7 2 Memory 64 2 7 3 Storage 64 2 7 4 CPU 64 2 7 5 Network 64 6 1 Introduction In designing a good Information System it is necessary to review the requirements outlined during the requirements analysis phase It is a well known fact that many errors in designing an Information System occur in determining the requirements It is also a well known fact that fixing errors in the requirements and design stage are much more cost effective than fixing them during the implementation phase Thus the main goal of this study is to consider architectural alternatives along with hardware and software as proposed by the requirements analysis In the process of doing this the requirements will be refined and built upon as needed and a viable carefully planned out system design will emerge 2 The Current System 2 1 Description The current system in place is based on a two tier client server model There are twelve systems in total which include two main servers one application server and one Internet Domain server As mentioned above the heart of the system which is integral to business operations is the proprietary Holiday Booking Program This program was created using GW Basic in 1987 and took two years to develop Note that …
View Full Document
Unlocking...