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