 |
The second diagram lists all the Tables separately, but we have adopted the approach shown in the first diagram,
of having one table, with a field that identifies the type of Reference Data.
The reason is that this approach simplifies the validation of Reference Data in SQL, using outer joins.
Barry Williams
8th. September 2004
Principal Consultant
Database Answers
|
|
