Hi,
I have a table which has 2 fields (among others): origin and destination.
Also, I have a single table that represents both origins and destinations.
If these 2 tables are to be related through foreign keys then both fields
in the first table will point to the second table. Is this a good practice
in database design? If not, what is a solution besides making 2 separate
tables out of the second one?
Respectfully,
Jorge Maldonado