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
Describe the Menu based interfaces for web clients or browsing? Menu-Based Interfaces for Web Clients or Browsing - These interfaces present the user along with lists of option

What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

Adding Redundant Associations for Efficient Access Redundant associations do not add any type of information, therefore during design we should actually examine structure of o

What is a data dictionary?  A data dictionary is a data structure which keeps Meta data about the structure of the database i.e.  the schema of the database.

SET concept is used in which type of modelling? SET concept is used in Network Model.


What are the DBMS languages? Briefly explain? Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language

(a) Differentiate between information and data . (b) List and briefly explain five potential benefits of the database approach compared to conventional file systems. (c) Diff


An object-oriented design process  1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in