TOPIC THE STAFFS OF INTERNATIONAL JOINTS TRANING PROGRAM - HANOI UNIVERSITY OF TECHNOLOGY AND GENETIC COMPUTER SCHOOL ACKNOWLEDGEMENT When all the last parts of the project were finished and all the corrections were made, our group is so happy and proud for all we have done in the project developing process. At the beginning, it was realized that working in a group with a cooperative spirit is not easy at all. With the results that we get today, all team’s members have tried our best. However, having the today’s results, we would like to send our thanks to our lectures, friends, and family members who have helped, encouraged and supported us enthusiastically to complete the project, which is the proof of our knowledge after five year studying at Hanoi University of Technology-Genetic Singapore Joint Program. We would like to give special thank to MSC. Luong Vu Nam, who was very dedicated. He has spent a lot of time on reviewing and editing our system analysis and design as well as system developing process. Special thank to MA .Kazi Shahidul Islam for his assistances and consultancy to our documents, language and presentation. We also will never forget the kind support of Dr. Nguyen Minh Viet, Vice.Prof Dr.Nguyen Viet Huong and other teachers as well as the staffs of International Joints Training program – Hanoi University of Technology and Genetic Computer School. CHAPTER 1 – SYSTEM SPECIFICATION 5 1.1 SCENARIO AND QUESTION PAPER 5 1.1.1 Scenario 5 1.1.2 Question Paper 6 1.2 BACKGROUND 7 1.3 INFRASTRUCTURE 8 1.4 USECASE DIAGRAM 9 1.6 SEQUENCE DIAGRAM 11 1.6.1 Sequence Diagram for Accessing To System 11 1.6.2 Sequence Diagram for Daily Transaction 12 1.6.3 Sequence Diagram for Creating Stock Information 13 1.6.4 Sequence Diagram For Search Profit Plan 14 1.6.5 Sequece Diagram for Import Excel to System 15 1.6.6 Sequece Diagram for Report Management 16 1.7 STATE DIAGRAM 17 1.7.1 State Diagram for Account Management 17 1.7.2 State Diagram for Granting Role 18 1.7.3 State Diagram for Dialy Transaction Management 19 1.7.4 State Diagram for Balance Sheet Management 20 1.7.5 State Diagram for Report Management 21 1.8 METHOD OF INVESTIGATION 22 1.9 SCHEDULE OF PROJECT 23 1.10 DATABASE DESIGN 24 1.10.1 Normalization 24 1.10.2 Entity Relationship Diagram 53 CHAPTER 2 – PROGRAM SPECIFICATION 54 2.1 PROGRAM IDENTIFICATION 54 2.2 PROGRAM DESCRIPTION 54 2.3 PROGRAM OUTLINE 55 2.4 PROGRAM SCHEDULE 57 2.5 PROGRAM ESTIMATION 58 CHAPTER 3 – INPUT SPECIFICATION 59 3.1 FILE SPECIFICATION 59 3.2 RECORD SPECIFICATION 65 CHAPTER 4 – OUTPUT SPECIFICATION 77 4.1 FILE SPECIFICATION 77 4.2 RECORD SPECIFICATION 80 CHAPTER 5 – PROGRAM DESIGN 90 5.1 DECISION TABLE 90 5.2 FLOW CHART 94 5.2.1 Access To System 94 5.2.2 Granting Role 95 5.2.3 Account Management 96 5.2.4 Term Management 97 5.2.5 Balance Sheet Management 98 5.2.6 Extraordinary Information Management 99 5.2.7 Daily Transaction Management 100 5.2.8 Financial Report Explanation Management 101 CHAPTER 6 – PROGRAM LISTINGS 103 6.1 PROGRAM LISTING 103 6.2 REPORT LISTING 104 CHAPTER 7 – PROGRAM TESTING 105 7.1 TEST PLAN 105 7.2 TEST DATA 106 7.2.1 Test Data For Cancellation Table 106 7.2.2 Test Data For Management Board Table 107 7.2.3 Test Data For Shareholders Table 107 7.3 TEST LOG SHEET 108 7.4 PROGRAM TRACE 109 7.5 GRID CHART 112 CHAPTER 8 – OPERATING INSTRUCTIONS 113 8.1 OPERATING INSTRUCTIONS 113 8.1.1 Installation for SQL Server 2000 113 8.1.2 Install SLIMS on Server Machine 115 8.1.3 How to run total program 117 8.2 HARDWARE REQUIREMENT 117 8.3 SOFTWARE REQUIREMENT 117 CHAPTER 9 – LIMITATIONS 119 9.1 SCOPE 119 9.2 LIMITATIONS 119