How do I find a match between groups of tables, PHP

How can the similarity of 12 different tables(database) of one entity being determined with respect to the same 12 tables of another entity? In each table, are various properties.

An ER diagram already exists. Thus the tables already exists(MySQL), including the links between the tables. The problem lies by making a php script that’s able to find a match between many seperate entities. Comparing one with an another.

Sounds like a bad DB design. Lets see the ER.

The ERD would help to see where the relationships actually are.

Here is the ER diagram your asked for.
I considerd to unite the two groups, each consisting of 12 tables. In that case, each of the 12 tables get two functions.
This didn’t seem like a good idea. Based on this diagram I like to realise a PHP script that’s able to find the best possible match. For clarity, I omitted the content of the tables.

Thank you for your time


ER Diagram project 25032017.pdf (31.4 KB)

You can do this through SQL alone, providing there is a relationship you can track through each entity.

What is the question being asked of the database?

Sponsor our Newsletter | Privacy Policy | Terms of Service