April 12, 2012 at 2:58 am
hi all,
how to Designing a database for a tennis league .
how to design and Architecture and tables and everything on tennies game.
pls guide to me....
thanks.
SQL server DBA
April 12, 2012 at 4:53 am
Seriously sounds like homework. If I do everything for you, do I get the grade?
I built the database used by the US Tennis Association back in the 90's (I've heard they still use it, but I can't confirm that). So I've gone through this exercise once. You need to start with examining the structures and needs of the business. You have to collect information about players. You also have to collect information about the tennis games. But games are combined within a set and sets are combined within a match. There are limits on what the score can be. There are limits on the number of games within a match, depending on the level of the match being played. You'll need to record a players wins and losses by game, set and match.
All this information needs to begin to get translated into entities that you can then use to define your tables.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 12, 2012 at 5:06 am
Thanks .but i have little knowledge on tennis game.so how can i built the structure in Tennis game?
and 1.database design
2.and then normalize the table
and teams information and players information and match winner and match information everything stored in database ?
pls guide to me database design for tennins games .....pls....
SQL server DBA
April 12, 2012 at 5:15 am
Again, I won't do it for you. If this is homework, you need to do it yourself. If you're getting paid for this, then you either need to pay me or do it yourself.
The rules of tennis are simple to find. Here they are from the USTA[/url].
As I said before, take the basic concepts and start to define them as your entities. A player is absolutely one entity. Another one is a game. A game is going to be related to the player, anywhere from 2 to 4 players are required for one game. You just work through it from there. A player has attributes such as their name, their age (although you might be better off with a birthdate so you can calculate age rather than have to update this annually), their sex. A game has a score assigned to each side (note, not to each player because you have to take into account doubles games).
All this should start to guide you through this process. Surely you've been covering database design classes in your school. Just apply them here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 12, 2012 at 5:34 am
definatly i will paid to you for these things...just u can guide to me..basically im DBA guy.i know but data modlelings and design pattens i want help from others side or your side also..pls..
Design for the database(schems and structure) for games?
SQL server DBA
April 12, 2012 at 8:06 am
kranthi.india123 (4/12/2012)
definatly i will paid to you for these things...just u can guide to me..basically im DBA guy.i know but data modlelings and design pattens i want help from others side or your side also..pls..Design for the database(schems and structure) for games?
If you would post what you have done so far, or what your thoughts are we can help refine the database, but we can't do it all. So post a Data model or table structures and we'll gladly comment on it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 12, 2012 at 8:37 am
kranthi.india123 (4/12/2012)
definatly i will paid to you for these things
You might want to ask Grant's rate before you offer to pay him...
i know but data modlelings and design pattens i want help from others side or your side also..pls..
Well,if you know data modelling, then you should be able to create at least a basic data model based on the rules that Grant posted. Post what you have so far and we can make suggestions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 17, 2012 at 5:11 am
match win/lose trigger in sql server
Hi all,
how to write trigger Match win\lose\draw send Email for Users
For Example:india vs Aus match..here when user Asked to me india win\lose\draw\tie the Match Updated on send on Email.
is it possible?? win and loss or drawn in Match send Updated Mail to User(i mean Match will be started on 4PM and Ending on 8Pm.This situation 7.59PM india win the Match i.e.,automatic updated on user Email or mobile..how????????
pls suggest me on send Email????????????????
SQL server DBA
April 17, 2012 at 5:15 am
Sure it's possible. Read up on Database Mail
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply