Question: A transaction needs to be created for the activities this day. Create one transaction that will insert/update/delete the following information: Add the new book 8306

A transaction needs to be created for the activities this day. Create one transaction that will insert/update/delete the following information:

Add the new book 8306 written by author 26 to the wrote table. Sequence is 1.

Update the name of publisher code JT to J.P. Tarcher

Add book code 8306 to inventory. This book will be at branch 3 with 2 copies.

Display the contents of the transaction you typed in. Insert your snip here.

Display the contents of the new row in the wrote table. Insert your snip here.

Display the contents of the new row in the inventory table. Insert your snip here.

Display the contents of the updated row in the publisher table. Insert your snip here.

Its a sql question and its has to be done with stored procedure in sql.

I don't know how to attach a file.

It has to be done in sql language and has to be done in sql with transcation command.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

I would like assistance to see if I filled out the attached Form 1040 Schedule C correctly. I am attaching Schedule C, Schedule C Instructions, and the instructions with the information to work the...

Q:

Olaf: Julio: You: Julio: You: You: Olaf: You: Julio: You: In addition, we can add value through lower prices. As a standard practice, we should discount all books 10% off the publishers' suggested...

Q:

The Internet has stirred your entrepreneurial spirits. Over numerous cups of Starbucks coffee, you and a couple of friendsJulio and Olafhave concluded that there is a tremendous potential business...

Q:

Pleased do it in C + + create a BookList Class: Your program must keep track of the following information about each book in the system: ISBN number: A number that uniquely identifies a book. Hint:...

Q:

Pleased do it in C + + create a BookList Class: Your program must keep track of the following information about each book in the system: ISBN number: A number that uniquely identifies a book. Hint:...

Q:

Pleased do it in C + + create a BookList Class: Your program must keep track of the following information about each book in the system: ISBN number: A number that uniquely identifies a book. Hint:...

Q:

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

Q:

Flow control mechanisms in networks can be loosely categorised as open loop, and closed loop. (i) Describe the closed loop feedback control scheme employed by the Transmission Control Protocol (TCP)...

Q:

Providing Quality School-Based Learning and Support Services 239 Chapter 6 Language and literacy support Your core task The core task of almost all TAs is to support students language and literacy...

Q:

CHAP TER 1 The Role of Human Resources HUMAN RESOURCE MANAGEMENT DAY TO DAY You have just been hired to work in the human resource department of a small company. You heard about the job through a...

Q:

Describe in detail the context approach and the cluster approach to understand cultural differences.

Q:

Levels of insoluble ash (gm/kg) were measured in a sample of small (0.3 gm) aliquots of dried and ground alfalfa.6 Below are three confidence intervals for the mean: One is a 95% confidence interval,...

Q:

F my maximum value is 9 6 is it unusual and why?

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

LAST WORD What is the central economic idea humorously illustrated in Art Buchwalds piece, Squaring the Economic Circle? How does the central idea relate to recessions, on the one hand, and vigorous...

Q:

KEY QUESTION Assuming the level of investment is $16 billion and independent of the level of total output, complete the accompanying table and determine the equilibrium levels of output and...

Q:

KEY QUESTION Assume there are no investment projects in the economy that yield an expected rate of return of 25 percent or more. But suppose there are $10 billion of investment projects yielding...