markCreate a database called firstnamesurname2018 (johnsmith2018, no spaces or special characters) containing four tables: employee, department, works for, manages and that reflects the facts given above. In your report, briefly describe what mechanisms you used to represent the different facts and information about the company. Write SQL instructions necessary to create the database and the tables.

2 Exercise 2: SQL 2.1 Problem description In this exercise we will implement a database keeping track of employees in a company. The database will contain the following information and reflect the following facts: e employees: thei About the company's departments: their name . An employee can work for multiple departments, they have a role in each department Employees can manage other employees. A manager can manage multiple employees and an employee can be managed by multiple managers