database design question? best practise
From: Ben <ben_at_idreams.nl>
Date: 1 Jul 2004 04:47:41 -0700
Message-ID: <1cbb428.0407010347.5a8c8211_at_posting.google.com>
Hi,
|languages: |
Date: 1 Jul 2004 04:47:41 -0700
Message-ID: <1cbb428.0407010347.5a8c8211_at_posting.google.com>
Hi,
I've a database for a mulitlanguage news website with three tables:
- Languages
- NewsCategories
- News
What is the best design?
EXAMPLE 1:
|languages: |
----------------|
-->|languageID |
| |name |
| |_______________|
|
| ________________
| |newsCategories:|
| ----------------|
| |newsCategorieID|<--
|->|languageID |<-|----
|name | | |
|_______________| | |
| |
________________ | |
|news: | | |
----------------| | |
|newsID | | |
|newsCategorieID|<- |
|languageID |<------
|name |
|_______________|
EXAMPLE 2:
________________
|languages: |
----------------|
-->|languageID |<------
| |name | |
| |_______________| |
| |
| ________________ |
| |newsCategories:| |
| ----------------| |
| |newsCategorieID|<-- |
|->|languageID | | |
|name | | |
|_______________| | |
| |
________________ | |
|news: | | |
----------------| | |
|newsID | | |
|newsCategorieID|<- |
|languageID |<------
|name |
|_______________|
What is best practise?
Thanks for any insgight on this question.
Ben Received on Thu Jul 01 2004 - 13:47:41 CEST