Design And Implementation Of a Video Library Management Information System Using Visual Basic, Oracle Log And Microsoft Windows Xp

ABSTRACT

This project was aimed at designing a Video Library Management Information System; a system to aid in the management and operation of the video library. Methods that were used to gather information about the current system include; interviews, document review and questionnaires. From that information, requirements for the new system were obtained. The new system was designed and implemented using Visual Basic and Oracle 10g. The system generates reports that are vital for the video library administration

TABLE OF CONTENTS

DECLARATION 2

APPROVAL 3

DEDICATION 4

ACKNOWLEDGEMENT 5

ABSTRACT~.~—— .6

ABBREVIATIONS 7

TABLE OF CONTENTS S

Chapter One: Project Overview 10

1.0 Introduction 10

1.2 Aim ofthe project 11

1.3 Objectives 11

1.4 Project Plan 11

1.5 Project Methodology 12

1.6 Conclusion 12

Chapter Two: Literature Review 13

2,0 Introduction 13

2.1 What is an Tnformafion System7 13

2.2 Library 14

2.3 Functional Architecture 14

2.3.1 What Is Functional Architecture9 14

2.3.2 Network Architecture 15

2.3.3 Software Architecture 15

2.4.1 Technical Foundations of Information Systems 16

2.4.2 Benefits of Information Systems 17

2.4.3 Functions of Information Systems 17

2.5 System Developn’ent 18

2.5.1 System Development Life Cycle 18

2.5.2 System Development Methodologies 20

2.5.3 Data Flow in information Systems 21

2.5.4 Database in Information System 21

2.6 Conclusion 22

Chapter Three: Current System Analysis and Requirements Collection 23

3.0 Introduction 23

3.1 Current System Analysis 23

3.1.1 Data flow process in current system 23

3.1.2 Data Flow Diagram for the Movie Hiring Process 24

3.2 Requirement Collection and Analysis 24

Business Processes 25

3.2.1 Hardware and Software Requirements 26

3.2.2 User and Security Requirements 26

3.2.3 Functional and Non~functional Requirements .27

3.3 Conclusion 27

Chapter Four: Design of the New System 28

4.0 Introduction 28

4.1 Design Prototypes 28

4.1.1 Structural Design 30

4.1.2 Interface Designs 31

4.1.3 Prototype Design for the Main Interface 32

4.1.4 Data Flow Diagram (DFD) 33

4.2 Conceptual System Design 34

4.3 Logical System Design 37

4.4 Physical System Design 38

4.4.1 Member Table 39

4.4.2 Staff Table 39

4.4.3 Suppliers Table 40

4.4.4 Movie 40

4.4,5 Hire Table 41

4.5 Conclusion 41

Chapter Five: Implementation of the New System 42

5.0 Introduction 42

5.1 System Implementation 42

5.2 Database Table Implementations 42

5.3 System Login and Main Window prototype implementation................................ 45

5.3.1 System Login implementation 46

5.3.2 Main Window implementation...................................................................... 46

5.4 Conclusion 47

Chapter Six: Evaluation of the New System 48

6.0 Introduction 48

6.1 Functionality 48

6.2 Usability 49

6.3 Standards 50

6.3.1 Principles of User Interface Design 50

6.4 Effect on the organization 51

6.5 Effect on the customers 51

6.6 Conclusion 51

References 52

APPENDIX Sample Questionnaire 54

APPENDIX I I Evaluation Questionnaire~.~ 57

APPENDIX III Budget 59

APPENDIX IV Introductory Letter 60