What transaction isolation level will you use

Assignment Help Basic Computer Science

Reference no: EM131218853

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: EM131218853

Questions Cloud

Implement a multiprocess downloader application : Appreciate the performance and fault-tolerance bene_ts of multi-process applications - implement a multiprocess downloader application.

Find the equilibrium price and quantities for the case : Find the equilibrium price and quantities for the case in which the two taxi companies engage in Cournot (quantity) competition. What profits will Big Ben Taxis and Whitehall Taxis earn.

How this locking algorithm works : Search the Web for "distributed two-phase locking." Find a tutorial on that topic and explain, in general terms, how this locking algorithm works.

Sketch a circuit which will realize given transfer function : Find the transfer function of the whitening filter for this input process. Be sure that the filter is causal. - Sketch a circuit which will realize this transfer function.

What transaction isolation level will you use : 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?

Derive an expression for the cross correlation function : Derive an expression for the cross-correlation function of the two outputs.- Derive an expression for the cross-spectral density of the two outputs

Propose two applications of the knowledge : Propose two applications of the knowledge that you have learned in this course to your current or a future position. Provide a rationale for your response.

Determine the chance in capacity head and power required : The figure below shows portion of a fire protection system in which a pump draws water at 10 deg. C from a reservoir and delivers it to a point B at a flow rate of 6000 lit/min. Determine the height h (m) of the water level in the tank in order to..

Evaluation and analysis of secondary sources with reflection : BLB1114 LEGAL RESEARCH METHODS ASSESSMENT TASKS. Task 1 - Identification, Evaluation and Analysis of Secondary Sources with Reflection, 'The adversarial process inhibits judicial creativity. Courts are not Law Reform Commissions. They do not select ..

User Account

All Pages