Task: Functional-Dependency (source dataset: Auto-Relate)

Given a table represented shown below, your task is to determine functional dependencies that exist in the table. Recall that a functional dependency is a relationship where the value of one attribute (or a set of attributes), known as the determinant columns, can uniquely determines the value of another attribute, known as the dependent columns (e.g., student-ID => student-Name, car-model => car-make, employee-ID => department, etc.).

Instructions:
Analyze the provided table below, identify all functional dependencies that should semantically hold in the table. Do not produce spurious relationships that not semantically meaningful.

No explanation, format the output as a JSON object:{"Functional-Dependency": <list of functional dependencies>}. Each functional dependency should be represented as [<determinant column>, <dependent column>]

Input Table:
|   OrderNumber | OrderDate               |   Customer Name Index | Channel    | Currency Code   | Code     |   Region ID |   Product ID |   Quantity |   Unit Price |    Unit Cost |   Revenue |   Customer Index | Customer Names      |
|--------------:|:------------------------|----------------------:|:-----------|:----------------|:---------|------------:|-------------:|-----------:|-------------:|-------------:|----------:|-----------------:|:--------------------|
|         19700 | 2019-12-22 00:00:00.000 |                    68 | Import     | Euro            | AXT87U   |          44 |            1 |          6 |       2298.1 |     1654.63  |   13788.6 |               68 | Peter  Hodges       |
|         15071 | 2019-12-02 00:00:00.000 |                    17 | Industries | Euro            | INX005RT |          65 |            7 |          7 |       5165.7 |     2066.28  |   36159.9 |               17 | Jenny  Garcia       |
|         15821 | 2019-01-30 00:00:00.000 |                    26 | Industries | Euro            | INX005RT |          32 |           19 |          9 |       1976.5 |     1067.31  |   17788.5 |               26 | Cassandra  Franklin |
|         16851 | 2019-04-28 00:00:00.000 |                     8 | Industries | Euro            | ZAQ890   |          42 |           20 |         11 |       6123.8 |     3123.14  |   67361.8 |                8 | Sylvester  Morales  |
|         18955 | 2019-10-19 00:00:00.000 |                   166 | Industries | Euro            | INX005RT |          16 |           13 |          8 |       5326.5 |     2929.58  |   42612   |              166 | Patty  Thompson     |
|         12233 | 2019-04-12 00:00:00.000 |                   128 | Industries | Euro            | INX005RT |           7 |           16 |          5 |       2331.6 |     1468.91  |   11658   |              128 | Della  Jensen       |
|         13185 | 2019-07-03 00:00:00.000 |                   136 | Industries | Euro            | INX005RT |           7 |           25 |         10 |       3886   |     2137.3   |   38860   |              136 | Pauline  Beck       |
|         20572 | 2020-03-05 00:00:00.000 |                   124 | Import     | Euro            | AXT87U   |          32 |            5 |          6 |       1112.2 |      556.1   |    6673.2 |              124 | Carla  Mccormick    |
|         17337 | 2019-06-09 00:00:00.000 |                   135 | Industries | Euro            | INX005RT |          37 |            2 |          8 |       3999.9 |     2199.95  |   31999.2 |              135 | Jenny  Garcia       |
|         13988 | 2019-09-02 00:00:00.000 |                    54 | Import     | Euro            | INX005RT |          43 |            5 |          7 |       1212.7 |      715.493 |    8488.9 |               54 | Jenny  Garcia       |
|         18355 | 2019-08-31 00:00:00.000 |                    24 | Industries | Euro            | ZAQ890   |          22 |           26 |         10 |       3872.6 |     2323.56  |   38726   |               24 | Elaine  Ellis       |
|         17974 | 2019-07-30 00:00:00.000 |                    50 | Industries | Euro            | INX005RT |          54 |            6 |          9 |       1768.8 |     1149.72  |   15919.2 |               50 | Eric  Rose          |
|         20428 | 2020-02-23 00:00:00.000 |                    38 | Import     | Euro            | AXT87U   |          36 |           28 |         10 |        254.6 |      150.214 |    2546   |               38 | Robert  Munoz       |
|         14525 | 2019-10-19 00:00:00.000 |                   133 | Industries | Euro            | INX005RT |          13 |           13 |          9 |        716.9 |      379.957 |    6452.1 |              133 | Cindy  Becker       |
|         13059 | 2019-06-22 00:00:00.000 |                   154 | Export     | Euro            | INX005RT |           2 |            6 |          9 |       3115.5 |     1682.37  |   28039.5 |              154 | Sandra  Floyd       |
|         19427 | 2019-11-28 00:00:00.000 |                   126 | Industries | Euro            | AXT87U   |          48 |           25 |         11 |       1708.5 |     1178.87  |   18793.5 |              126 | Jaime  Pearson      |
|         14689 | 2019-11-01 00:00:00.000 |                   118 | Industries | Euro            | ZAQ890   |          35 |           25 |          8 |       3517.5 |     2743.65  |   28140   |              118 | Tracy  Reed         |
|         19054 | 2019-10-29 00:00:00.000 |                    16 | Industries | Euro            | AXT87U   |          19 |            3 |         11 |       2720.2 |     2176.16  |   29922.2 |               16 | Rachel  Gomez       |
|         15968 | 2019-02-11 00:00:00.000 |                    79 | Industries | Euro            | INX005RT |          11 |            5 |         10 |       1058.6 |      624.574 |   10586   |               79 | Isabel  Cross       |
|         15330 | 2019-12-22 00:00:00.000 |                    59 | Industries | Euro            | INX005RT |          19 |            5 |         11 |       1072   |      450.24  |   11792   |               59 | Rachel  Gomez       |
|         15848 | 2019-02-02 00:00:00.000 |                   141 | Export     | Euro            | INX005RT |          41 |            8 |          5 |       5902.7 |     4958.27  |   29513.5 |              141 | Billie  Chandler    |
|         17330 | 2019-06-09 00:00:00.000 |                   128 | Import     | Euro            | ZAQ890   |          57 |           20 |         10 |       1949.7 |     1072.34  |   19497   |              128 | Della  Jensen       |
|         13136 | 2019-06-28 00:00:00.000 |                   131 | Import     | Euro            | NVG256YT |          59 |           12 |          8 |        877.7 |      351.08  |    7021.6 |              131 | Cindy  Becker       |
|         18032 | 2019-08-05 00:00:00.000 |                   128 | Import     | Euro            | ZAQ890   |          50 |           26 |         11 |       2298.1 |     1034.14  |   25279.1 |              128 | Della  Jensen       |
|         20638 | 2020-03-11 00:00:00.000 |                   109 | Import     | Euro            | NVG256YT |          50 |            7 |         10 |       1976.5 |     1581.2   |   19765   |              109 | Willie  Vega        |
|         19522 | 2019-12-06 00:00:00.000 |                    25 | Import     | Euro            | INX005RT |          60 |           15 |         12 |       1159.1 |      707.051 |   13909.2 |               25 | Beth  Tucker        |
|         13153 | 2019-06-30 00:00:00.000 |                    35 | Industries | Euro            | INX005RT |          19 |            2 |          7 |       1172.5 |      621.425 |    8207.5 |               35 | Arturo  Francis     |
|         15335 | 2019-12-22 00:00:00.000 |                    94 | Industries | Euro            | INX005RT |          45 |           30 |          5 |       1199.3 |      791.538 |    5996.5 |               94 | Paulette  Spencer   |
|         13730 | 2019-08-12 00:00:00.000 |                   113 | Import     | Euro            | INX005RT |          39 |           13 |          7 |       5688.3 |     2502.85  |   39818.1 |              113 | Ivan  Adkins        |
|         15052 | 2019-11-30 00:00:00.000 |                    22 | Industries | Euro            | NVG256YT |          41 |           17 |          5 |        241.2 |      159.192 |    1206   |               22 | Ben  Perez          |
|         21277 | 2020-05-01 00:00:00.000 |                    96 | Export     | Euro            | NVG256YT |          45 |           18 |          7 |       1031.8 |      680.988 |    7222.6 |               96 | Allan  Ramos        |
|         11378 | 2019-02-01 00:00:00.000 |                   146 | Import     | Euro            | NVG256YT |          66 |            9 |         11 |       1011.7 |      789.126 |   11128.7 |              146 | Christina  Fuller   |
|         11722 | 2019-03-01 00:00:00.000 |                   162 | Industries | Euro            | INX005RT |          40 |           15 |         10 |        167.5 |      137.35  |    1675   |              162 | Robert  Munoz       |
|         20844 | 2020-03-28 00:00:00.000 |                     7 | Import     | Euro            | NVG256YT |          64 |            5 |          5 |        207.7 |      168.237 |    1038.5 |                7 | Billie  Chandler    |
|         17238 | 2019-05-31 00:00:00.000 |                   109 | Industries | Euro            | ZAQ890   |           3 |           25 |          5 |       1125.6 |      630.336 |    5628   |              109 | Willie  Vega        |
|         11445 | 2019-02-07 00:00:00.000 |                   143 | Industries | Euro            | INX005RT |          48 |           23 |          7 |        730.3 |      496.604 |    5112.1 |              143 | Dan  Peterson       |
|         11450 | 2019-02-07 00:00:00.000 |                   123 | Industries | Euro            | AXT87U   |          31 |            4 |         10 |        777.2 |      512.952 |    7772   |              123 | Max  Rodgers        |
|         14738 | 2019-11-05 00:00:00.000 |                   101 | Industries | Euro            | INX005RT |           9 |           28 |          6 |       1688.4 |     1435.14  |   10130.4 |              101 | Austin  Reynolds    |
|         16003 | 2019-02-14 00:00:00.000 |                   172 | Industries | Euro            | INX005RT |          49 |           13 |          9 |        998.3 |      718.776 |    8984.7 |              172 | Shari  Silva        |
|         12460 | 2019-05-02 00:00:00.000 |                    68 | Export     | Euro            | INX005RT |          26 |            4 |          5 |       1045.2 |      606.216 |    5226   |               68 | Peter  Hodges       |
|         11969 | 2019-03-21 00:00:00.000 |                   124 | Industries | Euro            | INX005RT |          60 |            9 |          9 |       1219.4 |      695.058 |   10974.6 |              124 | Carla  Mccormick    |
|         20793 | 2020-03-23 00:00:00.000 |                    77 | Import     | Euro            | NVG256YT |          55 |           14 |         11 |       2586.2 |     1965.51  |   28448.2 |               77 | Andrew  Meyer       |
|         13867 | 2019-08-23 00:00:00.000 |                    22 | Import     | Euro            | ZAQ890   |           6 |           12 |         10 |       3979.8 |     3303.23  |   39798   |               22 | Ben  Perez          |
|         13155 | 2019-06-30 00:00:00.000 |                    93 | Import     | Euro            | INX005RT |          38 |            4 |         11 |        187.6 |      148.204 |    2063.6 |               93 | Edwin  Malone       |
|         14311 | 2019-10-01 00:00:00.000 |                    48 | Import     | Euro            | INX005RT |          62 |            6 |         11 |       1072   |      707.52  |   11792   |               48 | Bobbie  Ryan        |
|         16240 | 2019-03-07 00:00:00.000 |                    57 | Import     | Euro            | ZAQ890   |          35 |           13 |          8 |       2552.7 |     1276.35  |   20421.6 |               57 | Max  Rodgers        |
|         11389 | 2019-02-02 00:00:00.000 |                   119 | Import     | Euro            | AXT87U   |          11 |            3 |         12 |       1889.4 |      906.912 |   22672.8 |              119 | Rachel  Gomez       |
|         21552 | 2020-05-26 00:00:00.000 |                    27 | Import     | Euro            | NVG256YT |          20 |           18 |         12 |       3932.9 |     2477.73  |   47194.8 |               27 | Colleen  Warren     |
|         16957 | 2019-05-08 00:00:00.000 |                   102 | Export     | Euro            | ZAQ890   |          26 |           26 |         12 |       1018.4 |      672.144 |   12220.8 |              102 | Dan  Peterson       |
|         19409 | 2019-11-27 00:00:00.000 |                     4 | Industries | Euro            | AXT87U   |           7 |            4 |          8 |       2405.3 |     1635.6   |   19242.4 |                4 | Kyle  Carr          |



label: Customer Name Index
Customer Index
Customer Name Index
Customer Names
output: {"Functional-Dependency": [["Customer Name Index", "Customer Index"], ["Customer Name Index", "Customer Names"]]}
labeled_fds: Customer Name Index
Customer Index
Customer Name Index
Customer Names
 Unit Cost
OrderNumber
 Unit Cost
OrderDate
 Unit Cost
Code
 Unit Cost
Product ID
 Unit Cost
Quantity
 Unit Cost
Unit Price
 Unit Cost
Customer Names
Revenue
Customer Index
source: $MMTU_HOME/resources/Relationship-finding/FD/221101600