Re: School grade vs age
Posted by:
Bob Field
Date: March 22, 2006 05:39PM
So basically what I am seeing is AssignmentSubject is holding the whole show together, with information pulled in from the other tables by a series of cascading left joins. I guess it probably makes sense that Delivery be a separate table. What are you using for a primary key in AssignmentSubject (that table needs a more meaningful name, too, since it's joining more than two tables, something more conceptual)?
This is a complex design here, and it's probably going to take some skull sweat and and a few iterations to get it the way you want it. You'll probably be dropping and reloading these tables with a certain frequency as you tweak and tune, I know I would be.
Subject
Written By
Posted
Re: School grade vs age
March 22, 2006 05:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.