(English is not my natural language)
Desing is not a straight line, as you say. Front my point of view You
have to take into account:
- One customer should be an ID (VAT - Code). I think that legally the
VAT is enough.
- If you want to have the ability to change the delivery informatíon
for each invoice you can save that information with the invoice, or
even better prepare another table. In one table you have ID , name,
VAT and link to that table you can have many delivery places in
another table for each ID, for each one of these you have another
ID(Delivery).
- Doing these (having IDs in stead of text) you improve the quality
of information for statistical use.
- But always you have to see if the way you desing is operational for
the people.
- Having ID's will force you to always join tables, of this you will
have a lower answer speed.
- ..... And many many more implications
David
Received on Sat May 03 2003 - 03:06:43 CDT
