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

Calculate the joint probability, Consider the following frequency counts o... Consider the following frequency counts of some itemsets in a transaction database r : freq({A}, r) = 0.405 freq({B}, r) = 0.510 freq({C}, r) = 0.303 freq({A

What are the various symbols used to draw an e-r diagram, What are the vari... What are the various symbols used to draw an E-R diagram? Explain with the help of an example how weak entity sets are represented in an E-R diagram. Various symbols used to d

Define object-oriented database, Question : Object-Oriented Database (O... Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente

Explain the role of a database administrator, Explain the Role of a databas... Explain the Role of a database administrator a. Defining the Schema   The DBA describes the schema which consists of the structure of the data in the application. The DBA

Define first normal form and second normal form, First Normal Form and seco... First Normal Form and second normal form First Normal Form (1NF) A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combinat

Define the term e-government, Question: (a) Define the term e-Governme... Question: (a) Define the term e-Government and briefly explain, using appropriate examples, the aspects it covers. (b) Give four reasons as to why a country should adopt e

Explain the functions and components of ddbms, Question 1 Explain the conc... Question 1 Explain the concept of database recovery management. Explain the different levels of backup used for recovering data Question 2 What are the different types of par

Relational database implementation, You must implement the entity relations... You must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO (2) we

Mis, explain three types of internet risks to the consummers whent he busin... explain three types of internet risks to the consummers whent he business system is data dependent. how can we minimise these risks

Column constraints-on delete cascade, CREATE TABLE prodtrans ( pno ... CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);