27-08-2012, 02:36 PM
HRM DATABASE MANAGEMENT SYSTEM
HRM-Database-Management-Java-project.doc (Size: 128.5 KB / Downloads: 29)
ABSTRACT
This project creates software that stores and manages all the data needed to describe the personnel and their framework within an organization. It includes definition of various levels of hierarchy in an organization, the salary structure pertaining to every element in this hierarchy, the description of every department functioning in the organization and the overall employee database which integrates elements in all the aforementioned.
It has a database administrator who has access to the entire database, in regards with viewing and update of information. This exclusive right is implemented using authorized access. Also viewing of all data and editing of personal data can be done by any employee, this also using authorized access. Communication between personnel and administrator has also been provided for.
The data can be accessed, manipulated and retrieved very easily. The interface has been made very user friendly. The data is well protected for use and the data processing ie, result of query functions has been made very quick and efficient.
DEFINITIONS OF PROBLEM
Problems with the conventional system:
Lack of immediate retrievals: In the conventional system, information is distributed across several files. This might also lead to data redundancy with repetition of the same information in various files. In the event of a complex or nested query, the search has to scan several files, thus making procurement of requested query results very cumbersome.
Maintenance of Accuracy and Reliability issues: With redundancy comes consistency issues as the update of information in a single record should be echoed in all records containing the same information. Also atomicity issues ie, completion of a transaction in totality or nothing at all; has to be maintained. This is difficult in a multi-file system.
Lack of immediate information storage: The information generated by various transactions takes time and efforts to be stored at the appropriate places in various files. Time overhead occurs in the case of this search and access. Also resource utilization is an issue. Overconsumption of space is an inevitable result of data redundancy.
Lack of prompt update: Updates associated with a record in a file is to be reflected in all records wherein the particular record is present. This concurrent update poses the problem of time lag. Errors in commit operation to some particular files cause the grave issue of data inconsistency.
Error prone manual calculation: Manual calculations are error prone and relatively immensely time consuming, in spite of which they may result in generation of incorrect information. Verification is another overhead, which can be saved through efficient design and implementation
OBJECT ORIENTED TECHNIQUES
Object oriented programming (OOP) is an approach to program organization and development that attempts to eliminate some of the pitfalls of conventional programming methods by incorporating the best of structured programming features with several powerful new concepts.
It is the way of organizing and developing programs and has nothing to do with any particular programming language.
OOP treats the data as a critical element in the programming development and does not allow it too freely around the system. It ties the data more closely to the functions that operate on it and protect it from accidental corruption and modification from outside functions.
OOP allows us to decompose a program into a number of entities known as CLASSES and then builds the data and functions around these entities. The data of an object can be accessed only by the functions associated with that object however the functions of one object can access the functions of other objects.
OBJECT ORIENTED ANALYSIS
Object oriented analysis provides a simple yet powerful mechanism for identifying objects, the building blocks of software to be developed. It is mainly concerned with decomposition of a problem, into components parts and establishing a logical model to describe the system.
Object oriented design is concerned with the mapping of objects in the problem space into objects in the solution space. It creates the overall architectural model and computational model of the system. In object-oriented design, structure of the complete system is built using bottom-up approach whereas class member functions are designed using top down functional decomposition. It is important to construct structured hierarchies, identify abstract base classes and simplify the inter object communication Reusability of classes from previous design using principles of inheritance, classification of objects into sub systems providing specialized services and determination of appropriate protocols are some of the consideration of the design stage.
CONCLUSION
An Application software has been developed using oracle and java database programming connectivity via oracle driver so as to meet the requirements of an organization, thereby ensuring quality performance .The data can be accessed, manipulated and retrieved very easily. To conclude this software has proved to be a user friendly interface.