How will you declare the boundaries of the transaction

Assignment Help Basic Computer Science

Reference no: EM131221295

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

Questions Cloud

Which terrorists use the strategic method and why : Why is this a terrorist strategy? Which terrorists use this strategic method? Why? When is this strategic method effective? Why? What are the flaws of this strategy? Why?

Efficient revenue management : What would efficient revenue management imply for the pricing of the Cowboys Stadium parking lot on typical game days? How about for the Super Bowl? How about for the many smaller events that fill less than half the lot?

Review an article that discusses a case of media ethics : Apply your knowledge of media ethics in analyzing a contemporary media ethics case.- Select and review an article that discusses a case of media ethics.

Measure of our economic well-being : GDP as a Measure of Well-being- Mayer describes the importance of GDP as a measure of our economic well-being. But they also note that this measure omits some things that are important in describing how well-off we are.

How will you declare the boundaries of the transaction : Suppose that you are writing a stored procedure to change values in the CUSTOMER table. What transaction isolation level will you use?

Summarize the procedures required to achieve star status : Provide your opinion as to which OSHA voluntary cooperative program would be the most beneficial to a small business. Summarize the procedures required to achieve Star status under OSHA's Voluntary Protection Program (VPP).

Miller to experience economies of scale : Describe 2 ways in which you would expect a company such as Miller to experience economies of scale that Corpus Christi Cheer Beer does not.

What roles have first ladies served in the government : What roles have first ladies served in the government? In your opinion, what is the appropriate level of power and monetary resources that should be granted to the presidential spouse?

Write an sql statement to create a table named picture : Also assume that Name and Date Taken are required. Use Name as the primary key. Set the default value of Description to ‘(None)'.

User Account

All Pages