Question: Problem 12.1 [6] Write a TRIGGER to ensure that DEPT TABLE does not contain duplicate of null values in DEPTNO column. Problem 12.2 [6] Write

Problem 12.1 [6] Write a TRIGGER to ensure that DEPT TABLE

Problem 12.1 [6] Write a TRIGGER to ensure that DEPT TABLE does not contain duplicate of null values in DEPTNO column. Problem 12.2 [6] Write a Trigger to carry out the following action on deleting a deptno from dept table, all the records with that deptno has to be deleted from the emp table Problem 12.3 [6] Write a Trigger to carry out the following action: on deleting any records from the emp table, the same values must be inserted into the log table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I need SQL-Code to the following problems. Problem 11.1 [4] Write a procedure to add an amount of Rs.1000 for the employees whose salaries is greater than 5000 and who belongs to the deptno passed as...

CIS 205 Final Project Summer 2018 The final assignment consists of separating a database project into the phases that were outline during the semester. The project should be completed with the...

Introduction and learning objectives When you were learning about operational analysis earlier in the term, we talked about jobs that require multiple visits to the CPU (or servers) to receive their...

Answer ALL questions as they go together using oracle syntax database! Construct the database schema, insert the rows and write PL/SQL statements for the problems given. The results that you should...

OVERVIEW This lab provides you the opportunity to implement triggers with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current schema. In order to start this lab, you must...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

Students will review examples and evaluate them. Review these documents and evaluate them (click on the link): https://1drv.ms/w/s!AoYu6G3CLyuakjVCGipkRkNSBVUB?e=jrPXX6...

Provide a summary technical report with your own words about Pipelined Execution which is also named as Instruction Level Parallelism, addressing mainly the following areas: 1. What is Pipelined...

Possible Multiple Choice Questions for the Exam. Focus on the topics discussed in class. Chapter 1 Multiple Choice Identify the choice that best completes the statement or answers the question. ____...

What is D-latch? What is its purpose? Draw its combinational gates and write its truth table? What is D-Flip-Flop? What is its purpose? Draw it and write its truth table? What is shift register? What...

Comprehensive Set of Transactions. The City of Lynnwood was recently incorporated and had the following transactions for the fiscal year ended December 31, 2011. 1. The city council adopted a General...

An accuracy - related penalty applies to the portion of tax underpayment attributable to I. Any substantial gift or estate tax valuation understatement II . Any substantial income tax valuation...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+ What is the nature of the contracts or agreements with unions?

=+What is the procedure for labor relations in the workplace?

=+ Are ballots compulsory?