CONFLUENCE UNIVERSITY OF SCIENCE
AND TECHNOLOGY, OSARA, KOGI STATE
SIWES PROJECT REPORT ON
PET MANAGEMENT DATABASE SYSTEM
A REPORT SUBMITTED IN PARTIAL FULFILMENT OF THE REQUIREMENTS FOR
THE AWARD OF [Link] IN INFORMATION TECHNOLOGY
DEPARTMENT OF INFORMATION TECHNOLOGY
OCTOBER 2025
TABLE OF CONTENTS
Chapter One: Introduction 3
1.1 Background of the Study 3
1.2 Problem Statement 4
1.3 Aim and Objectives 4
1.4 Significance of the Study 5
1.5 Scope of the Study 5
1.6 Limitations 6
Chapter Two: Literature Review and Importance to the Management System 7
2.1 Introduction 7
2.2 Concept of Database Management System (DBMS) 8
2.3 Staff Management in Organizations 8
2.4 Related Works 9
2.5 Importance of the Project 9
Chapter Three: System Design and Implementation 10
3.1 Flowchart of the Project 10
3.2 Project Database Code (MySQL) 11
3.3 Entity Relationship Diagram (ERD) 12
Chapter Four: Conclusion and Recommendations 13
4.1 Conclusion 13
4.2 Recommendations 14
Appendices 15
References 16
CHAPTER ONE
INTRODUCTION
1.1 Background of the Study
Pet management has become increasingly important in modern society as the number of pet
owners continues to grow. Managing this data manually often leads to inefficiency, data
loss, and errors. Using MySQL provides a better, more organized approach.
1.2 Problem Statement
Manual record keeping can lead to misplaced files, duplication of records, and retrieval
delays. A database system can solve these issues effectively.
1.3 Aim and Objectives
The aim is to design a Pet Management Database System using MySQL.
Objectives include: creating relational tables, implementing CRUD operations, and ensuring
data security.
1.4 Significance of the Study
This study provides a foundation for efficient data handling in pet clinics and demonstrates
how databases can be applied to real-world management systems.
1.5 Scope of the Study
The project focuses on designing and implementing a pet management database using
MySQL, covering pets, owners, and veterinary data.
1.6 Limitations
The system does not cover billing or notification services; it focuses purely on database
management and design.
CHAPTER TWO
LITERATURE REVIEW AND IMPORTANCE TO THE MANAGEMENT SYSTEM
2.1 Introduction
This chapter reviews literature related to database management systems and their role in
efficient data handling.
2.2 Concept of Database Management System (DBMS)
A DBMS provides mechanisms for storing, organizing, and retrieving data efficiently. MySQL
is a relational DBMS widely used for its performance and scalability.
2.3 Staff Management in Organizations
Database systems streamline employee data management, improve data accuracy, and
reduce redundancy.
2.4 Related Works
Several similar projects exist, such as hospital and student management systems. The Pet
Management Database adapts these ideas for animal care.
2.5 Importance of the Project
The project ensures better organization of pet data, reduces human error, and allows for
faster report generation.
CHAPTER THREE
SYSTEM DESIGN AND IMPLEMENTATION
3.1 Flowchart of the Project
[Space reserved for Flowchart Diagram]
3.2 Project Database Code (MySQL)
CREATE DATABASE pet_management;
USE pet_management;
CREATE TABLE owners (
owner_id INT AUTO_INCREMENT PRIMARY KEY,
full_name VARCHAR(100),
phone VARCHAR(20),
address VARCHAR(150)
);
CREATE TABLE pets (
pet_id INT AUTO_INCREMENT PRIMARY KEY,
owner_id INT,
name VARCHAR(50),
species VARCHAR(50),
breed VARCHAR(50),
gender VARCHAR(10),
birth_date DATE,
FOREIGN KEY (owner_id) REFERENCES owners(owner_id)
);
CREATE TABLE vet_records (
record_id INT AUTO_INCREMENT PRIMARY KEY,
pet_id INT,
visit_date DATE,
diagnosis TEXT,
treatment TEXT,
vet_name VARCHAR(100),
FOREIGN KEY (pet_id) REFERENCES pets(pet_id)
);
3.3 Entity Relationship Diagram (ERD)
[Space reserved for ER Diagram]
CHAPTER FOUR
CONCLUSION AND RECOMMENDATIONS
4.1 Conclusion
The Pet Management Database System demonstrates effective database design using
MySQL, ensuring organized and reliable data management.
4.2 Recommendations
Future versions should include a web interface for easier access and possibly integrate with
a mobile app for pet owners.
APPENDICES
Appendix A: Sample SQL Queries and Data Screenshots
REFERENCES
1. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems. Pearson
Education.
2. Date, C. J. (2019). An Introduction to Database Systems. Addison-Wesley.
3. MySQL Documentation. (2024). MySQL Developer Guide. Oracle Corporation.
4. Korth, H. F., & Silberschatz, A. (2018). Database System Concepts. McGraw-Hill Education.
