Not sure about questions b and c. This is a homework question. I have been trying to figure it out. Just need a little more help.

Question Details:
ARTIST.Name
Artist.Nationality
Transaction.purchaseDate
Transaction.SalesPrice...
Customer.Name
Customer.Phone.AreaCose
Customer.Phone.LocalNumber
Customer.Name...

(The Ellipses(...) refer to the structures that can repeat.


Code SQL statements to update this view as follows:
a. Change the spelling of Mark Tobey (ArtistName) to Mark Toby.
I have


UPDATE ARTIST

SET name = 'Mark Toby'

WHERE name = 'Mark Tobey';



b. Create a new transaction for Mark Toby. Assume you have the necessary transaction, work, and customer data in a structure named NewTrans.


c. Add new interested customers for Mark Toby. Assume they are stored in a collection that you can access with the command For Each NewCust.Name?
I have:


SELECT ARTIST.name 'Mark Toby'

FROM ARTIST

WHERE ARTIST.name = NewCust.ARTIST.name

INSERT INTO CUSTOMER_ARTIST_INT

(CustomerID, ArtistID)

VALUES (NewCust.CUSTOMER.Customer.ID, ARTIST.ArtistID)

NEXT NewCust.ARTIST.Name


Cheers.