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
Law Associates is a large legal practice based in Sydney.  You have been asked to design a data model for the practice based upon the following specification: The practice emplo

When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place

An ideal data dictionary should have everything a DBA wants to know about the database. 1 Conceptual, External, and internal database descriptions. 2.    Descriptions of attr

1. Identify the comparisons and exchanges made to sort the following array using the selection exchange sort technique. Note: you may not need all columns. Ori

Question: (a) List four disadvantages of the File Processing System as compared to the Database Systems. (b) The integrity of a database is enforced by integrity rules. One

I need ERP system We are selling automotive spare parts on the internet and we require ERP software, which would sync with our e-shop. Our e-shop doesn't use any e-commerce plat

Explain the steps for reduction of E-R model into relational model. Ans:(a) Entity set in E-R model will be considered as table name in relational Model. (b) Attributes of e

Support by Adding Indexes Multiple indexes can be used to access a data file by multiple access paths. In such a scheme only single copy of the data is consider, only the numbe

What is ODBC ? ODBC - Open DataBase Connectivity which is also denoted by ODBC enable the integration of SQL along with a common-purpose programming language. ODBC expose data

A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb