Modeling And Implementing Business Processes And Information System For A Video Library Using Visual Basic And Oracle

TABLE OF CONTENTS

Terms and abbreviations i

Table of figures II

List of tables III

Dedication

Acknowledge V

CHAPTER ONE

1.0 Introduction 1

1.1 Background of the study 1

1.2 Statement of the problem 3

1.3 Objectives of the study 3

1.3.1 Main Objective 3

1.3.2 Specific Objectives 4

1.4 Research Questions 4

1.5 Scope of the study 4

1.6 Significance of the study 4

1.7 Justification of the study 5

1.8 Conceptual Framework 5

1.9 Conclusion 5

CHAPTER TWO

2.0 Introduction 6

2.1 Recent Development 6

2.2 Problem Area 6

2.3 Application Area 6

2.4 Database Environment 7

2.4.1 Hardware 7

2.4.2 Software 8

2.4.3 Data! Information 8

2.4.4 Procedures .8

2.4.5 People 8

2.5 Advantages of a database system 8

2.6 Disadvantages of a database system 10

2.7 Data storage hardware and retrieval 10

2.8 Information Systems 10

2.8.1 Types of Information systems 10

2.9 Conclusion ii

CHAPTER THREE

3.0 Introduction 12

3.1 Study Design 12

3.2 Organization Unit(s) to be Studied 12

3.3 Study Population 12

3.4 Sample Size 12

3.5 Development Methodology (SDLC) 12

3.6 Data collection 14

3.6.1 Primary methods 15

3.6.2 Secondary methods 16

3.7 Data collection and discussion of findings 16

3.7.1 Category of respondents 16

3.7.2 Respondent by gender 17

3.7.3 Adequacy of the current system 17

3.7.4 Security of the current system 18

3.8 System analysis 18

3.8.1 Strength of the current system 19

3.8.2 Weaknesses of the current system 19

3.9 Information System plan 20

3.9.1. System Request 20

3.9.2 Feasibility analysis 20

3.10 System specification 21

3.10.1 System requirements .21

3.10.2 User requirements of the new system 21

3.10.3 Security requirements of the new system 22

3.11 Conclusion 23

CHAPTER FOUR

4.0 Introduction 24

4.1 Context level diagram 24

4.2 Entity relationship diagram 27

4.3 System flow chart 30

4.4 Data flow diagram 32

4.5 Conceptual database design 34

4.6 Logical design 34

4.7 Physical design 37

4.8 Conclusion 41

CHAPTER FIVE

5.0 Introduction 42

5.1 Program testing 42

5.2 Project implementation 43

5.3 User interface 44

5.4 System Conversation

5.5 Conclusion 45

CHAPTER SIX

6.0 Discussions 46

6.1 Challenges 46

6.2 Limitation of the study 46

6.3 Evaluation of the new system 47

6.4 Recommendations 47

6.5 Conclusion 48