Re: database design question? best practise

From: Stefan Oedenkoven <stefan-oedenkoven_at_gmx.de>
Date: Thu, 1 Jul 2004 16:06:38 +0200
Message-ID: <2kik33F2pu4cU1@uni-berlin.de>

Hi Ben,

try this . you don't need LanguageID in references in more than one table....

      |languages:     |
      ----------------|


     |languageID     |

     |name           |





     |newsCategories:|

     ----------------|


     |newsCategorieID|

     |description (may be in english?)





     |newsCategorySub:|

     ----------------


     |newsCategorieSubID

     |FKnewsCategorieID

     |FKlanguageID

      |name  (name of the category in the actual language)




     |news:

      ----------------
      |newsID
      |FKnewsCategorieSubID
      |name
      |text

regards,
Stefan Received on Thu Jul 01 2004 - 09:06:38 CDT