employees database

employees-database

Design of a MySQL database storing data on employees, their employment and company structure. Views and triggers have been added to the database, thanks to which, after adding data about a new employee, his unique e-mail address is automatically generated and information is added to the 'employment' table regarding the start of employment period. Another trigger allows you to automatically collect data of former employees in the 'employment_history' table by assigning the date of termination of employment as the date of removing the employee from the database. The database also uses a procedure that allows for efficient downloading of information on employees' annual and monthly remuneration or bonuses.