MySQL Forums
Forum List  »  Newbie

Rock/paper/scissors design
Posted by: jan thurni
Date: February 03, 2013 03:06PM

Hi, do you know the game called rock, paper, scissors? Two players playing it against each other. There are several rounds until one player got 3 wins.

Shall I create one table containing the choices for each round?
Columns: id, player1, choice1, player2, choice2

Or is it better to normalize more and split it into severeal tables:
Table: rounds, Column id
Table: choices, Columns: round_id, player_id, choice

From your experience, which way is better?

Rds, janosh

Options: ReplyQuote

Written By
Rock/paper/scissors design
February 03, 2013 03:06PM
February 05, 2013 11:04PM
February 06, 2013 05:04AM
February 06, 2013 05:07PM
February 07, 2013 02:46AM
February 07, 2013 04:34PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.