August 3, 2012 at 6:25 am
Hey Hi friends,
please Help me on How to design the Sports database for online games or live games????
give me some idea about online sports games.(footbal or cricket ,golf,tennis,basketball..etc).....please suggest me on the games database???
please help me on this
Thanks...
SQL server DBA
August 3, 2012 at 12:16 pm
kranthi.india123 (8/3/2012)
Hey Hi friends,please Help me on How to design the Sports database for online games or live games????
give me some idea about online sports games.(footbal or cricket ,golf,tennis,basketball..etc).....please suggest me on the games database???
please help me on this
Thanks...
Let's try a different approach here. Instead of just asking somebody to make it for you why don't you design something. Then you can post what you have done and we can offer suggestions on how to improve it.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 3, 2012 at 12:19 pm
And start at a logical level first. Determine what things you need to track or store information about, then what kind of information do you need to store for each item you have identified.
And that is just the start.
August 3, 2012 at 12:43 pm
kranthi.india123 (8/3/2012)
Hey Hi friends,please Help me on How to design the Sports database for online games or live games????
give me some idea about online sports games.(footbal or cricket ,golf,tennis,basketball..etc).....please suggest me on the games database???
please help me on this
Thanks...
hmmm...lets take a view on the different scoring methods...for example:
football (UK)...goals scored
cricket....runs, wickets, innings
golf...shots taken, holes won. +/- par...handicaps as well
tennis...points/games/sets
.so you want one databsae to rule them all???
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2012 at 1:34 pm
This reminded me of an image Lowell posted when somebody was trying to make a single procedure that could do everything...
[see attachment]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 3, 2012 at 1:58 pm
Sean Lange (8/3/2012)
This reminded me of an image Lowell posted when somebody was trying to make a single procedure that could do everything...[see attachment]
"One dB to rule them all,
One Proc to find them,
One View to bring them all and in the darkness bind them"
...with apologies to J. R. R. Tolkien
...and apologies to the OP for this irreverent post
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2012 at 2:03 pm
J Livingston SQL (8/3/2012)
kranthi.india123 (8/3/2012)
Hey Hi friends,please Help me on How to design the Sports database for online games or live games????
give me some idea about online sports games.(footbal or cricket ,golf,tennis,basketball..etc).....please suggest me on the games database???
please help me on this
Thanks...
hmmm...lets take a view on the different scoring methods...for example:
football (UK)...goals scored
cricket....runs, wickets, innings
golf...shots taken, holes won. +/- par...handicaps as well
tennis...points/games/sets
.so you want one databsae to rule them all???
And let's not forget that simply goals scored isn't even close to what you need to track. lineups, corners, fouls, shots on goal, saves, penalties, cautions, ejections, substitutions, injuries, possession %, stats out the wazoo, etc...
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 3, 2012 at 3:03 pm
You could add in playing schedules between teams, what fields/courts/etc, referee (officails) assigned. What else can we think of before we total scare off the OP.
To the OP, really, we aren't trying to scare you. We just need you to focus on what it is you want to design and build.
April 23, 2024 at 10:30 pm
This was removed by the editor as SPAM
April 23, 2024 at 10:34 pm
This was removed by the editor as SPAM
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply