Salary-Management-System-SQL-RDBMS

SQL Server - RDBMS

Abstraction: Salary Management System is aimed at efficient management of employee information, emoluments, expenses, net payouts, calculation salary based on workdays and pay salary etc. All of these are managed through a database. This project is terminal project, which implemented using PL/SQL and oracle database. The database is divided based on different conditions, which are known as fragments, and these fragments are kept at different locations, which has Database Management System to deal with the data. The idea of dividing/fragmenting the data makes the system reliable, fast with better response. In case of database failures, the system remains functional though it may reduce performance.

Motivation: Companies, it may be public or private increasing to fast with population growth. In addition, in every company, there is a must essential thing, a system that manage employee information and their payments. So having a well-organized Salary Management System is a market demand. Therefore, we tried to implement a smaller conceptual version of Salary Management System. In addition, as there are some large companies has distributed database system, so we focus on distributed database system in small manner so that system can perform fast and efficient ways.

List of Tables:

1. Employee
2. Salary
3. Allowance
4. Bonus

Main Features: This is a project that I have added queries of different types including.

1. Joining with Where Clause
2. Joining with Group by & Having Clause
3. Joining with Order By
4. Subquery
5. CASE Function
6. CTE
7. Roll Up
8. View
9. Create Index
10. Store Procedure
11. Create Function
12. Create Trigger

Objective:

1. Understand the system functionality and describe the main functions of the Salary Management system.
2. To computerize all details regarding employees, Salary history, Payment details.
3. Regular update employee list and their records up to date.
4. Manage all employee salary in the company.
5. To get actual report of business profit and control business system.

Summary: In this project, which I have implement based on some high quality Salary Management System. However, we could not implement it as a whole but tried to give an idea how distributed database work in real life scenario. We look forward to implement the project in future on a larger scale.