Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Core Competencies with Descriptions
|   ANZSCO_Code | ANZSCO_Title                                  | Core_Competencies   |   Score | Proficiency_level   | Anchor_value                                                          | Core competencies descriptions.Competency Description                                   |   proficiency code |
|--------------:|:----------------------------------------------|:--------------------|--------:|:--------------------|:----------------------------------------------------------------------|:----------------------------------------------------------------------------------------|-------------------:|
|          1112 | General Managers                              | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1321 | Corporate Services Managers                   | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1322 | Finance Managers                              | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1323 | Human Resource Managers                       | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1331 | Construction Managers                         | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1332 | Engineering Managers                          | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1333 | Importers, Exporters and Wholesalers          | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1336 | Supply, Distribution and Procurement Managers | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1341 | Child Care Centre Managers                    | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1342 | Health and Welfare Services Managers          | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |


Table: Occupation Descriptions
|   ANZSCO_Code | ANZSCO_Title                            | ANZSCO_Desc                                                                                                                                                                                                                          |
|--------------:|:----------------------------------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|          1111 | Chief Executives and Managing Directors | Chief Executives and Managing Directors determine, formulate and review the general policy programs and the overall direction of organisations within the framework established by boards of directors and similar governing bodies. |
|          1112 | General Managers                        | General Managers plan, organise, direct, control and review the day-to-day operations and major functions of commercial, industrial, government and defence organisations through departmental managers and subordinate executives.  |
|          1213 | Livestock Farmers                       | Livestock Farmers plan, organise, control, coordinate and perform farming operations to breed and raise livestock.                                                                                                                   |
|          1214 | Mixed Crop and Livestock Farmers        | Mixed Crop and Livestock Farmers plan, organise, control, coordinate and perform farming operations to both grow crops and to breed and raise livestock.                                                                             |
|          1321 | Corporate Services Managers             | Corporate Services Managers organise and direct the overall administration of organisations.                                                                                                                                         |
|          1322 | Finance Managers                        | Finance Managers organise and direct the financial and accounting activities within organisations.                                                                                                                                   |
|          1323 | Human Resource Managers                 | Human Resource Managers organise and direct the human resource and workplace relations activities within organisations.                                                                                                              |
|          1324 | Policy and Planning Managers            | Policy and Planning Managers organise and direct policy advice and strategic planning within organisations.                                                                                                                          |
|          1325 | Research and Development Managers       | Research and Development Managers organise and direct research and development activities within organisations.                                                                                                                      |
|          1331 | Construction Managers                   | Construction Managers organise and direct the construction of civil engineering projects, buildings and dwellings, and the physical and human resources involved in building and construction.                                       |


Table: Specialist tasks
|   ANZSCO_Code | ANZSCO_Title                    | Specialist_Task                               |   % of time spent on task | Specialist_Cluster                                  |   % of time spent on cluster | Cluster_Family   |   % of time spent on family | Seek Job Search URL             | Seek URL field                       | Seek URL                                                     |
|--------------:|:--------------------------------|:----------------------------------------------|--------------------------:|:----------------------------------------------------|-----------------------------:|:-----------------|----------------------------:|:--------------------------------|:-------------------------------------|:-------------------------------------------------------------|
|          2347 | Veterinarians                   | Operate on patients                           |                0.039096   | Provide health care or administer medical treatment |                   0.078192   | Health and care  |                    0.930654 | Veterinarians                   | Veterinarians-jobs                   | https://www.seek.com.au/Veterinarians-jobs                   |
|          2347 | Veterinarians                   | Treat acute illnesses, infections or injuries |                0.039096   | Provide health care or administer medical treatment |                   0.078192   | Health and care  |                    0.930654 | Veterinarians                   | Veterinarians-jobs                   | https://www.seek.com.au/Veterinarians-jobs                   |
|          2521 | Chiropractors and Osteopaths    | Apply bandages, dressings or splints          |                0.00788158 | Provide health care or administer medical treatment |                   0.00788158 | Health and care  |                    0.986703 | Chiropractors-and-Osteopaths    | Chiropractors-and-Osteopaths-jobs    | https://www.seek.com.au/Chiropractors-and-Osteopaths-jobs    |
|          2522 | Complementary Health Therapists | Operate on patients                           |                0.0077916  | Provide health care or administer medical treatment |                   0.00946992 | Health and care  |                    0.874678 | Complementary-Health-Therapists | Complementary-Health-Therapists-jobs | https://www.seek.com.au/Complementary-Health-Therapists-jobs |
|          2522 | Complementary Health Therapists | Treat acute illnesses, infections or injuries |                0.00257651 | Provide health care or administer medical treatment |                   0.00946992 | Health and care  |                    0.874678 | Complementary-Health-Therapists | Complementary-Health-Therapists-jobs | https://www.seek.com.au/Complementary-Health-Therapists-jobs |
|          2523 | Dental Practitioners            | Operate on patients                           |                0.034019   | Provide health care or administer medical treatment |                   0.034019   | Health and care  |                    0.972979 | Dental-Practitioners            | Dental-Practitioners-jobs            | https://www.seek.com.au/Dental-Practitioners-jobs            |
|          2526 | Podiatrists                     | Treat chronic diseases or disorders           |                0.240058   | Provide health care or administer medical treatment |                   0.383254   | Health and care  |                    0.972094 | Podiatrists                     | Podiatrists-jobs                     | https://www.seek.com.au/Podiatrists-jobs                     |
|          2526 | Podiatrists                     | Operate on patients                           |                0.143196   | Provide health care or administer medical treatment |                   0.383254   | Health and care  |                    0.972094 | Podiatrists                     | Podiatrists-jobs                     | https://www.seek.com.au/Podiatrists-jobs                     |
|          2532 | Anaesthetists                   | Implement advanced life support techniques    |                0.0275435  | Provide health care or administer medical treatment |                   0.0275435  | Health and care  |                    0.854083 | Anaesthetists                   | Anaesthetists-jobs                   | https://www.seek.com.au/Anaesthetists-jobs                   |
|          2533 | Specialist Physicians           | Treat chronic diseases or disorders           |                0.175373   | Provide health care or administer medical treatment |                   0.223339   | Health and care  |                    0.957324 | Specialist-Physicians           | Specialist-Physicians-jobs           | https://www.seek.com.au/Specialist-Physicians-jobs           |


Table: Target Core Competencies with Descriptions
|   ANZSCO_Code | ANZSCO_Title                                  | Core_Competencies   |   Score | Proficiency_level   | Anchor_value                                                          | Core competencies descriptions.Competency Description                                   |   proficiency code |
|--------------:|:----------------------------------------------|:--------------------|--------:|:--------------------|:----------------------------------------------------------------------|:----------------------------------------------------------------------------------------|-------------------:|
|          1112 | General Managers                              | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1321 | Corporate Services Managers                   | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1322 | Finance Managers                              | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1323 | Human Resource Managers                       | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1331 | Construction Managers                         | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1332 | Engineering Managers                          | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1333 | Importers, Exporters and Wholesalers          | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1336 | Supply, Distribution and Procurement Managers | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1341 | Child Care Centre Managers                    | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |
|          1342 | Health and Welfare Services Managers          | Oral communication  |       7 | Intermediate        | Participate in a work meeting and ask appropriate follow up questions | The ability to communicate information and ideas in speaking so others will understand. |                  2 |


Table: Target Occupations
|   ANZSCO_Code | ANZSCO_Title                            | ANZSCO_Desc                                                                                                                                                                                                                          |
|--------------:|:----------------------------------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|          1111 | Chief Executives and Managing Directors | Chief Executives and Managing Directors determine, formulate and review the general policy programs and the overall direction of organisations within the framework established by boards of directors and similar governing bodies. |
|          1112 | General Managers                        | General Managers plan, organise, direct, control and review the day-to-day operations and major functions of commercial, industrial, government and defence organisations through departmental managers and subordinate executives.  |
|          1213 | Livestock Farmers                       | Livestock Farmers plan, organise, control, coordinate and perform farming operations to breed and raise livestock.                                                                                                                   |
|          1214 | Mixed Crop and Livestock Farmers        | Mixed Crop and Livestock Farmers plan, organise, control, coordinate and perform farming operations to both grow crops and to breed and raise livestock.                                                                             |
|          1321 | Corporate Services Managers             | Corporate Services Managers organise and direct the overall administration of organisations.                                                                                                                                         |
|          1322 | Finance Managers                        | Finance Managers organise and direct the financial and accounting activities within organisations.                                                                                                                                   |
|          1323 | Human Resource Managers                 | Human Resource Managers organise and direct the human resource and workplace relations activities within organisations.                                                                                                              |
|          1324 | Policy and Planning Managers            | Policy and Planning Managers organise and direct policy advice and strategic planning within organisations.                                                                                                                          |
|          1325 | Research and Development Managers       | Research and Development Managers organise and direct research and development activities within organisations.                                                                                                                      |
|          1331 | Construction Managers                   | Construction Managers organise and direct the construction of civil engineering projects, buildings and dwellings, and the physical and human resources involved in building and construction.                                       |


Table: Target Specialist task
|   ANZSCO_Code | ANZSCO_Title                    | Specialist_Task                               |   % of time spent on task | Specialist_Cluster                                  |   % of time spent on cluster | Cluster_Family   |   % of time spent on family | Seek URL                                                     | Seek Job Search URL             | Seek URL field                       |
|--------------:|:--------------------------------|:----------------------------------------------|--------------------------:|:----------------------------------------------------|-----------------------------:|:-----------------|----------------------------:|:-------------------------------------------------------------|:--------------------------------|:-------------------------------------|
|          2347 | Veterinarians                   | Operate on patients                           |                0.039096   | Provide health care or administer medical treatment |                   0.078192   | Health and care  |                    0.930654 | https://www.seek.com.au/Veterinarians-jobs                   | Veterinarians                   | Veterinarians-jobs                   |
|          2347 | Veterinarians                   | Treat acute illnesses, infections or injuries |                0.039096   | Provide health care or administer medical treatment |                   0.078192   | Health and care  |                    0.930654 | https://www.seek.com.au/Veterinarians-jobs                   | Veterinarians                   | Veterinarians-jobs                   |
|          2521 | Chiropractors and Osteopaths    | Apply bandages, dressings or splints          |                0.00788158 | Provide health care or administer medical treatment |                   0.00788158 | Health and care  |                    0.986703 | https://www.seek.com.au/Chiropractors-and-Osteopaths-jobs    | Chiropractors-and-Osteopaths    | Chiropractors-and-Osteopaths-jobs    |
|          2522 | Complementary Health Therapists | Operate on patients                           |                0.0077916  | Provide health care or administer medical treatment |                   0.00946992 | Health and care  |                    0.874678 | https://www.seek.com.au/Complementary-Health-Therapists-jobs | Complementary-Health-Therapists | Complementary-Health-Therapists-jobs |
|          2522 | Complementary Health Therapists | Treat acute illnesses, infections or injuries |                0.00257651 | Provide health care or administer medical treatment |                   0.00946992 | Health and care  |                    0.874678 | https://www.seek.com.au/Complementary-Health-Therapists-jobs | Complementary-Health-Therapists | Complementary-Health-Therapists-jobs |
|          2523 | Dental Practitioners            | Operate on patients                           |                0.034019   | Provide health care or administer medical treatment |                   0.034019   | Health and care  |                    0.972979 | https://www.seek.com.au/Dental-Practitioners-jobs            | Dental-Practitioners            | Dental-Practitioners-jobs            |
|          2526 | Podiatrists                     | Treat chronic diseases or disorders           |                0.240058   | Provide health care or administer medical treatment |                   0.383254   | Health and care  |                    0.972094 | https://www.seek.com.au/Podiatrists-jobs                     | Podiatrists                     | Podiatrists-jobs                     |
|          2526 | Podiatrists                     | Operate on patients                           |                0.143196   | Provide health care or administer medical treatment |                   0.383254   | Health and care  |                    0.972094 | https://www.seek.com.au/Podiatrists-jobs                     | Podiatrists                     | Podiatrists-jobs                     |
|          2532 | Anaesthetists                   | Implement advanced life support techniques    |                0.0275435  | Provide health care or administer medical treatment |                   0.0275435  | Health and care  |                    0.854083 | https://www.seek.com.au/Anaesthetists-jobs                   | Anaesthetists                   | Anaesthetists-jobs                   |
|          2533 | Specialist Physicians           | Treat chronic diseases or disorders           |                0.175373   | Provide health care or administer medical treatment |                   0.223339   | Health and care  |                    0.957324 | https://www.seek.com.au/Specialist-Physicians-jobs           | Specialist-Physicians           | Specialist-Physicians-jobs           |


Table: Target Tech tools - example tools
| Technology_tool                                  | Technology_tool_example                               |   Tech Tool Ranking |
|:-------------------------------------------------|:------------------------------------------------------|--------------------:|
| Access software                                  | Citrix                                                |                   1 |
| Accounting software                              | MYOB BusinessEssentials                               |                   1 |
| Aircraft communication systems                   | Ultra high frequency UHF radio communication systems  |                   1 |
| Aircraft guidance systems                        | Radio frequency-based navigation and guidance systems |                   1 |
| Application server software                      | Microsoft Windows Server                              |                   1 |
| Auditory function screening units                | Auditory brainstem response ABR screening systems     |                   1 |
| Automation software                              | Electronic train management systems ETMS              |                   1 |
| Blood pressure monitors                          | Invasive blood pressure monitors                      |                   1 |
| Business intelligence and data analysis software | Tableau                                               |                   1 |
| Carbon monoxide analysing equipment              | Carbon monoxide detectors                             |                   1 |


Table: Target Technology tools
|   ANZSCO_Code | ANZSCO_Title                                  | Technology_tool                             |
|--------------:|:----------------------------------------------|:--------------------------------------------|
|          1111 | Chief Executives and Managing Directors       | Data base user interface and query software |
|          1112 | General Managers                              | Data base user interface and query software |
|          1321 | Corporate Services Managers                   | Data base user interface and query software |
|          1324 | Policy and Planning Managers                  | Data base user interface and query software |
|          1325 | Research and Development Managers             | Data base user interface and query software |
|          1331 | Construction Managers                         | Data base user interface and query software |
|          1333 | Importers, Exporters and Wholesalers          | Data base user interface and query software |
|          1336 | Supply, Distribution and Procurement Managers | Data base user interface and query software |
|          1342 | Health and Welfare Services Managers          | Data base user interface and query software |
|          1343 | School Principals                             | Data base user interface and query software |


Table: Tech tools - example tools
| Technology_tool                                  | Technology_tool_example                               |   Tech Tool Ranking |
|:-------------------------------------------------|:------------------------------------------------------|--------------------:|
| Access software                                  | Citrix                                                |                   1 |
| Accounting software                              | MYOB BusinessEssentials                               |                   1 |
| Aircraft communication systems                   | Ultra high frequency UHF radio communication systems  |                   1 |
| Aircraft guidance systems                        | Radio frequency-based navigation and guidance systems |                   1 |
| Application server software                      | Microsoft Windows Server                              |                   1 |
| Auditory function screening units                | Auditory brainstem response ABR screening systems     |                   1 |
| Automation software                              | Electronic train management systems ETMS              |                   1 |
| Blood pressure monitors                          | Invasive blood pressure monitors                      |                   1 |
| Business intelligence and data analysis software | Tableau                                               |                   1 |
| Carbon monoxide analysing equipment              | Carbon monoxide detectors                             |                   1 |


Table: Technology tools
|   ANZSCO_Code | ANZSCO_Title                                  | Technology_tool                             |
|--------------:|:----------------------------------------------|:--------------------------------------------|
|          1111 | Chief Executives and Managing Directors       | Data base user interface and query software |
|          1112 | General Managers                              | Data base user interface and query software |
|          1321 | Corporate Services Managers                   | Data base user interface and query software |
|          1324 | Policy and Planning Managers                  | Data base user interface and query software |
|          1325 | Research and Development Managers             | Data base user interface and query software |
|          1331 | Construction Managers                         | Data base user interface and query software |
|          1333 | Importers, Exporters and Wholesalers          | Data base user interface and query software |
|          1336 | Supply, Distribution and Procurement Managers | Data base user interface and query software |
|          1342 | Health and Welfare Services Managers          | Data base user interface and query software |
|          1343 | School Principals                             | Data base user interface and query software |

 


tables: name: Core Competencies with Descriptions
data: Core Competencies with Descriptions.csv
name: Occupation Descriptions
data: Occupation Descriptions.csv
name: Specialist tasks
data: Specialist tasks.csv
name: Target Core Competencies with Descriptions
data: Target Core Competencies with Descriptions.csv
name: Target Occupations
data: Target Occupations.csv
name: Target Specialist task
data: Target Specialist task.csv
name: Target Tech tools - example tools
data: Target Tech tools - example tools.csv
name: Target Technology tools
data: Target Technology tools.csv
name: Tech tools - example tools
data: Tech tools - example tools.csv
name: Technology tools
data: Technology tools.csv
label: Specialist tasks
ANZSCO_Code
Occupation Descriptions
ANZSCO_Code
Technology tools
ANZSCO_Code
Occupation Descriptions
ANZSCO_Code
Tech tools - example tools
Technology_tool
Technology tools
Technology_tool
Target Specialist task
Specialist_Task
Specialist tasks
Specialist_Task
Core Competencies with Descriptions
ANZSCO_Code
Occupation Descriptions
ANZSCO_Code
Target Core Competencies with Descriptions
ANZSCO_Title
Target Specialist task
ANZSCO_Title
Target Technology tools
ANZSCO_Title
Target Specialist task
ANZSCO_Title
Target Technology tools
Technology_tool
Target Tech tools - example tools
Technology_tool
output: {
    "joins": [
        {
            "from_table": "Specialist tasks",
            "from_column": "ANZSCO_Code",
            "to_table": "Occupation Descriptions",
            "to_column": "ANZSCO_Code"
        },
        {
            "from_table": "Technology tools",
            "from_column": "ANZSCO_Code",
            "to_table": "Occupation Descriptions",
            "to_column": "ANZSCO_Code"
        },
        {
            "from_table": "Tech tools - example tools",
            "from_column": "Technology_tool",
            "to_table": "Technology tools",
            "to_column": "Technology_tool"
        },
        {
            "from_table": "Target Specialist task",
            "from_column": "Specialist_Task",
            "to_table": "Specialist tasks",
            "to_column": "Specialist_Task"
        },
        {
            "from_table": "Core Competencies with Descriptions",
            "from_column": "ANZSCO_Code",
            "to_table": "Occupation Descriptions",
            "to_column": "ANZSCO_Code"
        },
        {
            "from_table": "Target Core Competencies with Descriptions",
            "from_column": "ANZSCO_Title",
            "to_table": "Target Specialist task",
            "to_column": "ANZSCO_Title"
        },
        {
            "from_table": "Target Technology tools",
            "from_column": "ANZSCO_Title",
            "to_table": "Target Specialist task",
            "to_column": "ANZSCO_Title"
        },
        {
            "from_table": "Target Technology tools",
            "from_column": "Technology_tool",
            "to_table": "Target Tech tools - example tools",
            "to_column": "Technology_tool"
        }
    ]
}