List:General Discussion« Previous MessageNext Message »
From:<webmaster Date:September 1 2010 12:35pm
Subject:RE: Database design help
View as plain text  
Hi Neil,

May be your question is too vague.

You have already identified the 'real world' objects that you want
represented in the database.

Have you identified the specific pieces of information that you want stored
for each object ? After you do that, you can then start to see what the
relationships between the objects are.

And you can then ask people that don't know anything about your application
more specific questions like:

- this is what I have in this and that object : how do I get this and that
to relate to this and that ?

Thanks,
Justin

-----Original Message-----
From: Tompkins Neil [mailto:neil.tompkins@stripped] 
Sent: 01 September 2010 12:52
To: [MySQL]
Subject: Fwd: Database design help

Looking for some help / comments if possible ?

Cheers
Neil

---------- Forwarded message ----------
From: Neil Tompkins <neil.tompkins@stripped>
Date: Tue, Aug 31, 2010 at 8:48 PM
Subject: Database design help
To: mysql@stripped


Hi

I've a soccer application consisting of managers, teams players and
fixtures/results. Basically each manager will get points for each game which
will depend on the result.

What would be the best table design bearing in mind that a manager can move
to a different club.

My thought was to have a field in the fixtures/results table for the manager
points but i think that I will also need a users field so that I can
remember which points belong to which manager.

Is this the correct approach??

Cheers Neil



__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5414 (20100901) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5414 (20100901) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 

Thread
Database design helpNeil Tompkins31 Aug
  • Fwd: Database design helpTompkins Neil1 Sep
    • Re: Database design helpClaudio Nanni1 Sep
    • RE: Database design helpwebmaster1 Sep
  • RE: Database design helpJerry Schwartz1 Sep
    • Re: Database design helpTompkins Neil1 Sep
      • Re: Database design helpMySQL)1 Sep