A database can be defined as a body of information held within a computer system
using the facilities of a database management system. (Myrin F.Chester. Avtar k.
Athwall, 2011) A database can also be defined as an organized collection of data.
There are many strategies for organizing data to facilitate easy access and
manipulation. Database management systems allow for access and storage of data
without concern for the internal representation of data. A database management
system provides mechanisms for storing and organizing data in a manner
consistent with the database’s format. There are several types of database
management systems. They can be classified according to the way they structure
records.
“Early database management systems organized records in hierarchies or networks
implemented with indexes and linked list. But today, most successful database
management systems are based on relational technology.” (Jeffrey Whitten et al,
2010). A relational database is a logical representation of data that allows data to be
accessed without consideration of the physical structure of the data. A relational
database stores and implements data in a series of two-dimensional tables that are
related to one another via foreign keys. Each table is sometimes called relation
consists of named columns (fields or attributes) and any number of unnamed rows
(records).
A data manipulation language is used to create, read, update and delete records in
the database and to navigate between different records. The data manipulation
language of most relational database is called SQL. It supports complete database
creation, maintenance, and usage. It also provides basic commands such as
(SELECT FROM, WHERE, INSERT. UPDATE, DELETE, e.t.c) to access data in
tables. The structured query language can be used in two ways: interactively or
embedded inside another program. It is used interactively to directly operate a
database and produce the desired results. The second way to execute a SQL
command is by embedding it in another language such as COBOL, BASIC, Visual
Basic, C or Java. The result of the embedded SQL command is then passed to the
variables in the host program, which in turn will deal with them. This application is
implemented by combining structured query language (SQL) together with a high
level language (i.e. JAVA) which allows the creation of user interfaces and
database access in one application. To design the illustration above, it would
commence with the database design which would reveal all the necessary
component, entities and attribute that would be needed throughout the course of
our implementation. The Microsoft Access database consists of four tables, which
are EMPLOYEE, Setting, Deductions and Login. These four tables would serve as
the basis for discussion for the requirement of the system. The tables (records) used
are listed below as applied within the program listing. The following shows the
payroll Microsoft Access database and its schema:
EMPLOYEE: This table consists of 17 columns namely: Emp_Code,
Emp_Name1, Emp_Name2, Emp_Desi, EmEmp_Add, Emp_No, Emp_Email,
Emp_Appointment, Emp_Birth, Emp_Union, Emp_Gender, Emp_TaxState,
Emp_BankName, Emp_BankBranch, Emp_Account, and Emp_PFAName,
Emp_PenPin.
Fig 3.4: EMPLOYEE table.
Employee data is stored here, fig 3.4 above depicts this table
Setting: This table consists of 20 columns namely; Category_Type,
Category_Name, Basic_Pay, Food, Transportation, Other, PENSION, Absenses
per Day, Tax, NHF, Union Dues, “”, Food_allow, Transportation_Allow,
UDues_Dedu.
Fig. 3.5: Settings Table.
The fig. 3.5 above shows the Settings table, this table stores the Employee
designations, allowances and deductions which are used in computing the gross
and net salary.
Deductions: The deduction table consists of 4 columns namely Emp_Name1,
No_of _days, Total and Cash_advance.
Fig 3.6: Deductions table
The fig 3.6 above also stores deductions which are used in computing gross and net
salary.
Login: This table contains 4 columns, there are username, password, name1
and name2.
Fig 3.7: Login table
The Login table depicted in fig 3.7 above, stores user account login details.
These four tables are what make up the database the JAVA payroll application uses
to store and retrieve data.
CHAPTER FOUR
4.0 SYSTEM IMPLEMENTATION
4.1 INTRODUCTION
Implementation is the process by which a system developed as utilized and made
functional or the process of convening a new system design into operation. It is the
delivery of the system into production. This is the phase where all the requirement
analysis and system design is put to test to ensure effective delivery of the payroll
system.
4.2 SYSTEM REQUIREMENTS
4.2.1 Hardware Requirement
This is the aspect concerned with the physical components of the computer needed
for the effective operation of the new system. The software will run well under the
listed hardware specification:
Intel ®Pentium® III 500 MHz or compatible
512 MB RAM (recommended minimum)
1 GB RAM (recommended)
560-760 MB hard disk space minimum (depending on features installed)
4GB Hard disk( recommended)
A SVGA color monitor with high resonance
A working internet connection.
A GSM dongle, any Huawei or ZTE dongle would do.
A SIM card with a good network reception containing a moderate amount of
airtime.
4.2.2 Software Requirement
This aspect specifies the various events the proposed system would be able to
perform from the user's perspective in order to ensure a good and working system.
The following are the software needed for the smooth running of the package:
Java Runtime Environment (JRE) version 1.6 and later
J2SE 1.4,J2EE and J2ME
Microsoft Windows XP or later
Microsoft SQL Server.
In document
The Automated Payroll System(Complete)
(Page 32-38)