1 of 70HEADHUNTING THE FUTURE…Augmenting Information Technology Support Systems at MandrakeManagement Consultants Inc.Assignment 3: Detailed Design of an Information SystemCMR Consulting [team 30]Charissa Lai, Martin Ross, Ruslana GoncharenkoCourse: CSC340sDate: April 16, 2001TA: Bowen HuiPresented to: Professor John Mylopoulos2 of 70TABLE OF CONTENTS1. INTRODUCTION .......................................................................................................................51.1. CURRENT SYSTEM .................................................................................................................51.2. RECOMMENDED SOLUTION: WEB-BASED IT SUPPORT FORM...........................................................51.3. REQUIREMENTS ANALYSIS ......................................................................................................51.3.1. Functional Requirements....................................................................................................51.3.2. Non-functional Requirements...............................................................................................52. GLOBAL ARCHITECTURE........................................................................................................72.1. SOFTWARE ARCHITECTURE......................................................................................................72.1.1. Client-Server Architecture ..................................................................................................72.1.2. Three-Tier Web Architecture ...............................................................................................72.2. COMPUTER NETWORK ............................................................................................................82.3. HARDWARE ..........................................................................................................................82.4. SOFTWARE ...........................................................................................................................92.4.1. Operating System..............................................................................................................92.4.2. Web Server ......................................................................................................................92.4.3. Database.......................................................................................................................102.4.4. Conclusion.....................................................................................................................102.5. SOFTWARE COMPONENTS......................................................................................................102.5.1. Business Objects .............................................................................................................112.5.2. Database Package...........................................................................................................132.5.3. User Interface Package ....................................................................................................143. DATABASE DIAGRAMS ..........................................................................................................153.1. DATABASE CONCEPTUAL CLASS DIAGRAM ...............................................................................153.2. TYPICAL OPERATIONS:..........................................................................................................173.3. WORKLOAD DATA ...............................................................................................................173.3.1. Table of volumes.............................................................................................................173.3.2. Table of operations..........................................................................................................173.4. REDUNDANCIES:..................................................................................................................173.5. TABLES OF ACCESSES...........................................................................................................18Operation 1................................................................................................................................18Operation 2................................................................................................................................18Operation 3................................................................................................................................18Operation 4................................................................................................................................18Operation 5................................................................................................................................19Operation 6................................................................................................................................19Operation 7................................................................................................................................19Operation 8................................................................................................................................19Operation 9................................................................................................................................19Operation 10..............................................................................................................................203.6. COST COMPARISON ..............................................................................................................203.7. DECIDING ABOUT REDUNDANCIES ..........................................................................................203 of 703.8. REMOVING GENERALIZATIONS ...............................................................................................213.9. PARTITIONING AND MERGING OF CONCEPTS..............................................................................213.10. SELECTING PRIMARY IDENTIFIERS...........................................................................................213.11. TRANSFORMATION INTO RELATIONAL MODEL ...........................................................................213.12. NORMALIZATION .................................................................................................................213.13. CLASS DIAGRAM
View Full Document