0 0 1 CREATE the following tables - a. Dept triggers - Add Identity Column (1000,1)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
0 0 1 CREATE the following tables - a. Dept triggers - Add Identity Column (1000,1) b. Emp triggers-Add Identity Column (1000,1) c. Emphistory dbo.emp_triggers Columns empid (PK, int, not null) empname (varchar(50), null) deptid (int, null) Keys dbo.emphistory Columns empid (int, null) deptid (int, null) isactive (int, null) Keys Constraints TRIGGERS a. Trigger 1 - Build a trigger on the emp table after insert that adds a record into the emo. History table and marks IsActive column to 1 b. Trigger 2 - Build a tirnner on the emp table after an update of the empname or deptid column - It updates the subsequent empname and/or deptid in the emo history table. c. Build a trigger on the emp table after delete that marks the isactive status = 0 in the emo History table. 0 0 1 CREATE the following tables - a. Dept triggers - Add Identity Column (1000,1) b. Emp triggers-Add Identity Column (1000,1) c. Emphistory dbo.emp_triggers Columns empid (PK, int, not null) empname (varchar(50), null) deptid (int, null) Keys dbo.emphistory Columns empid (int, null) deptid (int, null) isactive (int, null) Keys Constraints TRIGGERS a. Trigger 1 - Build a trigger on the emp table after insert that adds a record into the emo. History table and marks IsActive column to 1 b. Trigger 2 - Build a tirnner on the emp table after an update of the empname or deptid column - It updates the subsequent empname and/or deptid in the emo history table. c. Build a trigger on the emp table after delete that marks the isactive status = 0 in the emo History table.
Expert Answer:
Answer rating: 100% (QA)
To achieve the described database structure and triggers we will create the necessary tables Dept Emp and Emphistory with the specified column definit... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
Consider CAPM. Define the market risk in mathematical terms. Then, define a coefficient of stock's correlation with the market. Are the two the same or different?
-
Choose one activity from the LP1 (green) section of the NAUXChange game board and post your response in this discussion.For example, LP1 includes three (3) activities, which are located in spaces 1,...
-
After watching the videos about budgets, what are your key takeaways? Do you think you will take any of this advice and use it? In your experience, what makes budgets difficult? Do you have any other...
-
A compound with molecular formula C 17 H 36 exhibits a 1 H NMR spectrum with only one signal. How many signals would you expect in the 13C NMR spectrum of this compound?
-
Assume that on July 1, 2018, Big Corp. loaned Little Corp. $12,000 for a period of one year at 6 percent interest. What amount of interest revenue will Big report for 2018? What amount of cash will...
-
Implement the transfer function below using the fast convolution structure of Figure 8.27 with the subfilters of length one: \[H(z)=1+z^{-1}+2 z^{-2}+4 z^{-3} .\] x(n) 12 C(z) 100 Co(2) + C(2) 10 121...
-
Susan Jones made the following investments on January 1, 2004: 1. \($2,000\) at 10 percent for 5 years 2. \($12,000\) at 4 percent for 8 years 3. \($9,000\) at 14 percent for 15 years Assume the...
-
Jefferson County operates a centralized motor pool to service county vehicles. At the end of 2011, the Motor Pool Internal Service Fund had the following account balances: The following events took...
-
how to add the question below?. As at 30 June 2019, the unadjusted trial balance of Green Ltd was noted as follows: Green Ltd TRIAL BALANCE AS AT 30 JUNE 2019 Accounts Debit ($) Credit ($) Cash at...
-
A model was developed to predict the length of a sentence (the response variable) for a male convicted of assault using the following predictor variables: age (in years), number of prior felony...
-
How can these risks be controlled? The Gazebo Market at GrandValleyStateUniversity is the smallest of three Dining Services locations in the atrium of its downtown campus in Grand Rapids, Michigan,...
-
A tool used by the researcher to collect data is referred to as the __ a. Survey b. Instrument c. Research mechanism d. Apparatus
-
Dr. Anderson, a new pediatrician at Community Physician's Clinic, wants to study his new patient's growth charts to determine if they are within the guidelines for weight for age. His last ten...
-
Last month, 10 patients between the ages of 11 and 13 were seen in their pediatrician's clinic. Their heights were recorded as 51, 57, 60, 51, 52, 49, 53, 57, 61 , and 50 inches. Determine the mean,...
-
The probability that a randomly selected value of a continuous random variable lies between a and b is given by the area under the probability density curve between a and b. In Exercises 1518,...
-
A coding supervisor recorded the following salaries for the seven coding professionals in her HIM department section as $15.25, $16.72, $17.23, $15.34, $ 15.93, $17.05, and $16.21. Find the first and...
-
Mencione problemas ticos que existen en los sistemas de IT y cree una discusin sobre ese tema
-
Below is a sample of the data in the file NFLAttendance which contains the 32 teams in the National Football League, their conference affiliation, their division, and their average home attendance....
-
In 2012, Margaret and John Murphy are married taxpayers who file a joint tax return with AGl of $25,000. During the year they incurred the following expenses: Hospitalization insurance...
-
Larry Gaines, age 42, sells his personal residence on November 12, 2012, for $144,000. He lived in the house for 7 years. The expenses of the sale are $10,500, and he has made capital improvements of...
-
Indicate whether each of the items listed below would be included (I) in or excluded (E) from gross income for the 2012 tax year. ________a. Welfare payments ________b. Commissions ________c. Hobby...
-
Describe the factors that affect personal financial decisions.
-
List eight strategies for achieving financial goals.
-
Explain opportunity costs and how they might affect your personal financial decisions.
Study smarter with the SolutionInn App