Tom Brown (12/8/2011)
I think that volcanic air is getting to you Tom, This question is way over most of our heads - a really hard question. No amount of googling seemed able to turn up any clues. And... well, once you see the answer its no easier to work it out.I got the not null part. And its probably not the primary key, (otherwise why call it an elementary key). The middle one long complex answer I chose this because it was long and complex - don't pretent to understand it even now, and random choice for the other one.
I probably overestimated how much relational theory people would be familiar with, and put the question into a form that was harder than it could have been if presented in a different form. Multiple choice questions where you have to select several answers are inherently more difficult than multiple choice questions where you select only one answer (choosing 3 out of five means choosing one combination out of 10 possible combinations, choosing 1 out of five is easier than choosing 1 out of 10).
I'm surprised that googling came up with nothing, though - it finds the Halpin,Morgan and Morgan book, Joe Celko's book, the Wikipedia normalisation article, Zaniolo's paper, and Scot Becker's rather silly (he parades his ignorance of why EKNF is important) paper on normalisation (Google gives a broken link to that one, but it's there in the cache - at least it is today) all on the first page of results when I try it - but maybe Google knows I'm interested in normalisation.
Tom