Hi ppl,
I was wondering, since Order table contains history data (unchanging), shouldn't we just place the shipping & billing address into the order table instead of a link? (eg. a string containing the concatenated address)
[After the order is placed... both the addresses cannot be changed yes?]
Else won't the address table be bloated with redundant data since every single order will insert 2 new records into it?
It will also save time retrieving order records since it won't need to traverse the address table for both the addresses.
Thanks.
SY Lim.