× Close

📚 Departmental Topics and Materials for (2024) Google Researchers
Accounting Topics
Architecture Topics
Building Technology Topics
Computer Science Topics
Curriculum Studies Topics
📚 Project or Seminar Related (2024) Scholaristic Topics for Students

Search for Project and Seminar Topics Post Advertisement Items for Promotion
Anonymous
Design and Implementation of a WebBased Alumni Database Management System

Design and Implementation of a Web-Based Alumni Database Management System

Project / Seminar Material
Reference ID: PS-5624-TM

DEDICATION

This research work titled "Design and Implementation of a Web-Based Alumni Database Management System" is dedicated to God for his enabling grace and to all computer enthusiasts who help to make life a pleasant experience.

ACKNOWLEDGEMENT

I owe my indebtedness to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing/related research material for your moral support that facilitated the successful completion of my (Tertiary Institution level). I am grateful to God Almighty and my parent for their financial support in my career. I really appreciate you all for everything, Thank you very much.


Design and Implementation of a Web-Based Alumni Database Management System

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION

  • 1.1 Introduction
  • 1.2 Background of Study
  • 1.3 Statement of Problem
  • 1.4 Aim and Objectives of the Study
  • 1.5 Significance of Study
  • 1.6 Scope of Study
  • 1.7 Limitations of the Study
  • 1.8 Definition of Terms

CHAPTER TWO

LITERATURE REVIEW

  • 2.1 Introduction
  • 2.2 Overview of Information System
  • 2.3 Alumni Database Management System (DBMS)
  • 2.3.1 History of Database Management Systems
  • 2.4 Database Management System (DBMS)
  • 2.4.1 Database and Database Systems
  • 2.5 Components of the DBMS
  • 2.5.1 System Hardware
  • 2.5.2 System Software
  • 2.5.3 Data
  • 2.5.4 Users
  • 2.5.5 Procedures
  • 2.5 The Need for a Database Management System
  • 2.6 Database Management Administration
  • 2.6.1 Roles of a Database Administrator
  • 2.7 Web based Alumni Database Management System
  • 2.8 Database Query system
  • 2.9 Review of Related Works

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 Analysis of the Proposed System
  • 3.3.1 Data Flow Diagram of the Proposed System
  • 3.3.2 Advantages of the Proposed System
  • 3.3.3 Justification of the Proposed System
  • 3.4 Functional Requirements
  • 3.4.1 Use Case Diagram Of The Admin / User Privileges
  • 3.5 Data Requirements
  • 3.6 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.8.2 Security Design Specification
  • 4.8.3 System Architecture
  • 4.9 Computer Hardware Minimum Requirement
  • 4.10 Software Requirement
  • 4.11 Personnel / User Training

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”

ABSTRACT

An Automated Web based Alumni Database Management System is a way of bringing many methods of reporting and control into one working environment. The aim of the study is to design and implement of A Web-Based Alumni Database Management System. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will keep alumni information organized under administrative control no matter how disparate, fast changing or intricate it may seem, incorporate automation in the storage and retrieval of alumni information and provide ease of access through the use of well-designed, user friendly interfaces and the World Wide Web. The motivation that led to the implementation of the proposed system is that the manual approaches employed in the management of alumni information are not flexible, efficient and productive. Keeping track of all students who passed through the university since its inception is obviously an uphill task as files containing information and details of these students may have been lost, damaged or even forgotten about. The methodology adopted in this study is the structured system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. This research work will be of benefit to college of education, polytechnic and university students and alumni officials. The expected result is A Web-Based Alumni Database Management System that will automate the mechanism for search and retrieval of information, save time and cost and ensures uniformity by providing a centralized database system for all alumni information.


Design and Implementation of a Web-Based Alumni Database Management System

CHAPTER ONE

1.1 Introduction

An Automated Web based Alumni Database Management System is a way of bringing many methods of reporting and control into one working environment. The Alumni association is independent of the school in funding and administrative support. The Association administration is run through the efforts of volunteers and part-time hires. The inability of the association to become a viable entity can be attributed to a few major factors. First, the fluctuations in the work force effort and the lack of consistent commitment to the association have caused inefficient and misguided efforts. The second major factor affecting the viability of the Alumni Association is the lack of an accurate and homogeneous database of the school’s alumni. Alumni records over the history of the school have been maintained in a variety of non-automated methods.

As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitations of the Study and Definition of technical terms.


1.2 Background of Study

The Nnamdi Azikiwe University Alumni Association has been in existence for a number of years but has not been able to become a viable entity. The association's goal is to provide a professional network for the graduates of the Nnamdi Azikiwe University. The Alumni association is independent of the school in funding and administrative support. The Association administration is run through the efforts of volunteers and part-time hires.

The inability of the association to become a viable entity can be attributed to a few major factors. First, the fluctuations in the work force effort and the lack of consistent commitment to the association have caused inefficient and misguided efforts. The second major factor affecting the viability of the Alumni Association is the lack of an accurate and homogeneous database of the school's alumni. Alumni records over the history of the school have been maintained in a variety of non-automated methods. Once a student graduatesthe records are archived, thus making access to these records difficult and time consuming.

This research work is focused on developing a computerized Web based Alumni Database Management System to handle the data requirements of the association. The basic requirements for the system include the storing of alumni data for quick and efficient retrieval, which would also provide mechanisms for the updating of the stored data in an automated manner.

Increasing demand for accuracy, efficiency and effectiveness coupled with user friendliness has become the major strive of most organizations public or private. This fundamental requirement presents the notion that automated systems are not only indispensable part of every organization but is also a way of achieving accuracy, efficiency and stated effectiveness within the body.

Zuboff (1988) defines the process of automation as a service to perform tasks with great speed and accuracy.

A web based Alumni Database Management System, all necessary efforts and analysis were implemented in order to develop a suitable database management system that will solve the problem faced by the university alumni department, by efficiently reducing the time taken in storing varied information of the numerous alumni in files and cabinets that are almost insecure and stressful to access. Nnamdi Azikiwe University Alumni Association has variety of methods in the control, management and reporting thereby necessitating automation of the system.

Grammatikou et al., 2003 had found that databases and information retrieval technology had changed the ways organizations were producing reports by providing on spot and timely access from various locations.

The World Wide Web (WWW) became one of the most important media for sharing information resources. Programs, tracking of information, information monitoring, and various other types of resources could be accessed through the www (Bing et al., 2001). Research results, new findings, and other information could also be put on the web from anywhere at any time by the right people. Therefore, since www had provided a good infrastructure, Reports could be accessed centrally by management of alumni department using an integrated Management Information System through the Internet.

Harpreet (2002) mentioned that the use of WWW or computer system could enhance organizations and improve on their communication and therefore effectiveness in service delivery. Likewise, organizations and institutions today are being forced by the internet to move toward “teleworking”. Therefore, there was need for web-based computer system that could provide easy access of information online and also provide accessibility to information from anywhere, anytime. This necessitated management to have access to the database. This was done by registering them into the system and then giving the privilege to them once logged-in. This was provided at the login time and other unauthorized users denied access.

An automated Web based Alumni Database Management System is important for management of university alumni as well as for the staff and productivity. Unfortunately, the system seemed to be far-fetched, especially when it was done manually using many different methods of data manipulation. But with automation, only the administrator will have to be responsible for the manipulation of data using highly advanced and user friendly user interfaces. This of course will result in speed and accuracy in data handling Zuboff (1988).


1.3 Statement of Problem

Overtime, traditional approaches have been employed in the management of alumni information, and this approach is not flexible, efficient and productive. Keeping track of all students who passed through the university since its inception is obviously an uphill task as files containing information and details of these students may have been lost, damaged or even forgotten about. At times reports disappear as they are hard copies and tracing them becomes a problem.

The few computers in use are all stand-alone which has created a lot of loopholes in the system because there is no tracking and/or monitoring of the system for the information available in the department and there are no security measures in place.

Such complex scenarios were often not easy to satisfy manually because the process of managing data will be stressful due to numerous file handling, slow because of non-automation, inflexible due to disparity in information supplied and most likely repetition of records; thus the need for computer software, and a web based automated system as well as a centralized database.


1.4 Aim and Objectives of the Study

The aim of the study is to design and implement of a Web-based Alumni Database Management System. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will:

  1. Keep alumni information organized under administrative control no matter how disparate, fast changing or intricate it may seem.
  2. Incorporate automation in the storage and retrieval of alumni information.
  3. Incorporate security measures in data manipulation within the system.
  4. Provide ease of access through the use of well-designed, user friendly interfaces and the World Wide Web.

1.5 Significance of Study

A web-based alumni database management system for Nnamdi Azikiwe University will:

  1. Save time and cost.
  2. Automate the mechanism for search and retrieval of information.
  3. It ensures uniformity by providing a centralized database system for all alumni information.
  4. It is faster, more user friendly, and provides secured access to information.

This study will be of immense benefit to other researchers who intend to know more on this study and can also be used by non-researchers to build more on their research work. This study contributes to knowledge and could serve as a guide for other study.


1.6 Scope of Study

The scope of this study is limited to designing a web-based alumni database system for Nnamdi Azikiwe University alumni, which will serve as a central repository for all information of her graduates.


1.7 Limitations of the Study

During the course of this study, many things militated against its completion, some of which are:

  1. Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
  2. Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this project work. There were lots of information needed from the staffs of this institution to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
  3. Research material: availability of research material is a major setback to the scope of the study.
  4. Frequent power failure: This made the researcher append more money on fuel to ensure sustainable power.
  5. Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).

1.8 Definition of Terms

Data: facts or information, especially when examined and used to find out other things or to make a decision.

Data item: smallest named unit of data that has meaning in the real

Record: group of related data items treated as a unit by an application program

File: collection of records of a single type (examples: president, election)

Database: an organized set of data that is stored in a computer and can be looked at and used in different ways

Database management system (DBMS): a generalized software system for organizing and managing a large amount of data.

Database administrator (DBA): person or group responsible for the effective use of database technology in an organization or enterprise.

Object: is anything exhibiting a property and/or behavior of interest within the scope of the system under investigation.

CHAPTER TWO

2.0 Literature Review

2.1 Introduction

This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

Summary Headlines for Design and Implementation of a Web-Based Alumni Database Management System