var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL Query help.
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.
(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.
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?
SELECT ARTIST.name 'Mark Toby'
WHERE ARTIST.name = NewCust.ARTIST.name
INSERT INTO CUSTOMER_ARTIST_INT
VALUES (NewCust.CUSTOMER.Customer.ID, ARTIST.ArtistID)