Construct the following SQL queries:

Write a trigger to create a default department location in Bellaire every time new department is inserted into database.

Write a trigger to enforce following constraint: employee salary must not be higher than the salary of his/her direct supervisor. If it is, then display message Please, provide correct value for the employee salary".

Write a trigger to update supervisor SSN of an employee with the SSN of the department manager where he/she works before inserting the record into employee table if the supervisor SSN attribute is empty or NULL.

Create a view that displays first name, last name, SSN, salary, department name and department number for each department manager.

Create a view that displays project number, project name, controlling department number, controlling department name, total number of employees, total salary paid, and total hours worked for each project.

Nanartmant Dependent Dept_locations. Employee Works_on