Produce different final database state than using trigger

Assignment Help Database Management System
Reference no: EM1360147

Consider the simple relation Employee(ID, salary) storing the employee Ids and salaries, where ID is a key. Consider the following two triggers over this relation:

create trigger T1
after insert on Employee
referencing new as New_Emp
update Employee
set salary = 1.1 * (select max(salary) from Employee)
where ID = New_Emp.ID
for each row

create trigger T2
after insert on Employee
referencing newtable as New_Emp
update Employee
set salary = 1.1 * (select max(salary) from Employee)
where ID in (select ID from New_Emp)
for each statement

Assume that relation Employee has no tuples in it initially. You are to show the simplest example you can think of where using trigger T1 will produce a different final database state than using trigger T2.

Reference no: EM1360147

Questions Cloud

Explain the case study on accelerating ideas to market : Explain the Case Study on Accelerating Ideas to Market and The AIM Process
Determine the rotation rate : Compare these two ratings by determining the ratio of energy.
Illustrate where y is the amount of output the short-run : A firm has fixed cost of 2,000.Its short-run production function is y+4X and one-half, where x is the amount of variable factor it uses. The price of the variable factor is $3,000 per unit. Illustrate where y is the amount of output the short-run..
Compute probability of hedging : Jones Corporation needs 200,000 Canadian dollars in 90 days and is trying to estimate whether or not to hedge this position. Jones has developed the following probability distribution for the C$:
Produce different final database state than using trigger : Assume that relation Employee has no tuples in it initially. You are to show the simplest example you can think of where using trigger T1 will produce a different final database state than using trigger T2.
Traditional triple constraints of time : Traditional triple constraints of time - What are the triple constraints in a Traditional Project Management Framework?
Illustrate what is the basic objective of monetary policy : Illustrate what is the basic objective of monetary policy. What are the major strengths of the monetary policy. Why is monetary policy easier to conduct than fiscal policy in a highly divided national political environment.
Distributed-functions approaches : The fourth theory is the Distributed-Functions Approaches is where the leader helps his group perform acts within a group in order to reach goals.
Common causes and special causes : Common causes and special causes - Describe the terms Common causes and Special causes?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Completing transaction using sql

Write down the complete transaction using SQL.

  Relational algebra operations

List the sequence of relational algebra operations needed to implement the queries.

  Explain the security mechanisms available for a database

Use technology and information resources to research issues in database systems. Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

  Prepare a set of non-functional requirements

Need a system that networks its 3 campuses in the US and one campus in Singapore. Transaction data for all campuses should be available to all locations. In addition, students should be able to use the Internet to view classes, enroll, register, and ..

  Write program that models an employee

Write a program that models an employee. An employee has an employee number, a name, an address, and a hire date. A name consists of a first name and a last name.

  Design and build a prototype data warehouse

Design and build a prototype data warehouse using the data on Spend over £25,000 in the Science and Technology Facilities Council

  Create application owner and stored in schema

One of the tenets of database development is to never permit developers to create or own objects during development. All objects are created by application owner and stored in that schema.

  Create the following documents for the proposed system

MGMT321 Group Project: Create the following documents for the proposed system and deliver each SDLC documents by the end of each designated module, as shown below

  Executing well-planned strategy-manage technology solution

You have a company, specializing in managing technology solutions. you have ben just hired by big firm to execute a well-planned strategy.

  Key functions of organization-map to strategic information

From information system point of view, we should take the key functions of organization and map them to strategic information. Do your companies follow this process or are steps skipped?

  How protocol ensures serializability and deadlock freedom

To lock any other vertex, the transaction must have visited all the parents of that vertex and must be having a lock on one of the parents of the vertex. Show that the protocol ensures serializability and deadlock freedom.

  Determine cost of least expensive part in part table

Write a query to determine the cost of the least expensive part in the part table? Format the returned price in dollars and cents using the correct function.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd