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
Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement

using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat

Explain trivial dependency? Functional dependency of the form α ->β. is trivial if α C β. Trivial functional dependencies are satisfied by all the relations.

Define Timestamp ordering Ans In timestamp-based method, a serial order is made among the concurrent transaction by assigning to every transaction a unique nondecreasing number

What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.

Write a Query that uses the UNION Operator 1. Use the Software Experts database to:   a. Display the first and the last name of all consultants who worked on any projects f

Differentiate between Procedural and non procedural languages ? Procedural and non procedural languages - A procedural language specifies the operations to be performed on th

What are the three data anomalies that are likely to occur as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why not? A

XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v

What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on