Payroll Management System Development Project

Running head: PAYROLL MANAGEMENT SYSTEM DEVELOPMENT PROJECT
Payroll management system Development project
Name of the Student
Name of the University
Authors note

PAYROLL MANAGEMENT SYSTEM DEVELOPMENT PROJECT
1
Table of Contents
Introduction:...............................................................................................................................2
Analysis of different types of database management systems:..................................................3
Designing a database management system using a relational model for payroll management
system:........................................................................................................................................6
User and system requirements...................................................................................6
Functional Requirements:..........................................................................................7
Non-functional requirements:....................................................................................7
Physical and logical design of the database:..............................................................8
Application design:..................................................................................................................10
Use of Visual studio and VB language for developing the User interface:.............10
Different user access levels:.....................................................................................14
Testing of database and application:........................................................................15
Test plan table for the developed application..........................................................15
System administration and management tools available for the MS SQL SERVER:
..............................................................................................................................................18
Database security tools.............................................................................................................19
Bibliography.............................................................................................................................21

PAYROLL MANAGEMENT SYSTEM DEVELOPMENT PROJECT
2
Introduction:
The database management is one of the most important components of the
information systems used by the different enterprises. The database is considered as the
collection of different interrelated data as well as set of other related programs (triggers and
procedures) in order to access the stored information. The stored group of inforamtion which
is referred to as database mainly contains information that is relevant to some enterprise.
Primary objective of using a DBMS in an enterprise is to facilitate the users a way to store as
well as retrieve some specific and required information which is convenient and efficient for
maintaining huge amount of data of an organizations different operations.
In professional organizations a payroll management system has become very much
important as by using this type of systems organizations can easily overcome the challenges
that are within a manual type of system. This type of payroll system is mainly developed for
eliminating the challenges that are faced within a traditional type of payroll system. One of
the main aim for developing this type of payroll management system is enhancing the current
organizational processes so that all the operations flows in a smooth and effective manner.
This payroll can be used by the organizations avoiding errors while important data are
entered within organization. This type of system is also very much user friendly so that the
users who do not have formal language for operating the system can operate this system.
The payroll management system is actually prepared for dealing with financial
aspects that are related with salary of the employees and with that deductions and allowance
are also deal with this payroll system. The main benefit of this type system is that it is very
much easy to implement.
In this paper development procedures of the payroll management system will be
discussed. For the discussion first different types of database management system will be

PAYROLL MANAGEMENT SYSTEM DEVELOPMENT PROJECT
3
discussed in this context. Following that development of payroll management system by
utilising the database will be discussed. The design of the application will be also discussed
briefly in this paper.
Analysis of different types of database management systems:
Currently there are different types of database management systems that are available
in the market. The most important database management systems are the Hierarchal database,
Object-oriented database, Relational database, Network database and the Object-relational
database. In the following section these databases will be discussed with both of their
weakness and the strengths.
 Hierarchal Database: The hierarchal type of database model is actually a database
model that is used for organization of the data in a tree like structure. In this type of
database all of the data are stored as records and all of these records are connected
with each other through the links. In this database records is collection of fields and
here each of the field consists only a single value. The record type demonstrates in
which the record is consisting. The hierarchal type of database follows the rule that
each of the child record will consist only one parent where every parent record can
consist one or more than one records of child. Data can be retrieved from the
hierarchal database traversing the whole database. The main strengths of the
hierarchal database is that performance of this type of data is very much higher when
compared with traditional type of database and this data type of database is very much
easy to understand. The weaknesses of the hierarchal type of database is that
complexity of implementing this type of database is very much high. Also, there are
several of problems regarding the management of database. For this database there are

PAYROLL MANAGEMENT SYSTEM DEVELOPMENT PROJECT
4
lack of structural independence and irregularity in operations. These are the main
weaknesses of the hierarchal databases.
 Object-oriented Database: The object-oriented database is a typical type of database
which represents the data within the form of classes and objects. This type of
databases follows the fundamental principles of object oriented programming. The
object-oriented database is actually the combination of relational model and the
features and the object oriented principles. The object-oriented database is actually an
alternative implementation of the relational model. This type of database management
system is hybrid type of application which utilizes the relational database principles
and object oriented principles for processing of the data. The main strengths of the
object oriented database is that it can define own data types and there is a navigation
facility among the pointers and the tables. Also, database directly represents the
aggregate objects. The main disadvantage is that it lacks the universal data model and
with that it also lack standards. Complexity of this type of database is also very much
high.
 Network Database: Network database is database model where more than one records
and files can be linked with multiple owner files and vice versa. This type of database
is viewed as an upside-down tree in which all the member information is the branch
that linked to the owner and that is bottom part of the tree. Here all the relationships
creates a net-like formation in which a single element is able to point multiple of data
elements. The main strengths of the network database model is that it provides
conceptual simplicity, data integrity, data independence and ease of data access. The
main weaknesses of the network database is that it unnecessarily increases the
complexity of the system and there is absence within the structural independence.

PAYROLL MANAGEMENT SYSTEM DEVELOPMENT PROJECT
5
 Relational Database: A relational type of database is some collective set of the
multiple type of data sets which are organised by the tables, columns and the records.
This type of database a good relationship among the tables of databases. Here these
tables communicates and able to share the information. As information is shared quite
perfectly in this type of database it facilitates searching ability, reporting and
organization of the data. SQLite is one of the important example of relational type of
database. SQLite database management system has been developed by the Oracle
Corporation and for the development of this system two languages are used which are
C and C++. MySQL is a relational type of database management like the other
database management systems. The main strengths of the relational type of database
is that it supports the operations which are based on the set theory. This database also
provides dynamic view on the database. The security of this type of database is also
very much high. The main disadvantages of this type of database is that the cost of
implementing this type of database is very much high. Also there is various of limits
in the structure of the relational type of database.
 Object-relational Database: The object-relational database is quite similar with the
relational type of database management system but in this case classes, objects and
the inheritance from the object-oriented database is directly supported in the database
schema and within its query language. Thus object-relational database can be
considered at the middle point of object-oriented database and the relational database.
The main strength of the object-relational database is its extensibility. With that other
strengths of this database are inheritance, encapsulation and polymorphism. The main
weaknesses of this type of database are the increased cost and higher complexity.
Also, other weaknesses of this database is that there is no standard query language
and security support is not present in object-relational database.