How will you declare the boundaries of the transaction

Assignment Help Basic Computer Science

Reference no: EM131224382

Answer the following questions for the View Ridge Gallery database discussed in Chapter 7 with the tables shown in Figure 7-15.

A. Suppose that you are developing a stored procedure to record an artist who has never been in the gallery before, a work for that artist, and a row in the TRANS table to record the date acquired and the acquisition price. How will you declare the boundaries of the transaction? What transaction isolation level will you use?

B. Suppose that you are writing a stored procedure to change values in the CUSTOMER table. What transaction isolation level will you use?

C. Suppose that you are writing a stored procedure to record a customer's purchase. Assume that the customer's data are new. How will you declare the boundaries of the transaction? What isolation level will you use?

D. Suppose that you are writing a stored procedure to check the validity of the intersection table. Specifically, for each customer, your procedure should read the customer's transaction and determine the artist of that work. Given the artist, your procedure should then check to ensure that an interest has been declared for that artist in the intersection table. If there is no such intersection row, your procedure should create one. How will you set the boundaries of your transaction? What isolation level will you use? What cursor types (if any) will you use?

Reference no: EM131224382

Questions Cloud

Elements of genomics into nursing practice : How can the BSN nurse incorporate elements of genomics into nursing practice - what are your thoughts about ways that genomics could be included as part of the nursing assessment?

Arbitrary values that are based on production expectations : Defend the statement that the operator of the process should be the owner and data plotter of the control chart, as opposed to a person form quality asurance or engineering, for example. Comment on the significance of this statement: "Control chart p..

Improve communication in the work place : Please come up with a plan of action that you think that Mrs. Jonas should take in order to improve communication with her team. In other words, how to improve communication in the work place?

Rwwrite the given paper : Rwwrite the given paper. - The topic of the paper is: "Fundamental Principles Of Management For A Sucessful Company".

How will you declare the boundaries of the transaction : Suppose that you are writing a stored procedure to record a customer's purchase. Assume that the customer's data are new. How will you declare the boundaries of the transaction? What isolation level will you use?

Create an estate planning strategy : TAX 665 Final Project Assignment-Create an estate planning strategy, showing versatility of thought, that will minimize estate and gift tax liability over the course of the client's life span, potentially another 30 years. Assure that as little fu..

Define limited jurisdiction and general jurisdiction : Define limited jurisdiction and general jurisdiction and provide an example for each. Flatbranch files a lawsuit against Joe for breach of contract in a Missouri state court of general jurisdiction. Explain the way a lawsuit would proceed through the..

Explain why organizational structures differ : In a PowerPoint presentation (approximately 10 slides), explain why organizational structures differ. Define and provide an example of the four reasons why structures differ.

What is the bsn nurses role in palliative care : What is the BSN nurse's role in palliative care and how does that role differ from the role of the AND or diploma-prepared nurse and what ethical concerns might a nurse face when a patient chooses palliative care over treatment?

User Account

All Pages