Thread: Database Design
View Single Post
Old 06-29-2009, 07:28 PM   #4 (permalink)
Dr John
The Contributor
 
Join Date: Apr 2005
Location: Kent, UK
Posts: 54
Thanks: 0
Dr John is on a distinguished road
Default

Well, you could use a fixture table as the next main thing to work on...

fixture {date, location, home, away, score_home, score_away}
if that is a bit too cumbersome with the natural triple composite key, add fix_id as well.
__________________
www.kidneydialysis.org.uk
Dr John is offline  
Reply With Quote