MySQL Forums :: Newbie :: Rock/paper/scissors design

Advanced Search

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

Subject Written By Posted
Rock/paper/scissors design jan thurni 02/03/2013 03:06PM
Re: Rock/paper/scissors design Rick James 02/05/2013 11:04PM
Re: Rock/paper/scissors design laptop alias 02/06/2013 05:04AM
Re: Rock/paper/scissors design jan thurni 02/06/2013 05:07PM
Re: Rock/paper/scissors design laptop alias 02/07/2013 02:46AM
Re: Rock/paper/scissors design jan thurni 02/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.