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: Dim_Accident_Severity
|   SKAccident_Severity | Description   |
|----------------------:|:--------------|
|                     1 | Fatal         |
|                     2 | Serious       |
|                     3 | Slight        |


Table: Dim_Age_Group
|   SKAge_Group | Description           |
|--------------:|:----------------------|
|             1 | Children: 0 - 15      |
|             2 | Young adult: 15 - 17  |
|             3 | Adult: 15 - 59        |
|             4 | 60 and over: 60 - ... |


Table: Dim_Casualties_Severity
|   SKCasualty_Severity | Description   |
|----------------------:|:--------------|
|                     1 | Fatal         |
|                     2 | Serious       |
|                     3 | Slight        |


Table: Dim_Casualty_Type
|   SKCasualty_Type | Description                                               |
|------------------:|:----------------------------------------------------------|
|                 1 | Pedestrian                                                |
|                 2 | Cyclist                                                   |
|                 3 | Motorcycle 50cc and under rider or passenger              |
|                 4 | Motorcycle 125cc and under rider or passenger             |
|                 5 | Motorcycle over 125cc and up to 500cc rider or  passenger |
|                 6 | Motorcycle over 500cc rider or passenger                  |
|                 7 | Taxi/Private hire car occupant                            |
|                 8 | Car occupant                                              |
|                 9 | Minibus (8 - 16 passenger seats) occupant                 |
|                10 | Bus or coach occupant (17 or more pass seats)             |


Table: Dim_Date
|   SKDate |   Year_ |   Quarter_ |   Month_ | Day_                    | create_date             | update_date             |
|---------:|--------:|-----------:|---------:|:------------------------|:------------------------|:------------------------|
|     3104 |    2011 |          3 |        7 | 2011-07-01 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |
|     3105 |    2011 |          3 |        7 | 2011-07-02 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |
|     3106 |    2011 |          3 |        7 | 2011-07-03 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |
|     3107 |    2011 |          3 |        7 | 2011-07-04 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |
|     3108 |    2011 |          3 |        7 | 2011-07-05 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |
|     3109 |    2011 |          3 |        7 | 2011-07-06 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |
|     3110 |    2011 |          3 |        7 | 2011-07-07 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |
|     3111 |    2011 |          3 |        7 | 2011-07-08 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |
|     3112 |    2011 |          3 |        7 | 2011-07-09 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |
|     3113 |    2011 |          3 |        7 | 2011-07-10 00:00:00.000 | 2021-12-06 20:11:27.796 | 2021-12-06 20:11:27.796 |


Table: Dim_Date_Question6
|   SKDate |   Year_ |   Quarter_ |   Month_ | Day_                    | create_date             | update_date             |
|---------:|--------:|-----------:|---------:|:------------------------|:------------------------|:------------------------|
|     2374 |    2013 |          3 |        7 | 2013-07-01 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.210 |
|     2375 |    2013 |          3 |        7 | 2013-07-02 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.213 |
|     2376 |    2013 |          3 |        7 | 2013-07-03 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.213 |
|     2377 |    2013 |          3 |        7 | 2013-07-04 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.213 |
|     2378 |    2013 |          3 |        7 | 2013-07-05 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.216 |
|     2379 |    2013 |          3 |        7 | 2013-07-06 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.216 |
|     2380 |    2013 |          3 |        7 | 2013-07-07 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.220 |
|     2381 |    2013 |          3 |        7 | 2013-07-08 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.220 |
|     2382 |    2013 |          3 |        7 | 2013-07-09 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.220 |
|     2383 |    2013 |          3 |        7 | 2013-07-10 00:00:00.000 | 2021-12-06 17:26:36.063 | 2021-12-06 18:00:44.220 |


Table: Dim_Time_Of_Day
|   SKTime_Of_Day | Description           |
|----------------:|:----------------------|
|               1 | Morning: 5am - 12pm   |
|               2 | Afternoon: 12pm - 5pm |
|               3 | Evening: 5pm - 9pm    |
|               4 | Midnight: 9pm - 5am   |


Table: Fact_Table
|   SKFact |   SKAccident_Severity |   SKDate |   SKTime_Of_Day |   Number_of_Accidents | create_date             | update_date             |
|---------:|----------------------:|---------:|----------------:|----------------------:|:------------------------|:------------------------|
|    10181 |                     1 |     2923 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |
|    10182 |                     1 |     2928 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |
|    10183 |                     1 |     2929 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |
|    10184 |                     1 |     2930 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |
|    10186 |                     1 |     2932 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |
|    10187 |                     1 |     2933 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |
|    10188 |                     1 |     2936 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |
|    10189 |                     1 |     2938 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |
|    10191 |                     1 |     2941 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |
|    10192 |                     1 |     2942 |               1 |                     1 | 2021-12-06 20:11:53.406 | 2021-12-06 20:11:53.406 |


Table: Fact_Table_Question6
|   SKFact |   SKCasualty_Severity |   SKCasualty_Type |   SKDate |   SKAge_Group |   Number_of_Casualties | create_date             | update_date             |
|---------:|----------------------:|------------------:|---------:|--------------:|-----------------------:|:------------------------|:------------------------|
|    96947 |                     3 |                 5 |     2467 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |
|    96982 |                     3 |                 5 |     2471 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |
|    97076 |                     3 |                 5 |     2480 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |
|    97107 |                     3 |                 5 |     2483 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |
|    97117 |                     3 |                 5 |     2484 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |
|    97189 |                     3 |                 5 |     2492 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |
|    97213 |                     3 |                 5 |     2494 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |
|    97269 |                     3 |                 5 |     2500 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |
|    97352 |                     3 |                 5 |     2509 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |
|    97364 |                     3 |                 5 |     2510 |             3 |                      1 | 2021-12-06 18:01:25.643 | 2021-12-06 18:01:25.643 |


Table: Ques1_2_Dim_Casualties_Severity
|   SKCasualty_Severity | Description   |
|----------------------:|:--------------|
|                     1 | Fatal         |
|                     2 | Serious       |
|                     3 | Slight        |


Table: Ques1_2_Dim_Date
|   SKDate |   Year_ |   Quarter_ |   Month_ | Day_                    | create_date             | update_date             |
|---------:|--------:|-----------:|---------:|:------------------------|:------------------------|:------------------------|
|      182 |    2011 |          3 |        7 | 2011-07-01 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |
|      183 |    2011 |          3 |        7 | 2011-07-02 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |
|      184 |    2011 |          3 |        7 | 2011-07-03 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |
|      185 |    2011 |          3 |        7 | 2011-07-04 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |
|      186 |    2011 |          3 |        7 | 2011-07-05 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |
|      187 |    2011 |          3 |        7 | 2011-07-06 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |
|      188 |    2011 |          3 |        7 | 2011-07-07 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |
|      189 |    2011 |          3 |        7 | 2011-07-08 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |
|      190 |    2011 |          3 |        7 | 2011-07-09 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |
|      191 |    2011 |          3 |        7 | 2011-07-10 00:00:00.000 | 2021-12-07 09:32:52.706 | 2021-12-07 09:32:52.706 |


Table: Ques1_2_Dim_Local_Authority_District
|   SKLocal_Authority_District |   Code | Description   |
|-----------------------------:|-------:|:--------------|
|                            1 |      1 | Westminster   |
|                            2 |      2 | Camden        |
|                            3 |      3 | Islington     |
|                            4 |      4 | Hackney       |
|                            5 |      5 | Tower Hamlets |
|                            6 |      6 | Greenwich     |
|                            7 |      7 | Lewisham      |
|                            8 |      8 | Southwark     |
|                            9 |      9 | Lambeth       |
|                           10 |     10 | Wandsworth    |


Table: Ques1_2_Fact_Table
|   SKFact |   SKCasualty_Severity |   SKDate |   SKLocal_Authority_District |   Number_of_Casualities | create_date             | update_date             |
|---------:|----------------------:|---------:|-----------------------------:|------------------------:|:------------------------|:------------------------|
|     4078 |                     3 |      247 |                           81 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |
|     4079 |                     3 |      244 |                          273 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |
|     4082 |                     3 |      612 |                          159 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |
|     4083 |                     3 |      979 |                          109 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |
|     4084 |                     3 |      978 |                          173 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |
|     4085 |                     3 |     1345 |                          123 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |
|     4086 |                     3 |     1342 |                          315 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |
|     4087 |                     3 |      365 |                          342 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |
|     4089 |                     3 |     1099 |                          242 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |
|     4090 |                     3 |      121 |                          333 |                       1 | 2021-12-07 09:33:46.466 | 2021-12-07 09:33:46.466 |


Table: Ques3_Dim_Age_Band
|   SKAge_Band | Description   |
|-------------:|:--------------|
|            1 | 0 - 5         |
|            2 | 6 - 10        |
|            3 | 11 - 15       |
|            4 | 16 - 20       |
|            5 | 21 - 25       |
|            6 | 26 - 35       |
|            7 | 36 - 45       |
|            8 | 46 - 55       |
|            9 | 56 - 65       |
|           10 | 66 - 75       |


Table: Ques3_Dim_Casualties_Severity
|   SKCasualty_Severity | Description   |
|----------------------:|:--------------|
|                     1 | Fatal         |
|                     2 | Serious       |
|                     3 | Slight        |


Table: Ques3_Dim_Casualty_Type
|   SKCasualty_Type | Description                                               |
|------------------:|:----------------------------------------------------------|
|                 1 | Pedestrian                                                |
|                 2 | Cyclist                                                   |
|                 3 | Motorcycle 50cc and under rider or passenger              |
|                 4 | Motorcycle 125cc and under rider or passenger             |
|                 5 | Motorcycle over 125cc and up to 500cc rider or  passenger |
|                 6 | Motorcycle over 500cc rider or passenger                  |
|                 7 | Taxi/Private hire car occupant                            |
|                 8 | Car occupant                                              |
|                 9 | Minibus (8 - 16 passenger seats) occupant                 |
|                10 | Bus or coach occupant (17 or more pass seats)             |


Table: Ques3_Dim_Date
|   SKDate |   Year_ |   Quarter_ |   Month_ | Day_                    | create_date             | update_date             |
|---------:|--------:|-----------:|---------:|:------------------------|:------------------------|:------------------------|
|      182 |    2011 |          3 |        7 | 2011-07-01 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.096 |
|      183 |    2011 |          3 |        7 | 2011-07-02 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.096 |
|      184 |    2011 |          3 |        7 | 2011-07-03 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.100 |
|      185 |    2011 |          3 |        7 | 2011-07-04 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.100 |
|      186 |    2011 |          3 |        7 | 2011-07-05 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.100 |
|      187 |    2011 |          3 |        7 | 2011-07-06 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.103 |
|      188 |    2011 |          3 |        7 | 2011-07-07 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.103 |
|      189 |    2011 |          3 |        7 | 2011-07-08 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.106 |
|      190 |    2011 |          3 |        7 | 2011-07-09 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.106 |
|      191 |    2011 |          3 |        7 | 2011-07-10 00:00:00.000 | 2021-12-06 10:26:57.886 | 2021-12-06 10:42:46.110 |


Table: Ques3_Dim_Gender
|   SKGender | Description                  |
|-----------:|:-----------------------------|
|          1 | Male                         |
|          2 | Female                       |
|          3 | Not known                    |
|          4 | Data missing or out of range |


Table: Ques3_Fact_Table
|   SKFact |   SKCasualty_Type |   SKDate |   SKGender |   SKAge_Band |   SKCasualty_Severity |   Number_of_Casualties | create_date             | update_date             |
|---------:|------------------:|---------:|-----------:|-------------:|----------------------:|-----------------------:|:------------------------|:------------------------|
|    97765 |                 1 |      875 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |
|    97775 |                 1 |      876 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |
|    97801 |                 1 |      878 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |
|    97836 |                 1 |      881 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |
|    97849 |                 1 |      882 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |
|    97872 |                 1 |      884 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |
|    97939 |                 1 |      889 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |
|    97956 |                 1 |      890 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |
|    97976 |                 1 |      892 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |
|    98056 |                 1 |      897 |          1 |            4 |                     3 |                      1 | 2021-12-06 10:43:40.776 | 2021-12-06 10:43:40.776 |

 


tables: name: Dim_Accident_Severity
data: Dim_Accident_Severity.csv
name: Dim_Age_Group
data: Dim_Age_Group.csv
name: Dim_Casualties_Severity
data: Dim_Casualties_Severity.csv
name: Dim_Casualty_Type
data: Dim_Casualty_Type.csv
name: Dim_Date
data: Dim_Date.csv
name: Dim_Date_Question6
data: Dim_Date_Question6.csv
name: Dim_Time_Of_Day
data: Dim_Time_Of_Day.csv
name: Fact_Table
data: Fact_Table.csv
name: Fact_Table_Question6
data: Fact_Table_Question6.csv
name: Ques1_2_Dim_Casualties_Severity
data: Ques1_2_Dim_Casualties_Severity.csv
name: Ques1_2_Dim_Date
data: Ques1_2_Dim_Date.csv
name: Ques1_2_Dim_Local_Authority_District
data: Ques1_2_Dim_Local_Authority_District.csv
name: Ques1_2_Fact_Table
data: Ques1_2_Fact_Table.csv
name: Ques3_Dim_Age_Band
data: Ques3_Dim_Age_Band.csv
name: Ques3_Dim_Casualties_Severity
data: Ques3_Dim_Casualties_Severity.csv
name: Ques3_Dim_Casualty_Type
data: Ques3_Dim_Casualty_Type.csv
name: Ques3_Dim_Date
data: Ques3_Dim_Date.csv
name: Ques3_Dim_Gender
data: Ques3_Dim_Gender.csv
name: Ques3_Fact_Table
data: Ques3_Fact_Table.csv
label: Fact_Table
SKDate
Dim_Date
SKDate
Fact_Table
SKAccident_Severity
Dim_Accident_Severity
SKAccident_Severity
Fact_Table
SKTime_Of_Day
Dim_Time_Of_Day
SKTime_Of_Day
Fact_Table_Question6
SKAge_Group
Dim_Age_Group
SKAge_Group
Fact_Table_Question6
SKCasualty_Severity
Dim_Casualties_Severity
SKCasualty_Severity
Fact_Table_Question6
SKCasualty_Type
Dim_Casualty_Type
SKCasualty_Type
Fact_Table_Question6
SKDate
Dim_Date_Question6
SKDate
Ques3_Fact_Table
SKAge_Band
Ques3_Dim_Age_Band
SKAge_Band
Ques3_Fact_Table
SKCasualty_Severity
Ques3_Dim_Casualties_Severity
SKCasualty_Severity
Ques3_Fact_Table
SKCasualty_Type
Ques3_Dim_Casualty_Type
SKCasualty_Type
Ques3_Fact_Table
SKDate
Ques3_Dim_Date
SKDate
Ques3_Fact_Table
SKGender
Ques3_Dim_Gender
SKGender
Ques1_2_Fact_Table
SKCasualty_Severity
Ques1_2_Dim_Casualties_Severity
SKCasualty_Severity
Ques1_2_Fact_Table
SKDate
Ques1_2_Dim_Date
SKDate
Ques1_2_Fact_Table
SKLocal_Authority_District
Ques1_2_Dim_Local_Authority_District
SKLocal_Authority_District
output: {
    "joins": [
        {
            "from_table": "Fact_Table",
            "from_column": "SKDate",
            "to_table": "Dim_Date",
            "to_column": "SKDate"
        },
        {
            "from_table": "Fact_Table",
            "from_column": "SKAccident_Severity",
            "to_table": "Dim_Accident_Severity",
            "to_column": "SKAccident_Severity"
        },
        {
            "from_table": "Fact_Table",
            "from_column": "SKTime_Of_Day",
            "to_table": "Dim_Time_Of_Day",
            "to_column": "SKTime_Of_Day"
        },
        {
            "from_table": "Fact_Table_Question6",
            "from_column": "SKAge_Group",
            "to_table": "Dim_Age_Group",
            "to_column": "SKAge_Group"
        },
        {
            "from_table": "Fact_Table_Question6",
            "from_column": "SKCasualty_Severity",
            "to_table": "Dim_Casualties_Severity",
            "to_column": "SKCasualty_Severity"
        },
        {
            "from_table": "Fact_Table_Question6",
            "from_column": "SKCasualty_Type",
            "to_table": "Dim_Casualty_Type",
            "to_column": "SKCasualty_Type"
        },
        {
            "from_table": "Fact_Table_Question6",
            "from_column": "SKDate",
            "to_table": "Dim_Date_Question6",
            "to_column": "SKDate"
        },
        {
            "from_table": "Ques3_Fact_Table",
            "from_column": "SKAge_Band",
            "to_table": "Ques3_Dim_Age_Band",
            "to_column": "SKAge_Band"
        },
        {
            "from_table": "Ques3_Fact_Table",
            "from_column": "SKCasualty_Severity",
            "to_table": "Ques3_Dim_Casualties_Severity",
            "to_column": "SKCasualty_Severity"
        },
        {
            "from_table": "Ques3_Fact_Table",
            "from_column": "SKCasualty_Type",
            "to_table": "Ques3_Dim_Casualty_Type",
            "to_column": "SKCasualty_Type"
        },
        {
            "from_table": "Ques3_Fact_Table",
            "from_column": "SKDate",
            "to_table": "Ques3_Dim_Date",
            "to_column": "SKDate"
        },
        {
            "from_table": "Ques3_Fact_Table",
            "from_column": "SKGender",
            "to_table": "Ques3_Dim_Gender",
            "to_column": "SKGender"
        },
        {
            "from_table": "Ques1_2_Fact_Table",
            "from_column": "SKCasualty_Severity",
            "to_table": "Ques1_2_Dim_Casualties_Severity",
            "to_column": "SKCasualty_Severity"
        },
        {
            "from_table": "Ques1_2_Fact_Table",
            "from_column": "SKDate",
            "to_table": "Ques1_2_Dim_Date",
            "to_column": "SKDate"
        },
        {
            "from_table": "Ques1_2_Fact_Table",
            "from_column": "SKLocal_Authority_District",
            "to_table": "Ques1_2_Dim_Local_Authority_District",
            "to_column": "SKLocal_Authority_District"
        }
    ]
}