Pet Shop Management System for Klinik Veterinar & Surgeri Jawhari

A.Noraziah1, Noor Naimah2, M. Nasratun 3

1, 2
Faculty of Computer System & Software Engineering,
3
Faculty of Chemical & Natural Resources Engineering
University Malaysia Pahang,
Locked Bag 12, 25000 Kuantan, Pahang, Malaysia.
E-Mail : noraziah@[Link]

Abstract schedule and the pet information. All functions of

these modules will be executed without any problem
This paper presents the development of Pet Shop as long as there are no unexpected events such as
Management System (PSMS) for Klinik Veterinar & black out, system corruption and so on. We use a
Surgeri Jawhari. PSMS able to manage the pet simple language interface by using the Visual Basic
information such to produce the pet birth certificate (VB) 6.0 in order to produce the user friendly
and the pet vaccine schedule. In addition, this system system.
provides automatically calculation service payment
and generates the payment receipt. By developing
this system, the management of pet shop performs in 2. Concepts of the System
systematic through its function requirements. The
users of PSMS are the manager and the staff of the 2.1. Management System
Klinik Veterinar & Surgeri Jawhari. This system was
developed using Visual Basic language (VB) Management Information Systems (MIS),
language and Microsoft Access as the database sometimes referred as Information Management and
platform. Systems. It is the discipline covering the application
of people, technologies, and procedures; collectively
called information systems namely to solve business
problems. MIS is a different from regular
1. Introduction information systems in that they are used to analyze
other information systems applied in the operational
The Pet Shop Management System (PSMS) is a activities in the organization [1]. Academically, the
system that provides the management for the pets. term is commonly used to refer to the group of the
These include the pet information management of the information management methods tied to the
services such as cleaning, scissoring, bathing, and automation or support of human decision making,
blow drying. First, the pet must be registered before e.g. Decision Support Systems, Expert systems, and
having any services. All the important criteria such Executive information systems [1].
as name of an owner, the pet’s name, breed, date of
birth, and color need to be fulfill in the form given to
2.2. Data Management
the owner of the pet. If the customers want to buy
any pet from the Pet Shop, they also need to fill up
Organizations today operate in a highly global,
the transaction form and when the transaction
fast-paced and competitive environment. One of the
complete, they will own the pet complete with a
key resources they need to perform their tasks
pet’s birth certificate.
effectively and efficiently is the data management.
This system is developed in order to help any pet
The data management is a terminology that usually
shop to manage their pet information management
use for referring to the system. It provides an
especially for Klinik Veterinar & Surgeri Jawhari. In
interface that able to hide the specifically physical
particular, this system is developed based on the
file operation, while fully concentrate to the data
problem statement that has been discussed with the
logical. Database system is a software system class
owner of the manual system. By developing this
that relate with Database Management System and
system, the management of pet shop will
file management system [3]. A database can be
systematically perform through its function
consider as a collection of related data and the
requirements. The PSMS covers many modules such
Database Management System (DBMS) as the
as the registration, services, transaction, vaccine
software that manages and controls access to the

978-1-4244-2328-6/08/$25.00 © 2008 IEEE

database. The database approach overcomes most of system provides many modules such as the
the problems in manual system and file-based system registration, services, transaction, vaccine schedule
[2, 3, 4]. It is intended to meet the informational and the pet information. All of these modules are
needs of all users at all department or operational functioning well as long as there are no unexpected
level as well as users at the strategic level. events such as black out, corrupt and so on. PSMS
can automatically generating the pet birth certificate
3. Methodology after each complete transaction process.
The vaccine schedule is a schedule consists of pet
3.1. System Analysis type, owner’s name, and veterinary information
along with vaccinating information. The vaccinating
Over the last decade, project management information includes vaccination type and schedule
information systems have become comprehensive for the pet. From the vaccination schedule, the owner
systems that support the entire life-cycle of projects, of the pet can easily find out what kind of vaccine
project programs, and project portfolios [5]. System has his/her pet had taken and when is the next
development starts from early to end of each System vaccination date.
Development Life Cycle (SDLC) phases. The main Developments of Pet Shop Management System
objective of the system analysis phase is to study the also provide automatically calculation service
system that is currently applied in nowadays. payment and auto-generate the payment receipt.
Therefore, the problems were identified and the After all transaction or the treatments have been
problem solution alternatives have been studying for done, the system generates the total payment and
the purpose of learning the pet shop information payment receipt of the services.
management. In the analysis phase, the requirements
of the system are analyzed, reviewed and 3.3. Logical Design
documented. The requirements include both
functional and non-functional requirements. Analysis Database Management System (DBMS) helps
methods consider with the system necessity and the organizations to manage their data in a logical way.
information structure. This sub-phase involve In designing the relational database, there are three
comprehensive studying of the manual system and major database models, which are; the conceptual
the computer system that is currently used by the database, the logical database, and the physical
managers and the staffs at the company. The design database. The emphasis of logical database model is
phase includes specifying the data model by using on ‘logic’, which is a readable method and useful for
Entity Relationship Diagrams and the process model representing the knowledge [8]. This database design
by using Data Flow Diagrams. After that, gathered is most frequently used because it establishes a
information is restructured again based on the simple data form for each relation and for many-to-
relational with each other while the useless data will many relationships [8]. The core of logical database
be isolated. System input and output design are design is Entity Relationship (E-R) models [9].
generated roughly before comparing with the Figure 1 shows the E-R diagram for Pet Shop
required real system. Business process modelling is Management System.
the important aspects in software system design [6]. The concept database management system is
On the other hand, the cost of operation, time applied in PSMS for data accessibility. For example,
consuming and technical level for the development users in Pet Shop namely the manager and the staffs
can be fixed. may need to access customers and pets details by
Computerize system is more reliable and using keywords such as name, Customer No, or Pet
accurate. Data analysis will be processsed faster and ID. A database management system allows an
safer. But most software is delicate: even the organization to structure its information so those
slightest error, such as changing a single bit, can users can retrieve data in a flexible manner as well as
crash it down. Thus, development techniques to prevent users against unauthorized access.
emphasis on design should be managed correctly to
overcome this fragility [7].

3.2. Pet Shop Management System

PSMS is developed in order to manage the pet

information, vaccine schedule and automatically
calculate the payment. It is a standalone system. This

978-1-4244-2328-6/08/$25.00 © 2008 IEEE

 4.2. Implementation Modules
1…* Pet_Registration
4.2.1. Customers Registration Module
petID
ownerID 1…*
petName Customers Registration module supports the
DOB has users to add new records, edit, and delete. Through
1…* Sex this module, the user need to fulfill two different sets
Breed 0…*
Owner Color
of information that are customer info and the pet
Appointment info. Figure 2 shows the registration modules of
ownerID PSMS.
Address petID
Telephone vaccineID
Occupation Date
Time

0…* has

Service
Payment
serviceNo
vertID payNo
serviceDetails Date
0…* payTotal
vertID
1…* VeterinaryDetails

vertID 1…*
vaccineID
vaccineType has
1…* vertName
nextVaccine
vaccineExpDate 1…*

Figure 1. Entity Relationship Diagram

Figure 2. Customers registration module.

From the research, it is known that the inputs During registration, the user must fill in all the
needed for the system development were related with information required in the form. If users not fulfill
the particular entities. all the information required, the message box will
request the user to fill in the blank field. The
4. Implementation telephone number must be in integer value, the
message box will appear if user types in the data
4.1. Software other than integer value. To ensure the successful
registration, user must fill the correct information
PSMS has been developed using the several and fill in both the owner’s profile and pet profile.
software such as Visual Basic 6.0, Microsoft Access
2003, and Microsoft Project 2003. The system 4.2.2. Pet Info Module.
development was fully implemented through Visual
Basic 6.0. Microsoft Access is used to manage the
By using Pet Info module, user will be able to search
data. This DBMS supports the data and able to
information about the pets and its owner. Figure 3
manage the data efficiently. Programming in VB is a
shows the Pet Info module.
combination of visually arranging components or
controls on a form, specifying attributes, and actions
of those components, and writing additional lines of
code for more functionality.

978-1-4244-2328-6/08/$25.00 © 2008 IEEE

 feature with effective data control. This system
approach allows users to access data in a flexible
manner.

6. References
[1] S. Norazuwa. Diploma Thesis: “Web Based Library
Management System”, Kolej Universiti Kejuruteraan dan
Teknologi Malaysia, 2006.

[2] Noraziah, A. Disertation Thesis: “Tender Management

in Kadastra”, University Putra Malaysia, 2002.

[3] T. M. Connolly, C.E. Begg, Database System A

Practical Approach to Design, Implementation and
Management. Addison-Wesley, 2005.

[4] M.V, Database Design, Application, Development, and

Administration, McGraw-Hill, New York, 2004.
Figure 3. Interface of PSMS in Pet Shop for [5] Ahlemann F, “Towards a Conceptual Reference Model
Pet Info module. for Project Management Information Systems”,
International Journal of Project Management, 2008.
In this module, user can search the pet information.
The searching activity can be done by selecting kind [6] Joseph B, “The importance of business process
of type the user wants to search, either via breed or modeling in software systems design”, Science of
sex. Then, user need to click search button to view Computer Programming 71, 2008, pp. 73–87.
the information. The information will display on the [7] P. Van Roy, “Self Management and the Future of
database grid (DBGrid). If users want to buy certain Software Design”, Electronic Notes in Theoretical
pet, they need to select the row of the DBGrid and Computer Science 182, 2007, pp. 201–217
click “Buy” button.
[8] C. Lin, and C. Hong, “Using Customer Knowledge in
Designing Electronic Catalog”, Expert Systems with
5. Conclusion & Future Work Applications, Vol 34, Issue 1, ScienceDirect, January
2008, pp. 119-127.
The main purpose of this research is to develop
a Pet Shop Management System for Klinik [9] S. Kesh, “Evaluating the Quality of Entity Relationship
Verterinar dan Surgeri Jawhari. This system will Models”, Information and Software Technology, Vol 37,
Issue 12, ScienceDirect, 1995, pp. 681-689.
improve the management effectiveness of Klinik
Verterinar dan Surgeri. In addition, this system
enables the user to view all the vaccination schedule
of their pet and can make transaction that able to
generate auto calculation. Meanwhile, the pet birth
certificate can then be generating after the
transaction complete.
As the conclusion, this paper presents the
contribution of software design to the Pet Shop
Management System (PSMS) in Klinik Veterinar &
Surgeri Jawhari. Elaboration on the system analysis
and design, software and logical database design,
automatically calculation, and the software
implementation has been done thoroughly. Through
proper design and development of the system, PSMS
is able to generate automatically list of the services
plus the payment report. PSMS will helps to
overcomes most of the problems encountered in the
manual system. In addition, the software enables to
manage information that based on user-friendly

978-1-4244-2328-6/08/$25.00 © 2008 IEEE