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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-06 : 21:01:27
|
Tony writes "I want to store data in table(s) that comprises of local (£,$ etc)currency rate and also in Euro conversion rate. What is the best way of storing the data without affecting its 'third normal form'. At the momment, I have two options and they are as follows:
1) Since the Euro column or table is 'derive' data from the local column/table, I will create a one-to-one relationship - and that way I maintain the 3rd nf. In other words, create two tables - 'Local_Rates' and 'Euro_Rates'.
alternatively,
2) Keep both columns in the same table eg,
'Rates_Local_Currency'
'Rates_Euro_Currency'
If done this way, the table will be denormalized to...2nd nf.
Can anyone suggest the best way?
Thanks
T" |
|
|
|
|
|
Table design