TABLE OF CONTENTS 1

CHAPTER 1 - SYSTEM SPECIFICATION 4

1.1. SCENARIO AND QUESTION PAPER 4

1.1.1. SCENARIO 4

1.1.2. QUESTION PAPER 6

1.2. BACKGROUND 8

1.3. INFRASTRUCTURE 9

1.4. FUNTION HIERARCHY DIAGRAM 10

1.5. CONTEXT DIAGRAM 11

1.6. DATA FLOW DIAGRAM 12

1.6.1. DFD Level 0 for Pharmaceutical Management System in Hospital 12

1.6.2. DFD Level 1 for System Management 12

1.6.3. DFD Level 2 for User Management of System Management 13

1.6.4. DFD Level 1 for List Management 15

1.6.5. DFD level 2 of List Management 16

1.6.6. DFD Level 1 for Medicine Expectation and Bidding Management 17

1.6.7. DFD Level 2 for Yearly Expectation Management 18

1.6.8. DFD Level 2 for Bidding Management 19

1.6.9. DFD Level 3 for Bidding Document of Bidding Management 20

1.6.10. DFD Level 3 for Price Quotation Input of Bidding Management 21

1.6.11. DFD Level 3 for Bidding Open of Bidding Management 22

1.6.12. DFD Level 3 for Bidding Result Announcement of Bidding Management 23

1.6.13. DFD Level 1 for Medicine Management 24

1.6.14. DFD Level 2 for Medicine in Stock Keeping Track and Management 25

1.6.15. DFD Level 3 for Medicine Inventory in Stock Keeping Track and Management 26

1.6.16. DFD Level 2 for Medicine Intake Management of Medicine Management 26

1.6.17. DFD Level 2 for Medicine Distributed and Medicine Management 28

1.6.18. DFD Level 2 for Monthly Medicine Expectation and Request Management 29

1.6.19. DFD Level 1 for Report System 30

1.7. METHOD OF INVESTIGATION 31

1.8. SCHEDULE OF PROJECT 32

1.9. DATABASE DESIGN 33

1.9.1. 3 NF TABLE 33

1.9.2. ENTITIES RELATIONSHIP DIAGRAM 43

CHAPTER 2: PROGRAM SPECIFICATION 44

2.1. PROGRAM IDENTIFICATION 44

2.2. PROGRAM DESCRIPTION 45

2.3. PROGRAM OUTLINE 46

2.4. PROGRAM SCHEDULE 48

2.5. PROGRAM ESTIMATION 48

CHAPTER 3: INPUT SPECIFICATION 49

3.1. FILE SPECIFICATION 49

3.2. RECORD SPECIFICATION 49

CHAPTER 4: OUTPUT SPECIFICATION 63

4.1. FILE SPECIFICATION 63

4.2. RECORD SPECIFICATION 63

4.3. PRINT LAYOUT CHART 67

CHAPTER 5: PROGRAM DESIGN 69

5.1. DECISION TABLE 69

5.1.1. Decision table of Add new procedure 69

5.1.2. Decision table of Update procedure 69

5.1.3. Decision table of Search procedure 69

5.1.4. Decision table of Delete procedure 69

5.1.5. Decision table of Print procedure 70

5.1.6. Decision table of Keeping Track of Medicine in Stock 70

5.1.7. Decision table of Keeping Track of Expired date Medicine 70

5.1.8. Decision table of Bidding Process 70

5.2. FLOWCHART 72

5.2.1. Flowchart for Access Right 72

5.2.2. Flowchart for Add Function 73

5.2.3. Flowchart for Update Function 74

5.2.4. Flowchart for Search Function 74

5.2.5. Flowchart for Delete Function 75

5.2.6. Flowchart for Report 76

5.2.7. Flowchart for Keeping Track of Medicine in Stock 78

5.2.8. Flowchart for Keeping Track of Expired date Medicine 79

5.2.9. Flowchart for Bidding Process 80

CHAPTER 6: PROGRAM LISTING 81

6.1. PROGRAM LISTING 82

6.2. REPORT LISTING 92

CHAPTER 7: PROGRAM TESTING 95

7.1. TEST PLAN 95

7.2. TEST DATA 95

7.3. TEST LOG SHEET 97

7.4. PROGRAM TRACE 98

7.5. GRID CHART 98

CHAPTER 8: OPERATING INSTRUCTION 99

8.1. OPERATING INSTRUCTIONS 99

8.2. HARDWARE REQUIREMENT 100

8.3. SOFTWARE REQUIREMENT 100

CHAPTER 9: SCOPE AND LIMITATIONS 101

9.1. SCOPE 101

9.2. LIMITATION 101