Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
magmo
Aged Yak Warrior
558 Posts |
 Posted - 2006-11-15 : 05:38:57
|
| HiI have a database design that I could use some tip on. I'm about to create a database on different engines, The database should hold 5 different languages. I need to display several facts about the engine, which should be language dependent. So the output display several facts about the engine in different languages. But the problem is the following... Lets say we need to enter a value for fuel. The fuel value can really only have two values one for the american language and one for the other languages. And I only want to enter this value two times, one for the american value and one for the other languages.How should I design this database in the best way?Best Regards |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2006-11-15 : 16:03:38
|
| Table 1 - Engines (ENGID,InternalDesc)Table 2 - EngineDetail(ENGID,LanguageID,FuelID,Desc)Table 3 - Fuel(FuelID,FuelValue)Table 4 - Language(LanguageID,LanguageDesc)You will put the fuelID in the engine detail table if the fuel type is associciated with a the language.If a single language can havemultiple fuel types then use this designTable 1 - Engines (ENGINEID,InternalDesc)Table 2 - EngineDetail(ENGINEID,LanguageID,Desc)Table 3 - Fuel(FuelID,LanguageID,FuelValue)Table 4 - Language(LanguageID,LanguageDesc)In this version you will see that the referance for fuel is held by language. |
 |
|
|
|
|
|
|
|
5 language rows, but only 2 available values