solve

Implement SQL statements for the followings: i. Create a tablespace with a suitable name. ii. Create a user with any name and password and assign this user to the above-created tablespace. iii. Grant connect and DBA permission to the user created in the above statement. iv. Create a table salary with column (employeelD, employeename, basesalary, allowances). You must make an employeelD a Primary key. v. Insert two records in the salary table. vi. View the data by applying aggregate functions (MIN, MAX, AVG, SUM). vii. Create a trigger that will uppercase the employeename to be inserted into the salary table. viii. Delete the trigger created in the above statement. ix. Create a function that will add 5% to the base salary. x. Create an index on employeell and employeename of the salary table