| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> database design question? best practise
Hi,
I've a database for a mulitlanguage news website with three tables:
What is the best design?
EXAMPLE 1:
----------------|
-->|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 - 06:47:41 CDT
 |
 |