I am working on a database to find "common ground" between persons of interterst, real estate and company ownership. This is of an investigative nature.
I have tried to google a solution, but the words relation and database gives trillions of hits, but no hits (i can find) with the kind of relationships I am looking for. Google itself has been my primary resource for finding all this information, but I need to structure it.
I am not sure on how to design the table structure.
For example.
Lets say we have company A.
It has the owner John Dow, and chairman Jane Dow.
They owned realEstate1 and realEstate5.
Company B has owner Roy Brown and Jane Dow, and chairman Black, and ow
Real Estate C. And suddenly a year later I find that Real Estate5 now is owned by company A.
And the list goes on and on and on...and the real estates change hands, the companies change hands...
I have considered having a table called "observation", and the input would be company C, real estate 4, owner A, emploeey C and so on.
I would then like to have a way to type in a real estate, then get ALL related information about it (all observations). In the same way I would like to type in an Owner or Emploey and get the same results, or just type in the company name in with it get all information in the database that has a connection.
I obciousely need a table for the observation, then one for the company, a table for employe, one for real estates and so on. But how would I set up the relationships between these tables? This would be a many to many to very many relationship structure...
Does anyone know of a sample that does something like this?
I have tried to google a solution, but the words relation and database gives trillions of hits, but no hits (i can find) with the kind of relationships I am looking for. Google itself has been my primary resource for finding all this information, but I need to structure it.
I am not sure on how to design the table structure.
For example.
Lets say we have company A.
It has the owner John Dow, and chairman Jane Dow.
They owned realEstate1 and realEstate5.
Company B has owner Roy Brown and Jane Dow, and chairman Black, and ow
Real Estate C. And suddenly a year later I find that Real Estate5 now is owned by company A.
And the list goes on and on and on...and the real estates change hands, the companies change hands...
I have considered having a table called "observation", and the input would be company C, real estate 4, owner A, emploeey C and so on.
I would then like to have a way to type in a real estate, then get ALL related information about it (all observations). In the same way I would like to type in an Owner or Emploey and get the same results, or just type in the company name in with it get all information in the database that has a connection.
I obciousely need a table for the observation, then one for the company, a table for employe, one for real estates and so on. But how would I set up the relationships between these tables? This would be a many to many to very many relationship structure...
Does anyone know of a sample that does something like this?