April 17th, 2004, 02:00 PM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Help! Can you? please...
I am new to SQL please help me with these questions below:
---------------------------------------------------------------
ARTIST.Name
ARTIST.Nationality
TRANSACTION.PurchaseDate
TRANSACTION.SalesPrice…
CUSTOMER.Name
CUSTOMER.Phone.AreaCode
CUSTOMER,Phone.LocalNumber
CUSTOMER.Name…
The ellipses (…) refer to structures that can repeat.
a) Code SQL statements for reading the “Mark Tobey” instance of this view.
b) Code SQL statements to create a new instance of this view. Assume that you
have data for ARTIST, one TRANSACTION, and many CUSTOMER.Name(s)
for the second instance of CUSTOMER.Name. Assume this data is located in a
structure named NewArtist. Use syntax similar to that in the text.
Code SQL statements to update this view as follows:
c) Change the spelling of Mark Tobey to Mark Toby.
d) Create a new transaction, work, and customer data in a structure named NewTrans.
e) 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.”
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
