Advanced Database Management System
Key points:
- SQL database that is used to streamline the salary system for companies
- Built an E-R diagram to know how 9 entities are related in the payroll management system for any company
- Created a CDB (container database) and a PDB (pluggable database) enabling users to manage the data according to area of interest
- Created Relational, Inline, and Materialized views, satisfying varying business needs
Additional points:
- Calculates monthly pay, taxes, and social security of the company’s workers