Software Implementation of a Computerized System for Managing Databases on Computers

PRELIMINARY PAGES

• Title page
• Approval page
• Dedication
• Acknowledgement
• Table of Contents
• Abstract

CHAPTER ONE

INTRODUCTION

• 1.1 Background …
• …

CHAPTER TWO

LITERATURE REVIEW

• 2.1 Introduction
• …

CHAPTER THREE

SYSTEM ANALYSIS AND DESIGN

• 3.1 Methodology Adopted
• 3.1.1 Problem Identification Using SSADM
• 3.2 Analysis of the Existing System
• 3.2.1 Dataflow of the Existing System
• 3.2.2 Disadvantages Of The Existing System
• 3.2.3 Weakness of the existing System
• 3.3 Feasibility Study
• 3.3.1 Economic Feasibility
• 3.3.2 Technical Feasibility
• 3.3.3 Operational Feasibility
• 3.4 Analysis of the Proposed System
• 3.4.1 Data Flow Diagram of the Proposed System
• 3.4.2 Advantages of the Proposed System
• 3.4.3 Justification of the Proposed System
• 3.5 Functional Requirements
• 3.5.1 Use Case Diagram Of The Admin / User Privileges
• 3.6 Data Requirements
• 3.7 High Level Model of the Proposed System

CHAPTER FOUR

SYSTEM DESIGN AND IMPLEMENTATION

• 4.1 Objectives of the Design
• 4.2 Cohesion and Decomposition High level Model
• 4.3 Control Center / Overall Dataflow Diagram
• 4.3.1 Proposed System Operation Flowchart
• 4.4 System Specification and Design
• 4.4.1 Input and Output Specification
• 4.4.2 Database Specification and Design
• 4.4.3 Data Dictionary
• 4.5 Choice and Justification of Programming Language
• 4.6 Program Documentation
• 4.7 Implementation Techniques
• 4.8 Programming Module Specification
• 4.8.1 Installation
• 4.9 Computer Hardware Minimum Requirement
• 4.10 Software Requirement
• 4.11 Personnel / User Training
• 4.12 File Maintenance Module

CHAPTER FIVE

SUMMARY, CONCLUSION AND RECOMMENDATION

• 5.1 Introduction
• 5.2 Summary
• 5.3 Conclusion
• 5.4 Recommendation

References

Appendix A - Source Code

Appendix B - Object Program

1.0 Introduction

In many offices, records are traditionally kept on paper and in file jackets. However, as the amount of records increases, the volume of paper work involved also increases. This will in turn result in problem of storage spaces. It becomes generally more difficult to manage such a system. Also retrieval of information becomes cumbersome.

On account of these shortcomings computerized information storage and management is fast replacing the traditional and methods which NIGERCEM will not be left out.

Personnel department in NIGERCEM, they compile and keep records of its workers and customers. The issue of host worker is a problem often faced by NIGERCEM. This problem can be reduced by the use of a well-designed and implemented data base management system.

1.1 Statement Of The Problem

This project deals with the development of a computerized data base management system with NIGERCEM as a case study. A lot of companies in Nigeria especially those that encounter direct correspondence with numerous customers are computerizing their operations and NIGERCEM being a firm that fits into the above description will not be left out cement companies like Dangote, Portland cement and Eagle Cement Port-Harcourt have recorded a lot of improvement and considerable levels of efficiency in dealing with customers and other operations due to effective computerization.

Record processing in NIGERCEM Nkalagu is done manually while the records are kept in files. The personnel department handles the workers’ file while the finance division handles the customers’ files.

Workers’ files and customers’ file are so large that to say that offices are not spacious enough to contain them would be an understatement. Most of the time when references is to be made on these files, it will be found that some of them are already damaged due to physical constraints as excess heat or moisture. Others are left at the mercy of vermin’s like mice, cockroaches and termites. A lot of relevant information is lost in this way.

1.2 Purpose Of The Study

The purpose of this project is to develop and implement a safer way of keeping these information and to keep a breast of the latest technology in vogue and to enhance performance. Also, to carryout a research on transforming the personnel department of NIGERCEM Plc manual record keeping into a computerized system. The implementation of this system would neither bring about workers’ redundancy nor deny them benefit but will enhance efficiency and proper storage system.

1.3 Significance Of The Study

The design and implementation of a Data Base Management System (DBMS) for NIGERCEM Plc will do the following among others:-

1. Save time in information retrieval
2. Prevent data from corruption and destruction
3. Help save useful space that will be otherwise used to store volumes of files containing records.

1.4 Scope Of The Study

The areas covered by the project are the data bank handle by personnel department and a part of the customer records handled by the finance division. Other areas like fiscal transactions, stock taking and quality control are not included in the scope of this project.

Account Details - For USSD / POS Transfer

Account Name: Sparklyn Services Account No: 1222599051 Account Type: Current Bank Name: Zenith Bank PLC

Proposal Writing Format under Computer Science

Design and Implementation of a Computerized System for Managing Databases on Computers is a proposal topic for final year research work, which comprises the major and elective project proposal writing sections for Design and Implementation of a Computerized System for Managing Databases on Computers research work.

Major Sections

• Motivation for Embarking on the Project

• Brief Background of Study

• Statement of Problems

• Aim of the Study

• Specific Objectives of the Study

• Significance of the Study (Who benefits from the project and how?)

Elective Sections

• Methodology and Reason for Using It (such as; models, SSADM, or OOADM)

• Tools (programming languages and software used)