Posted by bbcrock on 03/06/07 18:39
This is the time when I mention that I purchased Joe Celko's "SQL For
Smarties" several years ago and felt it was a great companion for
learning standard SQL theory. I recommend the book for everyone who
wants to take it to the next level.
I suspect that this entire database I inherited from a group project
of multiple contractors will have to be overhauled to achieve true
third normal form, but cannot be for financial and scope reasons.
I certainly was able to identify 3 mutual columns between the trucks
and trains and can suggest building a join table with that data and a
vehicle_ID that's used as the join with the transportation_item.
thanks!
Navigation:
[Reply to this message]
|