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.

Recommended Answers

All 6 Replies

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 ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.