A decade ago today...

All advertisments are hidden for logged in members, why not log in/register?

Foxy said:
You're a bit late for that :) unless you've got any enhancement idea's I haven't already thought of :D
Click to expand...

How do we know what you ahve thought of if you wont let us have a play??? :D
 



SellyOakBlade said:
How smart is this going to be?

Wil it separate MK Dons and Wimbledon as two teams or 1??
If Darren types "Tottenham" in one result and "Totenham" in another, will it see them as the same team?I think you need some drop down lists here...

Might I suggest as a starting point the following data attributes (not complete):

Competition
Date
Venue
Home Team
Away Team
Score (possibly 2 attributes for Home and away, possibly 2 occs if we want to record FT and AET scores, possibly 3 occs if we want HT, FT and AET scores)
Scorer name
Scorer time
Scorer penalty indicator
Extra Time Indicator
Penalty Win Indicator (i.e. Home or Away team)

which will need normalising, and a shed load of other details (such as date ranges for specific competitions, tier details for competitions, date ranges for mangerial stints etc etc)
Click to expand...


My entities would have been

Match
Players
Teams
Scorers (PlayerId, Time, HomeAwayInd(So you can keep track of own goals))

many to many relationships between:

Match >-< Teams
Teams>-< Players


One to many between

Match -< Scorers


One to One between Scorers and Players
 
I certainly did not start drawing this...

TI3z81G.jpg
 
Highbury_Blade said:
My entities would have been

Match
Players
Teams
Scorers (PlayerId, Time, HomeAwayInd(So you can keep track of own goals))

many to many relationships between:

Match >-< Teams
Teams>-< Players
Click to expand...

I'm not sure I agree with this one. Whilst a Player can (will) have many teams through his career, and teams have many players, in any given match a player has only 1 team, thus if you define the relationship between Players and Teams via Match you can resolve the issue.

Of course alternatively you can stick in a Club Career entity, which defines when individual players joined and left individual teams. Which would allow you to establish what percentage of games they played for each club...

So:

Team---<Club Career>----Player
 
Highbury_Blade said:
How are you keeping track of which player scored each goal?
Click to expand...

I hadn`t got that far! But would agree a Scorer entity as a 0-∞ with Match and a 1-1 with player.

Possibly need a Line-up entity (This would be better named Team, and rename what we had as team, Club) to resolve the ∞-∞ relationship between Player and Match
 
hanks guys, the last few posts took me back to my Uni days of one-to-ones, one-to-manys

I may have also created an Access database in around 2002-ish of every game I'd been to, with scorers listed and querys set up of how many times I'd seen each opposition team and visited each ground :oops: As I recall, Norwich City and Crystal Palace were near the top, by dint of all 3 teams being equally bang average as each other during that period.
 
SellyOakBlade said:
I'm not sure I agree with this one. Whilst a Player can (will) have many teams through his career, and teams have many players, in any given match a player has only 1 team, thus if you define the relationship between Players and Teams via Match you can resolve the issue.

Of course alternatively you can stick in a Club Career entity, which defines when individual players joined and left individual teams. Which would allow you to establish what percentage of games they played for each club...

So:

Team---<Club Career>----Player
Click to expand...



Erm, that's exactly the same as my design (I just didn't tell you what extra properties would be in my Linking table :))Your ClubCareer entity is the same as a TeamsPlayers table
 
Highbury_Blade said:
Erm, that's exactly the same as my design (I just didn't tell you what extra properties would be in my Linking table :))Your ClubCareer entity is the same as a TeamsPlayers table
Click to expand...

Great minds think alike then!

I can`t wait to see what sort of a buggers muddle Foxy has come up with... :D
 



Oi.... you lot.

While Foxy 's back-end attentions (for want of a better term) are your main requirement of him.... I need him to build a path and patio this weekend.

I'm already getting "in a minute"s when I try and get him to leave sixth (?) generation S24SU alone and come to bed. He can at least be of some use to his wife and get the gardening done.
 
I quite enjoyed database design at Uni, not really touched on it since mind!

Linz - path and patio vs coding and database work......tough call! ;)
 
Linz said:
Oi.... you lot.

While Foxy 's back-end attentions (for want of a better term) are your main requirement of him.... I need him to build a path and patio this weekend.

I'm already getting "in a minute"s when I try and get him to leave sixth (?) generation S24SU alone and come to bed. He can at least be of some use to his wife and get the gardening done.
Click to expand...

Gardening?

Is that what you youngsters call it these days :-)
 
Linz said:
Oi.... you lot.

While Foxy 's back-end attentions (for want of a better term) are your main requirement of him.... I need him to build a path and patio this weekend.

I'm already getting "in a minute"s when I try and get him to leave sixth (?) generation S24SU alone and come to bed. He can at least be of some use to his wife and get the gardening done.
Click to expand...

There are just too many innuendos in that post that my brain cannot work out which one to pick out and take the mick out of...
 
ERDs are for girls.
 
SellyOakBlade said:
I can`t wait to see what sort of a buggers muddle Foxy has come up with... :D
Click to expand...


To give you an idea, the ratings system (which it'll be added to, obviously without ratings for anything before this season) *WAS* made up of the following tables (this isn't the currently running system):

Team
Team Season Data
Season
Player
Player Season Data
Game
Matchday Squad
Rating
Comments
 
Foxy said:
To give you an idea, the ratings system (which it'll be added to, obviously without ratings for anything before this season) *WAS* made up of the following tables (this isn't the currently running system):

Team
Team Season Data
Season
Player
Player Season Data
Game
Matchday Squad
Rating
Comments
Click to expand...

Yeah, I'm going to need to see a diagram before I sign this off...
 
SellyOakBlade said:
Yeah, I'm going to need to see a diagram before I sign this off...
Click to expand...

You've just reminded me....

A bloke from IBM phoned me today wanting to speak to someone I work with. I told him that this person wasn't in the office. He responded with "but I just want to reach out to him".

I need a new job.
 



You must log in or register to reply here.

Similar threads

C
Statistics Intermediate Team late 70s Early 80s
Replies
2
Views
596
chimpchoker
C
Bartleby
Charlton v Blades Pre-match press conference
Replies
1
Views
416
mattbianco1
mattbianco1
Bartleby
Southampton (A) Presser
Replies
3
Views
414
Nesh Blade
Nesh Blade
B
Would a salary cap make the Prem fairer?
2
Replies
39
Views
3K
loyalblade95
loyalblade95
Coolblade
A few observations from the stats (Brum)
Replies
10
Views
1K
GrunkyPeep
G

All advertisments are hidden for logged in members, why not log in/register?

All advertisments are hidden for logged in members, why not log in/register?

Back
Top Bottom