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: DAX_Measures



Table: DimCourse
| CourseID      | Coursename             |   Duration |
|:--------------|:-----------------------|-----------:|
| MSBI-F        | MSBI Fast Track        |         30 |
| MSBI-N        | MSBI Normal Track      |         50 |
| MSBI-C        | MSBI Customized        |         20 |
| Teradata-F    | Teradata Fast Track    |         30 |
| Teradata-N    | Teradata Normal Track  |         40 |
| Teradata-C    | Teradata Customized    |         20 |
| Power BI-F    | POWER BI Fast Track    |         20 |
| Power BI-N    | POWER BI Fast Track    |         30 |
| Power BI-C    | Power BI Customized    |         20 |
| Informatica-F | Informatica Fast Track |         30 |


Table: DimCourseMode
| ModeID     | Description                 |
|:-----------|:----------------------------|
| Online     | Connect through zoom link   |
| Classroom  | On Premises Area            |
| Customized | Online or OnPremise or Home |


Table: DimDate
| Date                    |   Year |   Quarter |   Month | Year_Month   |
|:------------------------|-------:|----------:|--------:|:-------------|
| 2017-01-01 00:00:00.000 |   2017 |         1 |       1 | 2017-January |
| 2017-01-02 00:00:00.000 |   2017 |         1 |       1 | 2017-January |
| 2017-01-03 00:00:00.000 |   2017 |         1 |       1 | 2017-January |
| 2017-01-04 00:00:00.000 |   2017 |         1 |       1 | 2017-January |
| 2017-01-05 00:00:00.000 |   2017 |         1 |       1 | 2017-January |
| 2017-01-06 00:00:00.000 |   2017 |         1 |       1 | 2017-January |
| 2017-01-07 00:00:00.000 |   2017 |         1 |       1 | 2017-January |
| 2017-01-08 00:00:00.000 |   2017 |         1 |       1 | 2017-January |
| 2017-01-09 00:00:00.000 |   2017 |         1 |       1 | 2017-January |
| 2017-01-10 00:00:00.000 |   2017 |         1 |       1 | 2017-January |


Table: DimGeography
| GeographyID   | LocID    | Statename      | CountryName   | ContinentName   |
|:--------------|:---------|:---------------|:--------------|:----------------|
| H01           | HYD      | Telangana      | India         | Asia            |
| V01           | VIZAG    | Andhra Pradesh | India         | Asia            |
| B01           | BZA      | Andhra Pradesh | India         | Asia            |
| W01           | Warangal | Telangana      | Indi`         | Asia            |


Table: DimInstitute
| InstituteID   | Institutename               |
|:--------------|:----------------------------|
| Vinay Tech    | sri vinay tech house        |
| MSBI Tech     | MSBI Training Institute     |
| Power BI Tech | Power Bi Training Institute |


Table: DimLocation
| LocID   | Locationname   | Address                                       | District       | State     |
|:--------|:---------------|:----------------------------------------------|:---------------|:----------|
| HYD     | Hyderabad      | 506B, Nilgiri Bock,Aditya Enclave, Mytrivanam | Rangareddi     | Telangana |
| VIZAG   | Visakhapatnam  | 602, Sri Nilayam, Near Gayatri College, Vizag | Vishakhapatnam | AP        |
| BZA     | Vijayawada     | Plot no:62, Near PVR, Bandar Road, Vijayawada | Krishna        | AP        |
| WRNGL   | Warangal       | 506, Ghattam Road                             | Warangal       | Telangana |
| KHM     | Khammam        | 708, Mudasir Colony                           | Khammam        | Telangana |
| NIJM    | Nijamabad      | 304, Mytri Vihar                              | Nijamabad      | Telangana |


Table: DimStudent
|   StudentID | FST_NAME   | LAST_NAME   |   EMPLOYEE_ID | CITY          | STATE_NAME   | STATE_REGION    | COUNTRY_CODE   | COUNTRY_NAME   | COUNTRY_REGION   |   ZIPCODE | CREATION_DATE       |   CREATED_BY | LAST_UPDATE_DATE    |   LAST_UPDATED_BY | START_DATE          |
|------------:|:-----------|:------------|--------------:|:--------------|:-------------|:----------------|:---------------|:---------------|:-----------------|----------:|:--------------------|-------------:|:--------------------|------------------:|:--------------------|
|        1000 | Alan       | Kirk        |             1 | Gilroy        | California   | :CA:            | US             | United States  |                  |     99999 | 26.10.2000 09:27:09 |           -1 | 11.03.2011 13:40:55 |             24438 | 26.10.2000 09:27:09 |
|        1001 | Randy      | Dalton      |             2 | Dolores       | Colorado     | :CO:            | US             | United States  |                  |     99999 | 26.10.2000 09:27:09 |         1173 | 25.01.2011 03:56:26 |              4341 | 26.10.2000 09:27:09 |
|        1002 | Lychung    | Ma          |             3 | San Jose      | California   | :CA:            | US             | United States  |                  |     99999 | 12.12.2000 10:36:25 |         1698 | 02.03.2011 11:35:42 |             12316 | 12.12.2000 10:36:25 |
|        1003 | Anthony    | Logan       |             4 | San Jose      | California   | :CA:            | US             | United States  |                  |     99999 | 15.01.2001 12:31:43 |         1173 | 19.05.2010 07:49:22 |              5826 | 15.01.2001 12:31:43 |
|        1004 | James      | Herndon     |             5 | Mountain View | California   | :CA:            | US             | United States  |                  |     99999 | 13.06.2001 10:00:39 |         2440 | 04.02.2011 17:04:10 |             15268 | 13.06.2001 10:00:39 |
|        1005 | Laura      | Mappin      |             6 | Sunnyvale     | California   | :CA:            | US             | United States  |                  |     99999 | 16.01.2002 13:22:37 |         1173 | 07.03.2011 11:05:54 |              5305 | 16.01.2002 13:22:37 |
|        1006 | Brett      | Starr       |             7 | Los Gatos     | California   | :CA:            | US             | United States  |                  |     99999 | 21.02.2002 06:01:30 |         2381 | 10.09.2010 08:59:46 |             22244 | 21.02.2002 06:01:30 |
|        1007 | Colleen    | Devine      |             8 | San Jose      | California   | :CA:            | US             | United States  |                  |     99999 | 15.08.2002 05:50:45 |         2381 | 03.04.2008 09:28:17 |              5327 | 15.08.2002 05:50:45 |
|        1008 | John       | Busco       |             9 | San Jose      | California   | :CA:            | US             | United States  |                  |     99999 | 27.03.2003 13:26:30 |         1137 | 16.07.2010 14:31:56 |             22244 | 27.03.2003 13:26:30 |
|        1009 | Harold     | Wong        |            10 | Sunnyvale     | California   | Santa Clara:CA: | US             | United States  |                  |     99999 | 14.06.2004 12:48:16 |         3428 | 19.05.2010 13:22:53 |             12205 | 14.06.2004 12:48:16 |


Table: DimUsers
|   UserID | Username      | UserDesktopName           | Email                          | ManagerID   |
|---------:|:--------------|:--------------------------|:-------------------------------|:------------|
|     1001 | Lenovo        | DESKTOP-RN4SMHT\Lenovo    | lenovo@vinaytechhouse.com      |             |
|     1002 | VINAYTCH DELL | WELCOME\DELL              | vinaytech_4@vinaytechhouse.com | 1001        |
|     1003 | Vinaytechpbi  | DESKTOP-RN4SMHT\Vinaytech | vinaytech_6@vinaytechhouse.com | 1002        |
|     1004 | Kishore       | DESKTOP-RN4SMHT\Kishore   | vinaytech_7@vinaytechhouse.com | 1003        |
|     1005 | Ramesh        | WELCOME\DELL1             | ramesh@vinaytechhouse.com      | 1002        |
|     1006 | Anudeep       | WELCOME\Anu               | jayesh@vinaytechhoue.com       | 1002        |
|     1007 | Ramesh        | Welcome\Ramesh            | ramesh@vinaytechhouse.com      | 1006        |


Table: FactPayments
| InstituteID   | CourseID    | ModeID    |   UserID | LocationID   | Enquiry_Date   |   StudentID |   Actual_Fee |   Discount_Fee |   Tax amount |   DiscountValue | Join_Date               | Course End_Date         | Date                    |
|:--------------|:------------|:----------|---------:|:-------------|:---------------|------------:|-------------:|---------------:|-------------:|----------------:|:------------------------|:------------------------|:------------------------|
| Power BI Tech | Power BI-N  | Classroom |     1003 | HYD          | 6/3/2019       |        2019 |        17000 |          15300 |          306 |            1700 | 2019-06-03 00:00:00.000 | 2019-06-03 00:00:00.000 | 2019-06-03 00:00:00.000 |
| MSBI Tech     | MSBI-F      | Online    |     1004 | HYD          | 6/3/2019       |        2019 |        18000 |          16200 |          324 |            1800 | 2019-06-03 00:00:00.000 | 2019-06-03 00:00:00.000 | 2019-06-03 00:00:00.000 |
| Power BI Tech | Power BI-F  | Classroom |     1005 | HYD          | 6/4/2019       |        2019 |        19000 |          17100 |          342 |            1900 | 2019-06-04 00:00:00.000 | 2019-06-04 00:00:00.000 | 2019-06-04 00:00:00.000 |
| Power BI Tech | POWER BI -N | Online    |     1002 | HYD          | 6/7/2019       |        2019 |        15000 |          13500 |          270 |            1500 | 2019-06-07 00:00:00.000 | 2019-06-07 00:00:00.000 | 2019-06-07 00:00:00.000 |
| MSBI Tech     | Power BI-N  | Online    |     1003 | HYD          | 7/8/2020       |        2019 |        14000 |          12600 |          252 |            1400 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 |
| MSBI Tech     | Power BI-N  | Online    |     1003 | HYD          | 7/8/2020       |        2019 |        14000 |          12600 |          252 |            1400 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 |
| MSBI Tech     | Power BI-N  | Online    |     1003 | HYD          | 7/8/2020       |        2019 |        14000 |          12600 |          252 |            1400 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 |
| MSBI Tech     | Power BI-N  | Online    |     1003 | HYD          | 7/8/2020       |        2019 |        14000 |          12600 |          252 |            1400 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 |
| MSBI Tech     | Power BI-N  | Online    |     1003 | HYD          | 7/8/2020       |        2019 |        14000 |          12600 |          252 |            1400 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 |
| MSBI Tech     | Power BI-N  | Online    |     1003 | HYD          | 7/8/2020       |        2019 |        14000 |          12600 |          252 |            1400 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 | 2020-07-08 00:00:00.000 |


Table: PaymentFlow
| Period                  | Base   |   Down |   Up |   Net Payment Flow |   Year |
|:------------------------|:-------|-------:|-----:|-------------------:|-------:|
|                         |        |      0 | 5000 |               5000 |   2017 |
| 2010-01-01 00:00:00.000 | 4497   |    503 |    0 |               -503 |   2017 |
| 2010-02-01 00:00:00.000 | 2827   |   1670 |    0 |              -1670 |   2017 |
| 2010-03-01 00:00:00.000 | 2827   |      0 | 4802 |               4802 |   2017 |
| 2010-04-01 00:00:00.000 | 6431   |   1198 |    0 |              -1198 |   2017 |
| 2010-05-01 00:00:00.000 | 2905   |   3526 |    0 |              -3526 |   2017 |
| 2010-06-01 00:00:00.000 | 2905   |      0 | 1826 |               1826 |   2017 |
| 2010-07-01 00:00:00.000 | 2447   |   2284 |    0 |              -2284 |   2017 |
| 2010-08-01 00:00:00.000 | 2447   |      0 | 3250 |               3250 |   2017 |
| 2010-09-01 00:00:00.000 | 3917   |   1780 |    0 |              -1780 |   2017 |

 


tables: name: DAX_Measures
data: DAX_Measures.csv
name: DimCourse
data: DimCourse.csv
name: DimCourseMode
data: DimCourseMode.csv
name: DimDate
data: DimDate.csv
name: DimGeography
data: DimGeography.csv
name: DimInstitute
data: DimInstitute.csv
name: DimLocation
data: DimLocation.csv
name: DimStudent
data: DimStudent.csv
name: DimUsers
data: DimUsers.csv
name: FactPayments
data: FactPayments.csv
name: PaymentFlow
data: PaymentFlow.csv
label: FactPayments
CourseID
DimCourse
CourseID
FactPayments
StudentID
DimStudent
StudentID
FactPayments
ModeID
DimCourseMode
ModeID
FactPayments
InstituteID
DimInstitute
InstituteID
DimGeography
LocID
DimLocation
LocID
FactPayments
LocationID
DimLocation
LocID
FactPayments
UserID
DimUsers
UserID
output: {
    "joins": [
        {
            "from_table": "FactPayments",
            "from_column": "CourseID",
            "to_table": "DimCourse",
            "to_column": "CourseID"
        },
        {
            "from_table": "FactPayments",
            "from_column": "StudentID",
            "to_table": "DimStudent",
            "to_column": "StudentID"
        },
        {
            "from_table": "FactPayments",
            "from_column": "ModeID",
            "to_table": "DimCourseMode",
            "to_column": "ModeID"
        },
        {
            "from_table": "FactPayments",
            "from_column": "InstituteID",
            "to_table": "DimInstitute",
            "to_column": "InstituteID"
        },
        {
            "from_table": "DimGeography",
            "from_column": "LocID",
            "to_table": "DimLocation",
            "to_column": "LocID"
        },
        {
            "from_table": "FactPayments",
            "from_column": "LocationID",
            "to_table": "DimLocation",
            "to_column": "LocID"
        },
        {
            "from_table": "FactPayments",
            "from_column": "UserID",
            "to_table": "DimUsers",
            "to_column": "UserID"
        }
    ]
}