Re: Database theory and money
From: Jan Lenders <J.Lenders_at_Betuwe.net>
Date: Mon, 11 Sep 2000 07:26:09 GMT
Message-ID: <8pi1e4$hsp$1_at_nnrp1.deja.com>
violates relational principles, then;
t_Invoice
would too. In that case 90% of the world's tables wouldn't be a relation.
Rgds,
Jan
Date: Mon, 11 Sep 2000 07:26:09 GMT
Message-ID: <8pi1e4$hsp$1_at_nnrp1.deja.com>
In article <jhUu5.27883$E_6.10355921_at_news3.rdc1.on.home.com>,
"Chad" <cthomas500_at_home.com> wrote:
> I just want some feedback on storing monetary values of different
currencies
> in the same column in a table. I think it violates relational
principles.
>
> Does anyone have a good source on this?
>
> Chad Thomas
>
>
If;
t_Accounts
- AccountNumber - ClientNumber - Currency - Balance - ...
violates relational principles, then;
t_Invoice
- InvoiceNumber - ClientNumber - ProductId - DeliveredAmount - ...
would too. In that case 90% of the world's tables wouldn't be a relation.
Rgds,
Jan
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Sep 11 2000 - 09:26:09 CEST