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