WayneS (5/11/2011)
Tom.Thomson (5/11/2011)
Nice question.One niggle: asking people to assume that a schema is valid when a table doesn't have a primary key may encourage a very bad habit if some of your audience don't know any better. Maybe "pretend" would have been a better choice of word than "assume".
Tom, I think it was referring to the schema "Playground", which the table was created in.
I think he was implying that the table's schema (not the Playground schema -- confused yet?) is not appropriate since there is no primary key or unique identifier. Someone may read the question and assume the table's structure is good practice when it is not.