| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> representing Table of Contents in a DB
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 - 12:24:12 CDT
![]() |
![]() |