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

Ask an Expert

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

Write your message here..

Related Questions

Clinic database design, Implementation and SQL Applications Implementation and SQL Applications

Explain projection operation distribute over union operation, Illustrate th... Illustrate the statement 'Projection operation distributes over the union operation'. Give an example.    Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 ))   This says th

Define normalization, Normalization :It is a process of examine the given ... Normalization :It is a process of examine the given relation schemas based on their primary key and Functional Dependencies (FDs) to achieve the properties Minimizing redun

Explain displaying an er schema as an er diagram, Explain the conventions f... Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.

List the reg-no of vehicles owned in relational algebra, Given the followin... 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

Fragmentation-design of distributed databases, Fragmentation: It is defini... Fragmentation: It is definite as partitioning of a relation into various fragments.Every fragment can be stored at a dissimilar site.

Define radix conversion method, Define Radix conversion method  One cle... Define Radix conversion method  One clever way to transform binary numbers to BCD notation (binary-coded decimal) is the "double dabble algorithm". It can be adapted to transfo

Explain query execution plan, Explain query execution plan? - Optimizer... Explain query execution plan? - Optimizer available in SQL Server optimizes code to be effectively executed. - A query execution plan demonstrates how this optimizer would r

Transactions t1 and t2 are in a deadlock, Evaluate: a.When transactions... Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.

Accessing information permissions users, Accessing information about permis... Accessing information about permissions to all users- Object level permissions: With the use of data dictionary you can see the permissions to user. Let us get the table name fro