I would like to create a Player database and link this to my website game how do I do this and what is the best application to create this in?
Thanks in advance.
I would like to create a Player database and link this to my website game how do I do this and what is the best application to create this in?
Thanks in advance.
Jump to PostWhat does your player do ?
Jump to Postwhat exactly you wan to do in the application ?
What does your player do ?
This would be player information ie club names date of birth,
General attributes, player name, position etc
what exactly you wan to do in the application ?
Add and update information
Sports team? Lots of examples.
1 Team (pk TeamId)
2 Player (pk PlayerId)
3 Player/Team (pk is from fk's TeamId and PlayerId plus a date, assuming you want that over time)
4 PlayerAttributeType (pk PlayerAttributeTypeId, instances include personal and position attribute types: height, weight, DOB, favorite color, etc.)
5 Player/PlayerAttributeType (pk is from fk's PlayerId, PlayerAttributeTypeId, date)
You could even go down another level and have a Player/PlayerAttributeType/Team entity, depending on if the player had different attributes for different teams (Look at American baseball players such as Russell Martin or Johnny Damon...different positions for different teams for different seasons).
Might be too vague (sorry, no picture).
one question:--
Can a play belong to multiple team under any scenarios ?
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.