PAYROLL MANAGEMENT

A distributed database project which is done by Oracle(PL/SQL) with the usages of VIEW , FUNCTION , PROCEDURE , CONDITIONAL STATEMENT, CURSOR , EXCEPTION , FRAGMENTATION , 2 SITES (My PC, VMWARE/Virtual Box)

Features:

- Admin can see how many employees are allocated in each department

- Can calculate department wise salary expenses

- Can view which employee works under which manager

- Employee can view their yearly salary

- How many transaction each employee made

- Calculate their compensation and deduction

Technologies: Oracle(PL/SQL) , VM-Ware , Notepad++ , Github