Post reply

Elementary Key Attributes

  • October 4, 2011 at 9:25 pm

    #248888

    Comments posted to this topic are about the item Elementary Key Attributes

    Tom

  • October 5, 2011 at 1:12 am

    #1390517

    96% of answers incorrect - you'll be popular! No cheap points here.

    Steve Hall
    Linkedin
    Blog Site

  • October 5, 2011 at 1:19 am

    #1390519

    I get it wrong, but I like this kind of questions.

    Thanks.

  • October 5, 2011 at 2:39 am

    #1390536

    Not quite sure of the relevance of this question.

    (Or is that just sour grapes - 2correct answers, 118 incorrect answers so far!)

  • October 5, 2011 at 2:51 am

    #1390538

    Nice one , thank you,

    Iulian

  • October 5, 2011 at 3:09 am

    #1390544

    Ah, I was researching elemenTARTY keys, probably why I got it wrong 😉

    Life: it twists and turns like a twisty turny thing

  • October 5, 2011 at 6:05 am

    #1390613

    I said C only: Some other attribute B is fixed by a set including A but by no subset of that set - which is clearly true.

    Couldn't get the other two parts though. I guess I join the 98% of answerers that aren't database professionals.

    Thanks for the question.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • October 5, 2011 at 6:07 am

    #1390614

    L' Eomot Inversé (10/4/2011)

    Comments posted to this topic are about the item <A HREF="/questions/Normalisation/74786/">Elementary Key Attributes</A>

    I find it quite frightening that so few people know enough about normalisation to get this one right.

    Tom

  • October 5, 2011 at 6:41 am

    #1390635

    My only comment is that there is no identifier (per other QOTD's) of how many answers to answer... I got 2 out of 3 but still marked as wrong.

  • October 5, 2011 at 7:09 am

    #1390647

    I got two out of three, which is okay with me.

    Of all of my skills and talents, the ability to recite every obscure factoid about relational databases (or any other software system or process) is not at the very top of the list. That place is reserved for critical thinking, analysis and application of experience and creativity to solve problems effectively.

    The probability of survival is inversely proportional to the angle of arrival.

  • October 5, 2011 at 7:29 am

    #1390665

    L' Eomot Inversé (10/5/2011)

    I find it quite frightening that so few people know enough about normalisation to get this one right.

    I don't. This question is couched in abstract language. "Elementary key", "prime attribute"and "fixed" aren't part of the everyday SQL Server vernacular. Don't get me wrong - I'm not complaining, since I found it an educational experience. I just think more people would have got it right if the terminology had been a bit more familiar.

    John

  • October 5, 2011 at 7:40 am

    #1390677

    Updated the question to say "select 3". My apologies for missing that.

  • October 5, 2011 at 8:02 am

    #1390695

    Good question, got it right but only after flip flopping back and forth on a couple of the choices because the verbage was so close.

    Really god tthe juices going.

    thanks

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • October 5, 2011 at 9:41 am

    #1390773

    Who can explain why the fifth option, "A on its own is a candidate key of T" is NOT true? What am I missing here?

    Rob Schripsema
    Propack, Inc.

  • October 5, 2011 at 9:43 am

    #1390778

    John Mitchell-245523 (10/5/2011)

    L' Eomot Inversé (10/5/2011)

    I find it quite frightening that so few people know enough about normalisation to get this one right.

    I don't. This question is couched in abstract language. "Elementary key", "prime attribute"and "fixed" aren't part of the everyday SQL Server vernacular. Don't get me wrong - I'm not complaining, since I found it an educational experience. I just think more people would have got it right if the terminology had been a bit more familiar.

    John

    I agree John. The vernacular was outside the scope of normal conversation far enough that I struggled to understand what the answers meant.

    Great question Tom!!! Certainly an educational question.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Viewing 15 posts - 1 through 15 (of 54 total)

You must be logged in to reply to this topic. Login to reply