On Fri, 13 Sep 2024, Muhammad Usman Khan wrote:
To handle this situation in PostgreSQL, you can model the data in a way that maintains a single entry for each owner in the people table while linking the owner to multiple dairies through a separate dairies table. This is a typical one-to-many relationship (one person can own many dairies). The following is testing scenario which might help you
Muhammed, Thank you. There are a number of industries (most involving natural resources) so the one-to-many table will be more general. Regards, Rich
