Managing database, 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: 8/13/2012 4:37:10 PM | Location : United States







Related Discussions:- Managing database, Assignment Help, Ask Question on Managing database, Get Answer, Expert's Help, Managing database Discussions

Write discussion on Managing database
Your posts are moderated
Related Questions
Define blocks? The database system resides eternally on non-volatile storage, and is into fixed-length storage units known as blocks.



Give the reasons for allowing concurrency? The reasons for allowing concurrency is if the transactions run serially, a short transaction might have to wait for a preceding long

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

What are the ways of obtaining the connection parameters?  Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters

Mention the purpose of SID and SOD lines SID (Serial input data line): It is an input line by which the microprocessor accepts serial data. SOD (Serial output data line)

A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

What are the factors to be taken into account when choosing a RAID level? A) Monetary cost of extra disk storage requirements. B) Performance requirements in terms of number

Mention various steps required to draw an E-R Diagram. Draw an E-R Diagram for Student Information System. Mention all suitable assumptions to justify your answer.