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