(Solved) : Attempt Reassign Smith Department 30 Create View Called Salaryvu Based Employee Name Depar Q31856645 . . . .

Attempt to reassign Smith to department 30.

Create a view called SALARY_VU based on the employee name,department name, salary, and salary grade for all employees. Labelthe column Employee, Department, Salary, and Grade,respectively.

Lesson 13

Create a sequence to be used with the primary key column of theDEPT table. The sequence should start at 80 and have a maximumvalue of 260. Have your sequence increment by ten numbers. Name thesequence DEPT_ID_SEQ.

Write a script to display the following information about yoursequences: sequence name, maximum value, increment size, and thelast number.

Write an interactive script to insert a row into the DEPT table.Be sure to use the