Home -> Usenet -> comp.databases.theory -> Re: foreign key to the *same* table?

Re: foreign key to the *same* table?

From: --CELKO-- <joe.celko_at_northface.edu>
Date: 9 Sep 2003 18:04:00 -0700
Message-ID: <a264e7ea.0309091704.55488aa2_at_posting.google.com> 






Look up the nested sets model for hierarchies and use that to model
the courses instead of a self-reference.  Then create a table to bring
the professor, the course, etc. into a course catalog table.
Received on Wed Sep 10 2003 - 03:04:00 CEST












Original text of this message