representing Table of Contents in a DB

From: oliver abroad <>
Date: 22 Sep 2002 10:24:12 -0700
Message-ID: <>

I'm writing a db that holds examination questions. Each question has a reference to a place in the coursebook. The coursebook is divided into chapters, sections sub sections etc so a reference looks like chap 1 section 2.a.3.c for example (5levels of specialisation in this case) Each level has a title. eg. Chap=Radar then subsection=Parabolic sub-subsection =vertical beam.

ok that's clear I hope.
How can I store the table of contents for this book in such a way that I can use in the db and reference questions. I mean one approach is to have one table with an entry for every single reference possible. The fields would then be the chapter, sub section, sub sub section etc for this ref. But this means a lot of repeated data.

I can't think of a better way to represent it and I'm guessing there is a more elegant solution.

So please have a think and let me know :o) thank you very much Oliver Received on Sun Sep 22 2002 - 19:24:12 CEST

Original text of this message