Triggers and Stored Procedures, Database Management System

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can
never change his or her department.

10A.54 Code an Oracle Database trigger to allow the deletion of a department if it
only has one employee. Assign the last employee to the Human Resources
department.

10A.55 Design a system of triggers to enforce the M-M relationship. Use Figure 10A-53 as an
example, but assume that departments with only one employee can be deleted.
Assign the last employee in a department to Human Resources.
Posted Date: 12/8/2012 9:56:14 PM | Location : United States







Related Discussions:- Triggers and Stored Procedures, Assignment Help, Ask Question on Triggers and Stored Procedures, Get Answer, Expert's Help, Triggers and Stored Procedures Discussions

Write discussion on Triggers and Stored Procedures
Your posts are moderated
Related Questions
Consistency error : These errors happen due to the inconsistent state of database caused may be due to wrong implementation of commands or in case of a transaction abort.  To overc

Explain the term High level DML? High level DML A high-level or non-procedural DML permit the user to specify what data is needed without specifying how it is to be acquired.

Given the following relations Vehicle (Reg_no, make, colour) Person(eno, name, address) Owner(eno, reg_no) Write expressions in the relational algebra to answer the following


WHAT IS MEANT BY E-R MODEL


Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships

Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

A Distributed Transaction Let us demonstrate the concept of a distributed transaction by considering a banking system having of three branches located in 3 different cities. Ev