Employee Management System

Only available on StudyMode
  • Download(s) : 156
  • Published : April 18, 2013
Open Document
Text Preview
School of Mathematics and Systems Engineering Reports from MSI - Rapporter från MSI

Employee Management System

Kancho Dimitrov Kanchev

Dec 2006

MSI Växjö University SE-351 95 VÄXJÖ

Report 06170 ISSN 1650-2647 ISRN VXU/MSI/DA/E/--06170/--SE

Abstract
This report includes a development presentation of an information system for managing the staff data within a small company or organization. The system as such as it has been developed is called Employee Management System. It consists of functionally related GUI (application program) and database. The choice of the programming tools is individual and particular.

Keywords
Information system, Database system, DBMS, parent table, child table, table fields, primary key, foreign key, relationship, sql queries, objects, classes, controls.

-2-

Contents 1. Introduction…………………………………………………………4 1.1 1.2 1.3 1.4 2.1 2.2 2.3 2.4 2.5 Background……………………………………………………....................4 Problem statement ...…………………………………………………….....5 Problem discussion………………………………………………………....5 Report Overview…………………………………………………………...5 Method...…………………………………………………………………...6 Programming environments………………………………………………..7 Database analyzing, design and implementation…………………………10 Program’s structure analyzing and GUI constructing…………………….12 Database connections and code implementation………………………….14 2.5.1 Retrieving data from the database………………………………....19 2.5.2 Saving data into the database……………………………………...22 2.5.3 Updating records into the database………………………………..24 2.5.4 Deleting data from the database…………………………………...26

2. Problem’s solution……………………………………………….....6

3. Conclusion………………………………………………………....27 4. References………………………………………………………...28 Appendix A: Programming environments and database content….29 Appendix B: Program’s structure and code Implementation……...35 Appendix C: Test Performance…………………………………....56

-3-

1. Introduction
This chapter gives a brief theoretical preview upon the database information systems and goes through the essence of the problem that should be resolved. 1.1 Background Most of the contemporary Information systems are based on the Database technology as a collection of logically related data, and DBMS as a software system allowing the users to define, create, maintain and control access to the database. The process of constructing such kind of systems is not so simple. It involves a mutual development of application program and database. The application program is actually the bridge between the users and the database, where the data is stored. Thus, the well-developed application program and database are very important for the reliability, flexibility and functionality of the system. The so defined systems differentiate to each other and their development comprises a great variety of tasks to be resolved and implemented. The basic idea can be depicted on Figure 1.1 below:

Information System Dbase Queries Retrieve U S E R S Application Program Database

Insert

DBMS

Update Database System Delete

i

Figure 1.1 Database information systems - principle scheme Information system suggests a computer technology to be used in order to provide information to users in an organization (for instance), as for the purposes of data transformation into useful information; computer hardware and software are designed and used [2]. A particular case is the Human Resources Information System development. This kind of systems are responsible for storing data of the staff within an organization and generating reports upon request.

-4-

Such kind of system could be integrated with other Information systems or modules: Accounting Information System (AIS) – designed to transform financial data into information, or Management Information System (MIS) that provides decision-oriented information to managers, and so on… “Organizations depend on Information Systems in order to stay competitive. Productivity, which is crucial to staying competitive, can...
tracking img