beginner - needs feedback on simple database design
This is a database I made for a project, any feedback is appreciated. Is setting up the handPlayed and Bet tables like this bad design? I rarely see designs set up like this. Is there a better way to do it without sacrificing too much performance (which is important for this application). thanks.
I would probably make the Bet table a child of the HandPlayed table.
It's PK would be HandNum, PlayerNum, and BetNum. (BetNum would begin with 1, and increment for each Player/Bet number.) HandNum and PlayerNum would be fk's to HandPlayed.
I think that this probably models the game better than two, discrete intersection tables.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert