View Single Post
Unread 12-02-2011, 01:50 PM   #2
Divemaster
somebody shut me the fark up.
 
Divemaster's Avatar
 
Join Date: 09-23-07
Location: North Side of Chicago Illinois
Downloads: 0
Uploads: 0
Default

I think I would like to address each of your points

Quote:
Originally Posted by dmprantz View Post
I'm listening to the November special board meeting, and I have some thoughts, comments, and solicitation for input in regards to the team name and number.
I too managed to listen to the meeting and my first thought was “Why wasn’t this determined in a committee and THEN brought to the BOD?” I really don’t think that a BOD meeting is the place to be designing a data base. I like you have been in the IT industry for well over 30+ years and have never seen a system designed in such a manner work. NEVER!

Quote:
Originally Posted by dmprantz View Post
One of the issues I have is to look at this from a technical point of view: In a database, each entity should have an ID. This ID uniquely identifies the entity throughout the entity's domain. From a logical, technical point of view, I see no reason why teams should not have their own entity with their own number. If some one came to me and asked me to design a system for teams competing against each other I would think it an ER failure for me to not create an entity for the team. I know I'm not the only database and software guy who competes, nor the only on this forum, so does any one disagree with that? If teams aren't their own entities, then you are really only tracking individuals. Once you have entities (with IDs) for teams, you can setup the appropriate relations and track things accordingly.
I couldn’t agree more.

Quote:
Originally Posted by dmprantz View Post
Next, I'd like to take a step back and examine how this would work from a rules point of view. How will The KCBS accommodate teams with multiple people, some or all of whom may not be at every event. For this, I look at college and professional sports teams. Does any single person make a team? Are there not usually at least two quarterbacks? Isn't there an assistant coach who can take over if the head coach is sick? These are teams, and there is no "I" in that word. Non-team sports like golf don't have teams. One potential exception I can think of is doubles tennis, but that really is a special case because it is one time team made up of two individuals. What I would suggest from both a database and league standpoint is that a team has a roster of its members. The roster can be limited at some arbitrary number. It's 53 in the NFL, so say somewhere between 1 and 53. One prevents it from being a team, and 2, or maybe even 3 limits some teams. For a team to be officially present, at least one person from that roster (or maybe 51%?) need to be there. Implement something similar to a trade system and a trade deadline to allow new members and to allow people to change teams. That way you are keeping track of who is on a team and who isn't and are able to determine if a team is present. Print a list of all team memberships before the competition.
I’ll be honest, I don’t care if anyone from the team is present when the “Team” competing. What difference would it make? We are talking about the “Team of the Year”. To use your NFL analogy, if Green Bay suddenly decided to replace every player and coach in the middle of the season and still won the Super Bowl, who won? I am of the belief that it would be the Green Bay Packers.

Quote:
Originally Posted by dmprantz View Post
Another question or issue I see with this, is to ask are members allowed to be on multiple teams simultaneously? Obviously that's not possible in most sports leagues, but I can think of a few examples in competitive BBQ where it happens. I don't want to get into the pros and cons of it right now, but the KCBS should define a rule around that and stick to it. The database can (and should) be designed to support a many-to-many association right there in case rules change.
Obviously, I don’t have a problem with people being members of multiple teams. The only problem would be if they were cooking for/with two or more teams at the same competition.

Quote:
Originally Posted by dmprantz View Post
The final thought from me on this is to bring up that this doesn't affect every team. In general KCBS doesn't require membership to compete, and an individual's team name or affiliation can change with every competition. There are a few exceptions: TOY, Sam's Club Tournament, AR, and I think The Jack are all currently based on head cook, though some of them also have rules about who can be on your team in future events. While obviously the KCBS shouldn't impose its rules on other organizations, it could try to communicate any new team dynamics to them. KCBS should also figure out how the inconsistent team names fit into the paradigm. They can ignore them if they choose, but they should try to think about any consequences of that ignorance and be prepared to handle it. If TOY and Sam's Club are the only conflicts, they may be okay as they seem to have those covered.
Unfortunately, communication is not the KCBS’s strong suit.
__________________
Jeff
CBJ# 23376
Stockcar BBQ
Race Fast, Cook Slow, and Enjoy Life!
If it don't come off a smoker, it's just a side dish!

Lang 60 Patio (The Mistress), Black Stainless Lang 36 (Little Princess), Large BGE (Ramona), Big Green UDS (Cottage Cooker), Brinkman SnP Pro (Little Bubba-Retired), 8 Burner Gasser, 3 - 22.5" & 1 - 18" (circa 1975) Weber Grills, & a Weber Smoky Joe.
Divemaster is offline   Reply With Quote