dbTalk Databases Forums  

Database design

comp.databases.mysql comp.databases.mysql


Discuss Database design in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mariano C.
 
Posts: n/a

Default Database design - 03-19-2011 , 09:38 AM






I'm developing a project about little soccer league. I need to store
teams, team's players, matches info (which are two teams involved in
the match), events (various events happened douring a single match:
goal, penalty, red card, yellow card, etc).

This is the DB realized (only PK and FK are shown):
http://www.freeimgshost.com/viewer.p...je2iup9cw8.jpg

What do you think? Does it seems correct????

Best regards
MC

Reply With Quote
  #2  
Old   
The Natural Philosopher
 
Posts: n/a

Default Re: Database design - 03-19-2011 , 11:00 AM






Mariano C. wrote:
Quote:
I'm developing a project about little soccer league. I need to store
teams, team's players, matches info (which are two teams involved in
the match), events (various events happened douring a single match:
goal, penalty, red card, yellow card, etc).

This is the DB realized (only PK and FK are shown):
http://www.freeimgshost.com/viewer.p...je2iup9cw8.jpg

What do you think? Does it seems correct????

Dunno. Site times out on me.
Quote:
Best regards
MC

Reply With Quote
  #3  
Old   
Jerry Stuckle
 
Posts: n/a

Default Re: Database design - 03-19-2011 , 11:53 AM



On 3/19/2011 11:38 AM, Mariano C. wrote:
Quote:
I'm developing a project about little soccer league. I need to store
teams, team's players, matches info (which are two teams involved in
the match), events (various events happened douring a single match:
goal, penalty, red card, yellow card, etc).

This is the DB realized (only PK and FK are shown):
http://www.freeimgshost.com/viewer.p...je2iup9cw8.jpg

What do you think? Does it seems correct????

Best regards
MC
I suggest you post your design here - not the jpg, but the tables and
columns. It doesn't have to be the actual CREATE TABLE statements - a
summary of the design will work just fine, along with comments on keys.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

Reply With Quote
  #4  
Old   
Luuk
 
Posts: n/a

Default Re: Database design - 03-19-2011 , 04:09 PM



On 19-03-2011 18:53, Jerry Stuckle wrote:
Quote:
On 3/19/2011 11:38 AM, Mariano C. wrote:
I'm developing a project about little soccer league. I need to store
teams, team's players, matches info (which are two teams involved in
the match), events (various events happened douring a single match:
goal, penalty, red card, yellow card, etc).

This is the DB realized (only PK and FK are shown):
http://www.freeimgshost.com/viewer.p...je2iup9cw8.jpg

What do you think? Does it seems correct????

Best regards
MC

I suggest you post your design here - not the jpg, but the tables and
columns. It doesn't have to be the actual CREATE TABLE statements - a
summary of the design will work just fine, along with comments on keys.

A better place would be http://pastebin.com/ to paste the design...

Because pastebin.com is much more relyable than www.freeimgshost.com

--
Luuk

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.