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: coursegrade_data
|   student id |   course id |   Course Grade |
|-------------:|------------:|---------------:|
|            1 |           1 |            3   |
|            2 |           1 |            2.5 |
|            3 |           1 |            2.2 |
|            4 |           1 |            2.7 |
|            5 |           1 |            2.9 |
|            6 |           1 |            3.2 |
|            7 |           1 |            2.7 |
|            8 |           1 |            4   |
|            9 |           1 |            2.6 |
|           10 |           1 |            3.2 |


Table: course_lookup
|   course id | Course name                |
|------------:|:---------------------------|
|           1 | Lesson Planning            |
|           2 | Classroom Culture          |
|           3 | Instruction                |
|           4 | Assessing Student Learning |


Table: Descriptive_Statistics_Satis
| Descriptive Statistics     |    instruction |   operations |     tuition |   communication |   Avg_Satisfaction |
|:---------------------------|---------------:|-------------:|------------:|----------------:|-------------------:|
| 1.Mean                     |       3.93066  |    3.18028   |   3.1849    |        3.53621  |          3.45801   |
| 2. Standard Deviation      |       0.955717 |    1.05109   |   1.17577   |        1.44626  |          0.676197  |
| 3. Kurtosis                |       1.34897  |   -0.396959  |  -0.865454  |       -1.12118  |         -0.131728  |
| 4. Skewness                |      -1.10593  |   -0.181277  |  -0.0085799 |       -0.500656 |         -0.203028  |
| 5. Minimum                 |       1        |    1         |   1         |        1        |          1.25      |
| 6. Maximum                 |       5        |    5         |   5         |        5        |          5         |
| 7. Confidence Level(95.0%) |       0.073666 |    0.0810175 |   0.0906272 |        0.111477 |          0.0521208 |
| N                          |     649        |  649         | 649         |      649        |        649         |


Table: Discriptive_Statistics_Course_Grade
| Descriptive Statistics     |   Lesson Planning_Grade |   Classroom Culture_Grade |   Instruction_Grade |   Assessing Student Learning_Grade |   Total Course Grade |
|:---------------------------|------------------------:|--------------------------:|--------------------:|-----------------------------------:|---------------------:|
| 1.Mean                     |                2.78151  |                 2.77797   |           2.77057   |                          2.78937   |            2.77985   |
| 2. Standard Deviation      |                0.758713 |                 0.763272  |           0.774445  |                          0.784354  |            0.593216  |
| 3. Kurtosis                |               -0.51783  |                -0.50228   |          -0.661181  |                         -0.623437  |           -0.477846  |
| 4. Skewness                |               -0.263459 |                -0.315199  |          -0.214461  |                         -0.290279  |           -0.507799  |
| 5. Minimum                 |                0.6      |                 0.8       |           0.7       |                          0.7       |            1.2       |
| 6. Maximum                 |                4        |                 4         |           4         |                          4         |            3.95      |
| 7. Confidence Level(95.0%) |                0.058481 |                 0.0588325 |           0.0596937 |                          0.0604574 |            0.0457247 |
| N                          |              649        |               649         |         649         |                        649         |          649         |


Table: Fainal Aid_increased
|   Fainal Aid_increased |
|-----------------------:|
|                      0 |
|                      1 |
|                      2 |
|                      3 |
|                      4 |
|                      5 |
|                      6 |
|                      7 |
|                      8 |
|                      9 |


Table: questionresponse_data
|   student id |   question id |   Satisfaction Response |
|-------------:|--------------:|------------------------:|
|            1 |             1 |                       4 |
|            3 |             1 |                       4 |
|            5 |             1 |                       4 |
|            7 |             1 |                       4 |
|            8 |             1 |                       4 |
|            9 |             1 |                       4 |
|           13 |             1 |                       4 |
|           15 |             1 |                       4 |
|           16 |             1 |                       4 |
|           21 |             1 |                       4 |


Table: question_lookup
|   question id | Satisfaction_Question   |
|--------------:|:------------------------|
|             1 | instruction             |
|             2 | operations              |
|             3 | tuition                 |
|             4 | communication           |


Table: response_lookup
|   response value | response          |
|-----------------:|:------------------|
|                1 | Strongly disagree |
|                2 | Disagree          |
|                3 | Neutral           |
|                4 | Agree             |
|                5 | Strongly agree    |


Table: student_data
|   student id | degree   | campus     | sex   | person color   |   age | financialaid    |
|-------------:|:---------|:-----------|:------|:---------------|------:|:----------------|
|            6 | Masters  | California | M     | Colored        |    22 | No Aid Receives |
|           16 | Masters  | Louisiana  | F     | Colored        |    22 | Receives Aid    |
|           17 | Masters  | California | F     | Colored        |    22 | Receives Aid    |
|           20 | Masters  | Louisiana  | M     | Colored        |    22 | No Aid Receives |
|           26 | Masters  | California | F     | Colored        |    22 | Receives Aid    |
|           29 | Masters  | California | M     | Colored        |    22 | No Aid Receives |
|           30 | Masters  | Louisiana  | M     | Colored        |    22 | Receives Aid    |
|           35 | Masters  | New York   | M     | Colored        |    22 | Receives Aid    |
|           38 | Masters  | New York   | M     | Colored        |    22 | Receives Aid    |
|           41 | Masters  | New York   | F     | Colored        |    22 | No Aid Receives |

 


tables: name: coursegrade_data
data: coursegrade_data.csv
name: course_lookup
data: course_lookup.csv
name: Descriptive_Statistics_Satis
data: Descriptive_Statistics_Satis.csv
name: Discriptive_Statistics_Course_Grade
data: Discriptive_Statistics_Course_Grade.csv
name: Fainal Aid_increased
data: Fainal Aid_increased.csv
name: questionresponse_data
data: questionresponse_data.csv
name: question_lookup
data: question_lookup.csv
name: response_lookup
data: response_lookup.csv
name: student_data
data: student_data.csv
label: questionresponse_data
student id
student_data
student id
coursegrade_data
student id
student_data
student id
questionresponse_data
question id
question_lookup
question id
coursegrade_data
course id
course_lookup
course id
questionresponse_data
Satisfaction Response
response_lookup
response value
Descriptive_Statistics_Satis
Descriptive Statistics
Discriptive_Statistics_Course_Grade
Descriptive Statistics
output: {
    "joins": [
        {
            "from_table": "questionresponse_data",
            "from_column": "student id",
            "to_table": "student_data",
            "to_column": "student id"
        },
        {
            "from_table": "coursegrade_data",
            "from_column": "student id",
            "to_table": "student_data",
            "to_column": "student id"
        },
        {
            "from_table": "questionresponse_data",
            "from_column": "question id",
            "to_table": "question_lookup",
            "to_column": "question id"
        },
        {
            "from_table": "coursegrade_data",
            "from_column": "course id",
            "to_table": "course_lookup",
            "to_column": "course id"
        },
        {
            "from_table": "questionresponse_data",
            "from_column": "Satisfaction Response",
            "to_table": "response_lookup",
            "to_column": "response value"
        },
        {
            "from_table": "Descriptive_Statistics_Satis",
            "from_column": "Descriptive Statistics",
            "to_table": "Discriptive_Statistics_Course_Grade",
            "to_column": "Descriptive Statistics"
        }
    ]
}