National Business Information Management System

论文摘要

For the past centuries the role of information in the social and economic development was so slow and gradual till the mid 1960’s where scientific discoveries in the fields of electronics and mathematics led to the introduction of the first computer. Since then, the rapid evolution of computer started to bring a dramatic gap in development between countries. Evidentially, the world is classified in to two major groups, the developed and the developing countries. From the experiences of the developed and advance developing countries like china, it is possible to see and understand their progress in the proper application and usage of information technology in both governmental and nongovernmental sectors. Whether they are small or big, most of the sectors fully incorporate the use of modern day automated information system in their day to day activities. As the result, where ever you go in such countries there is an easy, fast and secure information access and dissemination, which pays a considerable account in supporting the officials and executives in planning and decision making process.To realize and develop such a system, this thesis discusses the proper investigation and determination of the information system requirements through a detailed analysis of the problem domain of the business under study. Based on the resolved business requirements, the thesis formulates a working system design which includes the database, system architecture, security, as well as GUI （graphical user interface）, in order to establish an efficient, cost effective, and last longing information system, in which this case is the NBIMS.The thesis reveals different frameworks for understanding and doing requirement determination and specifications. The well defined business requirement encompasses functional, user interface, system, and security requirement specifications. These specifications serve as a ground base for business modeling using the database design and modeling using the E-R diagram and Relational model, as well as choosing the appropriate on-the-shelf software products for the information system development and implementation, such software are the Microsoft SQL 2000 Server for the backend database development, and Delphi for the front-end user interface application development. Further more, the determined system and security specifications point toward the implementation of the more advanced and advantageous system architecture well known as the Multi-tier client/server system architecture, and a three level general security mechanism - operating system level, user interface level, and database level, at this particular stage of the research.Therefore the theme of this thesis is to get the advantages in the modern day information technology and indicate how to use it in the national business information activities in general, and database management system for one of the national regional state of Ethiopia in particular - Harari National Regional State, through proper and detailed systems analysis to database design and application with the appropriate user interface and system architecture （multi-tier）.

论文目录

• Acknowledgment
• Dedication
• Abstract
• Chapters 1 General
• 1.1 Ethiopia
• 1.2 Harari Regional State
• 1.3 Current National Information Technology
• 1.4 Information System
• 1.5 The over all dissertation Report Structure
• Chapters 2 National Business Information management System Analysis and System Requirements Specification and Determination
• 2.1 System Analysis
• 2.1.1 Objectives
• 2.1.2 System Model
• 2.2 System Requirements Specification and Determination
• 2.2.1 Functional Requirements
• 2.2.2 User Interface Requirements
• 2.2.3 System Requirements
• 2.2.3.1 Overview of System Architecture
• 2.3.4 Security Requirements
• Chapters 3 National Business Information Management System Database design
• 3.1 Introduction
• 3.2 Conceptual Database Design
• 3.3 Logical Database Design
• 3.4 Physical Database Design
• Chapters 4 Data Mining Model and Algorithm in NBIMS
• 4.1 An overview of Data mining In SQL Server 2000
• 4.1.1 Introduction
• 4.1.2 Origins of Data mining
• 4.1.3 Data Mining Development Approach
• 4.1.4 Relational Data Mining Model
• 4.1.4.1 Data Mining Methodology
• 4.1.5 OLE DB for Data Mining
• 4.1.6 Data mining Algorithms
• 4.1.6.1 Data mining Algorithm Providers
• 4.1.6.1.1 Decision tree
• 4.1.6.1.2 Clustering
• 4.2 Overview of Multidimensional Schemas and Data
• 4.2.1 Understanding Multidimensional Schemas
• 4.2.2 Parent-child Dimension
• 4.3 Relational Database design algorithm used in NBIS
• 4.3.1 Relational Database Model
• 4.3.2 Boyce Codd Normal Form （BCNF）
• 4.3.2.1 Boyce Codd Normalization Algorithm
• Chapters 5 NBIMS System Architecture and implementation
• 5.1 Introduction
• 5.2 Single Tier application
• 5.3 Two-tier Client/Server Application
• 5.3.1 Limitations of Two tier Client/Server Application
• 5.4 Multi Tier Applications
• 5.4.1 Benefits of Multi tier Applications
• 5.4.2 Middle Tier Design
• 5.4.2.1 Development and Implementing Tools
• 5.4.2.2 Creating Com Objects
• 5.4.2.2 Middle tier business objects
• 5.4.3 Data Flow Process
• 5.4.4 Presentation Tier
• 5.4.4.1 Developing NBIMS user interface
• 5.5 Implementation
• 5.5.1 Introduction
• 5.5.2 Data service tier implementation
• 5.5.3 Middle tier implementation
• 5.5.4 Presentation tier implementation
• Chapters 6 NBIMS Security
• 6.1 Database Security
• 6.2 Middle Level Security Measure
• 6.3 Front-end Level Security Measure
• Chapters 7 Conclusions and Limitations
• 7.1 Limitations
• 7.2 Conclusions
• Appendices
• Referenees