Designing SQL DB

Question

I am creating a Database which should have these datas:

Table Name: PlayerNames

Columns: FirstName, LastName, Rank

Now I have another data which shows the HeadToHead count of winning: For eg.

A-A = Null A-B = 5 (That means A against B and A won) A-C = 3 (A against C, and A won)

B-A = 3 (That means B against A, and B won. I dont know A-B and B-A are not same). B-B = Null B-C = 4

..... and so on. I have to create a DB for this in which I can pull these records and viewers can select a player and select another player and see their opponent stats. How should DB be designed?

Any help?

Thanks!

Daniel Casserly · Accepted Answer · 2011-02-26 00:05:11Z

1

PLAYER id, firstname, lastname, rank,

GAME winning_player_id, losing_player_id, score,

maybe?

answered Feb 26, 2011 at 0:05

Daniel Casserly

3,5403 gold badges31 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RG-3 Over a year ago

hhmmm...lemme implement this.

Daniel Casserly Over a year ago

@klm9971 good man if it works please remember to mark as the answer

V-Light · Accepted Answer · 2011-02-26 02:09:29Z

0

Here is another ERM: It seems to make sense, at least for me. But I think it will be too complicated when you start to write the update/insert queries

enter image description here

answered Feb 26, 2011 at 2:09

V-Light

3,1253 gold badges28 silver badges32 bronze badges

Collectives™ on Stack Overflow

Designing SQL DB

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related