managing databases, 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/7/2012 12:53:09 PM | Location : United States







Related Discussions:- managing databases, Assignment Help, Ask Question on managing databases, Get Answer, Expert's Help, managing databases Discussions

Write discussion on managing databases
Your posts are moderated
Related Questions
What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs

State the Steps of Object Design Object design is a very iterative process in which various classes, relationships among objects are added when you move from one level to

What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

What is a virtual table that draws its data from the result of an SQL SELECT statement? View is a virtual table that draws its data from the result of an SQL SELECT statement.

Natural Join : It is the similar like Equi join except one of the duplicate columns is removed in the result table. The natural join is the most usually used form of join operation

The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems. (a)  A transaction executing at site A updat

What is data model? Explain object based and record based data models? Ans: A data model is an abstract model in which describes how data is represented and accessed. (i)

sql is relationally complete-justify


Describe different steps of the object-oriented design process.  The broad steps of the object-oriented design process are: a. Define context and modes of use of the system