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?
-
A particular vibration will give an absorption peak in the infrared spectrum only if the dipole moment of the molecule changes during the vibration. Which vibration of carbon dioxide, the symmetrical...
-
Enco Tech Corporation is in the business of leasing new sophisticated satellite systems. As a lessor of satellites, Enco Tech purchased a new system on December 31, 2013. The system was delivered the...
-
Oil is cooled by spraying a mist of the hot liquid through cool air at \(T_{\infty}=27^{\circ} \mathrm{C}\). Two droplets, each of diameter \(D=100 \mu \mathrm{m}\) and temperature \(250^{\circ}...
-
On September 30, 2017, the Parker Corporation had a balance of $50,500 in its cash account. Additional information: Actual sales: August........................$180,000...
-
Positioning when it comes to brand and product refers to the way and space a product "takes up" in a consumer's mind as it relates to the market, their life, and competitive products (Kerin &...
-
Below are incomplete financial statements for Benson. Incorporated. Requlred: Calculate the missing amounts. table [ [ BENSON , INCORPORATED ] , [ Income Statement ] , [ Year ended Decem ber 3 1 , 2...
-
3. Metro Mart Co. sells one product. Presented below is information for January 2023 for Metro. Date 1/1 Inventory 100 units at $5 each 1/11 Purchase 150 units at $6 each 1/13 Sales 120 units at...
-
MedPAC, or the Medicare Payment Advisory Council, is an independent agency tasked with advising the United States Congress on topics and issues related to Medicare. More information about MedPAC can...
-
When Procter & Gamble introduced Crest toothpaste, the first fluoride toothpaste, it was intended for use by children and was therefore given a child-appealing bubblegum flavor. Sometime later the...
-
When does letter writing become your job instead of the doctors job? Why must you be in charge of something that could be very important to the doctor and the patient? What skillset do you need to be...
-
When making their suits to sell to the public. Armani Exchange has a choice of different types of cloth to use. All types of cloths have the same performance and are purely based on the amount Armani...
-
When deciding whether to accept or refuse a medical treatment on behalf of an infant, which standard should a parent use? Give an argument that explains and justifies your answer.
-
In a sample of 1000 medicines, the mean and standard deviation of certain contents in the were 14 and 2.5 respectively. Find the following: medicines (i) (ii) (iii) How much medicines content between...
-
Consider model (9.18). What is the effect on the model parameter estimates, their standard errors, and the goodness-of-fit statistics when (a) The times at risk are doubled, but the numbers of deaths...
-
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...
-
Where does the management accounting function fit into an organizations structure?
-
What are the ethical responsibilities of management accountants?
-
Diana Corporation provides the following information for 2017: Calculate (a) Cost of goods manufactured in 2017 and (b) Cost of goods sold in 2017 Beginning work-in-process inventory, 1/1/2017 Total...
Study smarter with the SolutionInn App