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: HumanResources DimGender
| Gender   |
|:---------|
| F        |
| M        |


Table: HumanResources DimJob
|   JobCode | JobTitle                                 | JobFamily       | Occupation     |
|----------:|:-----------------------------------------|:----------------|:---------------|
|       300 | Accountant                               | Accounting      | Finance        |
|       305 | Accounts Manager                         | Sales           | Finance        |
|       310 | Accounts Payable Specialist              | Accounting      | Finance        |
|       315 | Accounts Receivable Specialist           | Accounting      | Finance        |
|       320 | Application Specialist                   | Systems         | Technology     |
|       325 | Assistant to the Chief Financial Officer | Management      | Administration |
|       330 | Benefits Specialist                      | Human Resources | Administration |
|       335 | Buyer                                    | Purchasing      | Administration |
|       340 | Chief Executive Officer                  | Management      | Administration |
|       345 | Chief Financial Officer                  | Management      | Administration |


Table: HumanResources DimManager
|   ManagerID | ManagerName        | ManagerJobTitle                  |
|------------:|:-------------------|:---------------------------------|
|           1 | Ken Sanchez        | Chief Executive Officer          |
|           2 | Terri Duffy        | Vice President of Engineering    |
|           3 | Roberto Tamburello | Engineering Manager              |
|           7 | Dylan Miller       | Research and Development Manager |
|          10 | Michael Raheem     | Research and Development Manager |
|          16 | David Bradley      | Marketing Manager                |
|          25 | James Hamilton     | Vice President of Production     |
|          26 | Peter Krebs        | Production Control Manager       |
|          27 | Jo Brown           | Production Supervisor - WC60     |
|          40 | JoLynn Dobney      | Production Supervisor - WC60     |


Table: HumanResources DimOrganization
|   Organization | OrganizationDesc   |
|---------------:|:-------------------|
|              0 | Executive          |
|              1 | Management         |
|              2 | Administration     |
|              3 | Professional       |
|              4 | Manufacturing      |


Table: HumanResources DimRatingScale
| RatingScale   | RatingScaleDesc   |
|:--------------|:------------------|
| Three Level   |                   |


Table: HumanResources DimReviewRating
|   ReviewRating | ReviewRatingDesc   |
|---------------:|:-------------------|
|             10 | Below Standard     |
|             20 | Meets Standard     |
|             30 | Exceeds Standard   |


Table: HumanResources DimSalariedFlag
|   SalariedFlag | SalariedDesc   |
|---------------:|:---------------|
|              0 | Not Salaried   |
|              1 | Salaried       |


Table: HumanResources FactEmployeeReview
|   EmployeeID | ReviewDate              | RatingScale   |   JobCode | Gender   |   Organization |   ManagerID |   SalariedFlag |   Salary | Quartile   |   ReviewRating |   MeritIncreasePct |   LengthofService | AgeGroup   |   Age |
|-------------:|:------------------------|:--------------|----------:|:---------|---------------:|------------:|---------------:|---------:|:-----------|---------------:|-------------------:|------------------:|:-----------|------:|
|            8 | 2017-07-01 00:00:00.000 | Three Level   |       570 | F        |              4 |           7 |              1 |   111311 | Fourth     |             30 |                4.2 |               6.9 | Under 40   |  25   |
|            9 | 2017-07-01 00:00:00.000 | Three Level   |       570 | F        |              4 |          10 |              1 |   111311 | Fourth     |             30 |                4.2 |              14.2 | Under 40   |  32.4 |
|           10 | 2017-07-01 00:00:00.000 | Three Level   |       575 | M        |              4 |           2 |              1 |   115711 | Fourth     |             20 |                2.5 |               8.4 | Under 40   |  26.6 |
|           12 | 2017-07-01 00:00:00.000 | Three Level   |       615 | M        |              4 |           3 |              0 |    68096 | Third      |             30 |                4.2 |              33.7 | Over40     |  51.9 |
|           13 | 2017-07-01 00:00:00.000 | Three Level   |       615 | F        |              4 |           3 |              0 |    68096 | Third      |             20 |                2.5 |               3.9 | Under 40   |  22.1 |
|           28 | 2017-07-01 00:00:00.000 | Three Level   |       535 | M        |              4 |          27 |              0 |    33912 | Second     |             20 |                2.5 |              11   | Under 40   |  29.2 |
|           29 | 2017-07-01 00:00:00.000 | Three Level   |       535 | M        |              4 |          27 |              0 |    33912 | Second     |             20 |                2.5 |              13.6 | Under 40   |  31.7 |
|           30 | 2017-07-01 00:00:00.000 | Three Level   |       535 | F        |              4 |          27 |              0 |    33912 | Second     |             10 |                0.5 |               3.5 | Under 40   |  21.7 |
|           31 | 2017-07-01 00:00:00.000 | Three Level   |       535 | F        |              4 |          27 |              0 |    33912 | Second     |             20 |                2.5 |               6.9 | Under 40   |  25.1 |
|           32 | 2017-07-01 00:00:00.000 | Three Level   |       535 | F        |              4 |          27 |              0 |    33912 | Second     |             30 |                4.2 |              15.8 | Under 40   |  34   |

 


tables: name: HumanResources DimGender
data: HumanResources DimGender.csv
name: HumanResources DimJob
data: HumanResources DimJob.csv
name: HumanResources DimManager
data: HumanResources DimManager.csv
name: HumanResources DimOrganization
data: HumanResources DimOrganization.csv
name: HumanResources DimRatingScale
data: HumanResources DimRatingScale.csv
name: HumanResources DimReviewRating
data: HumanResources DimReviewRating.csv
name: HumanResources DimSalariedFlag
data: HumanResources DimSalariedFlag.csv
name: HumanResources FactEmployeeReview
data: HumanResources FactEmployeeReview.csv
label: HumanResources FactEmployeeReview
Gender
HumanResources DimGender
Gender
HumanResources FactEmployeeReview
JobCode
HumanResources DimJob
JobCode
HumanResources FactEmployeeReview
ManagerID
HumanResources DimManager
ManagerID
HumanResources FactEmployeeReview
Organization
HumanResources DimOrganization
Organization
HumanResources FactEmployeeReview
RatingScale
HumanResources DimRatingScale
RatingScale
HumanResources FactEmployeeReview
ReviewRating
HumanResources DimReviewRating
ReviewRating
HumanResources FactEmployeeReview
SalariedFlag
HumanResources DimSalariedFlag
SalariedFlag
output: {
    "joins": [
        {
            "from_table": "HumanResources FactEmployeeReview",
            "from_column": "Gender",
            "to_table": "HumanResources DimGender",
            "to_column": "Gender"
        },
        {
            "from_table": "HumanResources FactEmployeeReview",
            "from_column": "JobCode",
            "to_table": "HumanResources DimJob",
            "to_column": "JobCode"
        },
        {
            "from_table": "HumanResources FactEmployeeReview",
            "from_column": "ManagerID",
            "to_table": "HumanResources DimManager",
            "to_column": "ManagerID"
        },
        {
            "from_table": "HumanResources FactEmployeeReview",
            "from_column": "Organization",
            "to_table": "HumanResources DimOrganization",
            "to_column": "Organization"
        },
        {
            "from_table": "HumanResources FactEmployeeReview",
            "from_column": "RatingScale",
            "to_table": "HumanResources DimRatingScale",
            "to_column": "RatingScale"
        },
        {
            "from_table": "HumanResources FactEmployeeReview",
            "from_column": "ReviewRating",
            "to_table": "HumanResources DimReviewRating",
            "to_column": "ReviewRating"
        },
        {
            "from_table": "HumanResources FactEmployeeReview",
            "from_column": "SalariedFlag",
            "to_table": "HumanResources DimSalariedFlag",
            "to_column": "SalariedFlag"
        }
    ]
}