Database organize dilemma (simple web app)?

User Table ----------- id | name ----------- 1 | a 2 | be 3 | c score table --------------- userId1|userId2|user1score|user2score 1|2|11|9 2|3|22|80 1|3|15|15.

Table User: id name 1 A 2 B 3 C table MutualScore user_id_1 user_id_2 score_1 score_2 1 2 11 9 ... Set indexes correcty, so both user_id_1 and 2 are foreign keys towards table User and make the pair user_id_1 and 2 unique. However, as far as I know, making sure that there is no reverse pair breking the uniqueness, you need to make an insert trigger, and you will have a clear structure.

For multi-player matches: Table User ---------- User_ID (Primary Key) User_Name Table Match ----------- Match_ID (Primary Key) Match_Date Table User_Match ---------------- Match_ID (Primary Key) User_ID (Primary Key) Score.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.