Please help

For each question below, provide solution for DBMS of your choice (Oracle or Microsoft SQL Server) as shown in class. So, your answer must contain the following: SQL command Output from DBMS (Oracle or Microsoft SQL Server) 1. Create the database for following relational schema with Employee, Department, and Works tables: Employee(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, hours: integer) Department (did: integer, dname: string, budget: real, managerid: integer) Define a table constraint on Department that will ensure that managerid is always positive and less than 1000. Insert the following records in the database: Get the sorted list of name and budget of each department in which employee Jones works. Get the name and id of youngest employee in Research department. Create a view that shows the eids and managerids in Sales department. Add a column called numHours to the Employee table. Use the UPDATE command to insert values into this new column to correspond to the current information in the Works table. Write a trigger that will increment the new field num Hours in the Employee table automatically whenever a record is inserted in the Works table. Write a trigger that will decrement the new field numHours in the Employee table