Search found 5 matches

by russ_
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...
by russ_
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...
by russ_
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...
by russ_
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 ...
by russ_
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 ...