Question

4. Create the student database with the following tables and do the following: assessment(reg_no,name, mark1, mark2, mark3, total) dept_details (dept_no, dept_name, location). Using alter command drop the column location from the table dept_details. Display all dept_name along withdept_no. Drop the table dept_details. Write a PL/SQL Trigger to verify the data before insertion on assessment table.​

Answer 1

Answer:

Create the student database with the following tables and do the following: assessment(reg_no,name, mark1, mark2, mark3, total) dept_details (dept_no, dept_name, location). Using alter command drop the column location from the table dept_details. Display all dept_name along withdept_no. Drop the table dept_details. Write a PL/SQL Trigger to verify the data before insertion on assessment table.​