Help! Can you? please...

Discussion in 'Software' started by saifou, Apr 19, 2004.

  1. saifou

    saifou Private E-2

    I really need help for the following question:
    ---------------------------------------------------------------

    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.

    Code SQL statements to update this view as follows:


    a) Change the spelling of Mark Tobey to Mark Toby.

    b) Create a new 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.”
     
    Last edited: Apr 19, 2004
  2. Kodo

    Kodo SNATCHSQUATCH

    what do you have so far?
     
  3. saifou

    saifou Private E-2

    help

    Nothing yet. can you help please.
     
  4. Kodo

    Kodo SNATCHSQUATCH

    give it your best go and post what you come up with.. we'll work from there.
     
  5. Connsas

    Connsas Private E-2

    Help

    I need ideas of how to accoplish this task asap...


    a set of evenly spaced data in the range 0 < x < 16 that was generated using the fifth degree polynomial
     
  6. goldfish

    goldfish Lt. Sushi.DC

    I think what Kodo is trying to say is that he can't do your homework for you, and its also easier to help you if you have somthing to go on. Sorry I cant really help you myself... TBH i have absolutley no idea what is trying to be achived... as there is no mention of the language or DB applcation (if there is one! :eek:) or anything else you are using to do this.

    But maybe I'm just stupid
     
  7. Maxwell

    Maxwell Folgers

    This is trivial. Consider the curve y = x^5 with values for x = 0, 4, 8, 12, 16 therefore y is obviously the fifth power of each x term that are equally spaced across the range required.

    With regard to the SQL statement, take a look at the manual under SELECT to choose the data item that you wish to change.
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds