Please read Chapter 9 in the Kroenke Book and answer the Project Questions listed at the end of Chapter 9, page 454, questions 9.61 A - D.Answer these questions with the tables shown in Figures 7-13 and 7-14 and the data shown in Figure 7-15. Please submit your answers with a minimum of 300 words in length with good spelling and grammar.

Answer the following questions for the View Ridge Gallery VRG database discussed in Chapter 7 with the tables shown in Figures 7-13and 7-14 and the data shown in Figure 7-15.

Question 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?

Question B

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

Question C

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

Question 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 customers 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?

FIG 7-13

FIG 7-14

FIGURE 7-15

CREATE TABLE ARTIST ( LastName FirstName Nationality DateofBirth DateDeceased CONSTRAINT CONSTRAINT CONSTRAINT NOT NULL IDENTITY (1,1), NOT NULL NOT NULL NULL NULL NULL Numeric(4,0) Numeric(4,0) ArtistPK ArtistAK1 NationalityValues CHEC PRIMARY KEY (ArtistID), UNIQUE (LastName, FirstName) (Nationality IN ('Canadian', "English', 'French', German' , 'Mexic an', 'Russian', 'Spanish United States CONSTRAINT CONSTRAINT BirthValuesCheck ValidBirthYear CHECK(DateOfBirth