Search found 5 matches
- Sat Jun 07, 2008 8:03 am
- Forum: Databases
- Topic: Fixture>Team Question
- Replies: 7
- Views: 612
Re: Fixture>Team Question
Basically what I have done dml :D The only difference is I actually didn't plan to hold any player data in the person_role_team_fixture, I planned to hold that information in player_fixture_stats ONLY i.e. p_r_f_t only held data on non playing staff. Thus my FK was from player_fixture_stats was to p...
- Fri Jun 06, 2008 2:22 am
- Forum: Databases
- Topic: Fixture>Team Question
- Replies: 7
- Views: 612
Re: Fixture>Team Question
Some real good stuff there DML, thanks for that. One issue outstanding in my mind is this. I have used as I stated a generic person entity. I have then setup a role entity and obviously via that I can define the role a person takes. Clearly, a person takes a role for a team between x dates, thus I h...
- Thu Jun 05, 2008 1:36 am
- Forum: Databases
- Topic: Fixture>Team Question
- Replies: 7
- Views: 612
Re: Fixture>Team Question
Thanks for the reply DML. I was wondering, if I just used hometeam and awayteam in the fixture table, how do I show that on the ERD, as both create foreign key constraints to team? A further point is how I've handled individuals in my design. Before I had players, refs, managers, etc as seperate tab...
- Tue Jun 03, 2008 9:54 am
- Forum: Databases
- Topic: Fixture>Team Question
- Replies: 7
- Views: 612
Fixture>Team Question
Guys, I'm designing a database to deal with sporting fixtures, specifically Soccer. Obviously a fixture has two teams, but a team takes part in many fixtures. I'm unsure how to deal with this. Do I require 3 tables, fixture, team and fixture_team (fixture id, hometeam, awayteam)? Or, is it possible ...
- Wed May 28, 2008 6:01 am
- Forum: General Discussion
- Topic: Specific Book Recommendations
- Replies: 4
- Views: 504
Specific Book Recommendations
Hi Guys, Great site. I've had a bit of experience with PHP. However, mostly this has been basic stuff in procedural format, I call it dirty code :). I'm looking for personal recommendations for a PHP 5 book that covers Objects and the object design process for a newbie. One which has a good balance ...