Thread: Database Design
View Single Post
Old 06-25-2009, 03:37 PM   #2 (permalink)
Wildhoney
La Vida es Sueño
Advanced Programmer Top Contributor 
 
Wildhoney's Avatar
 
Join Date: Sep 2007
Location: Oldham
Posts: 2,280
Thanks: 90
Wildhoney is on a distinguished road
Default

To start you off, all the football teams should be centralised in one table. So Everton, naturally being first, Chelsea, Arsenal, all listed in one table. And then when you add other tables, you will simply set the appropriate team_id corresponding to the team table.
__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.
Send a message via AIM to Wildhoney Send a message via MSN to Wildhoney Send a message via Yahoo to Wildhoney
Wildhoney is offline  
Reply With Quote