Jason Goldsmith Posted May 5, 2006 Share Posted May 5, 2006 I'm creating a dababase where teachers submit test questions. Often, they submit just one question and thus are assigned a submission number. They may, however, submit one main question with a series of subquestions, in which case they are assigned a common submission number plus a sequential series number. For example: 1 2 3a 3b 3c 4 Would this call for: a. A single table b. A single table with a self-join (key = submission number) c. Two tables Thanks! Link to comment Share on other sites More sharing options...
Genx Posted May 5, 2006 Share Posted May 5, 2006 Well, assuming you want to report on all this data, all your test questions should be in one table. Hence, option . Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6559 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now