Using RDBM, build the following DBS using all enhanced techniques acquired previously and then apply SQL statements listed below keep in mind that you are allowed to optimize all relation schemas: employee (employee name, street, city) works (employee name, company name, dept, salary, shift) company (company name, city) manages (employee name, manager name) 1. Create the following views: a. List all employees based on their shift. b. List all company branches. c. Show companies based on cities. 2. Find the highest salaries based on departments. 3. Divide employees based on their roles. 4. Grant admins all privileges. 5. Find employees works in city of London even retired ones