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:
| EstimatedCloseDate      |   Opportunity ID |   Sales Stage ID |   Account ID |   Partner ID |   Product ID |   ProductRevenue |   FactoredProductRevenue | Create Date             |   Opportunity Days |   Year |   Month_Number | Month   | Name             |   Rank |   SizeID | Opportunity Size   |
|:------------------------|-----------------:|-----------------:|-------------:|-------------:|-------------:|-----------------:|-------------------------:|:------------------------|-------------------:|-------:|---------------:|:--------|:-----------------|-------:|---------:|:-------------------|
| 2015-12-31 10:59:00.000 |              328 |                1 |          253 |           22 |           18 |          5929669 |         592967           | 2014-01-06 00:00:00.000 |            724.458 |   2015 |             12 | Dec     | Opportunity #328 |    337 |        3 | Large              |
| 2015-03-25 10:59:00.000 |              445 |                1 |          341 |            8 |            5 |          3583798 |         358380           | 2014-01-20 00:00:00.000 |            429.458 |   2015 |              3 | Mar     | Opportunity #445 |    220 |        2 | Medium             |
| 2015-11-30 10:59:00.000 |               14 |                1 |           14 |           10 |           20 |          3472976 |         347298           | 2014-07-06 00:00:00.000 |            512.458 |   2015 |             11 | Nov     | Opportunity #14  |    213 |        2 | Medium             |
| 2015-12-31 10:59:00.000 |              295 |                1 |          110 |           22 |           22 |          4263304 |         426330           | 2014-06-05 00:00:00.000 |            574.458 |   2015 |             12 | Dec     | Opportunity #295 |    259 |        2 | Medium             |
| 2015-03-01 10:59:00.000 |               44 |                1 |           41 |           24 |           18 |          9333422 |         933342           | 2014-03-01 00:00:00.000 |            365.458 |   2015 |              3 | Mar     | Opportunity #44  |    452 |        3 | Large              |
| 2015-07-31 08:00:00.000 |              229 |                1 |          181 |           62 |            5 |          4139381 |         413938           | 2014-02-21 00:00:00.000 |            525.333 |   2015 |              7 | Jul     | Opportunity #229 |    251 |        2 | Medium             |
| 2015-02-09 10:59:00.000 |              360 |                2 |          281 |           22 |            2 |          4600206 |         920041           | 2014-01-03 00:00:00.000 |            402.458 |   2015 |              2 | Feb     | Opportunity #360 |    272 |        2 | Medium             |
| 2015-03-17 10:59:00.000 |              484 |                1 |          357 |           22 |           25 |           124080 |          12408           | 2014-01-07 00:00:00.000 |            434.458 |   2015 |              3 | Mar     | Opportunity #484 |     14 |        1 | Small              |
| 2015-12-31 10:59:00.000 |               66 |                1 |           57 |           22 |           21 |          2847321 |         284732           | 2014-06-25 00:00:00.000 |            554.458 |   2015 |             12 | Dec     | Opportunity #66  |    182 |        2 | Medium             |
| 2015-07-04 10:59:00.000 |              444 |                3 |          340 |           97 |           13 |         10875494 |              4.3502e+06  | 2014-04-03 00:00:00.000 |            457.458 |   2015 |              7 | Jul     | Opportunity #444 |    473 |        3 | Large              |
| 2015-06-30 10:59:00.000 |              373 |                1 |          291 |           22 |            8 |          5626094 |         562609           | 2014-06-19 00:00:00.000 |            376.458 |   2015 |              6 | Jun     | Opportunity #373 |    322 |        2 | Medium             |
| 2015-02-18 10:59:00.000 |               93 |                1 |           81 |           22 |           21 |          2540740 |         254074           | 2014-02-05 00:00:00.000 |            378.458 |   2015 |              2 | Feb     | Opportunity #93  |    166 |        2 | Medium             |
| 2015-10-31 10:59:00.000 |               43 |                1 |           40 |           14 |           17 |           236607 |          23660.7         | 2014-07-08 00:00:00.000 |            480.458 |   2015 |             10 | Oct     | Opportunity #43  |     26 |        1 | Small              |
| 2015-07-31 08:00:00.000 |               21 |                3 |           21 |           14 |           11 |          6312394 |              2.52496e+06 | 2014-07-18 00:00:00.000 |            378.333 |   2015 |              7 | Jul     | Opportunity #21  |    358 |        3 | Large              |
| 2015-12-31 10:59:00.000 |              104 |                1 |           89 |            8 |           20 |          4047326 |         404733           | 2014-08-05 00:00:00.000 |            513.458 |   2015 |             12 | Dec     | Opportunity #104 |    246 |        2 | Medium             |
| 2015-01-01 10:59:00.000 |              133 |                4 |          109 |           46 |           21 |          1888265 |              1.13296e+06 | 2014-01-01 00:00:00.000 |            365.458 |   2015 |              1 | Jan     | Opportunity #133 |    128 |        1 | Small              |
| 2015-12-31 10:59:00.000 |              335 |                1 |          258 |           82 |           21 |          5812922 |         581292           | 2014-11-17 00:00:00.000 |            409.458 |   2015 |             12 | Dec     | Opportunity #335 |    334 |        3 | Large              |
| 2015-06-12 10:59:00.000 |              386 |                1 |          300 |           22 |           23 |          1853211 |         185321           | 2014-04-12 00:00:00.000 |            426.458 |   2015 |              6 | Jun     | Opportunity #386 |    124 |        1 | Small              |
| 2015-04-17 10:59:00.000 |              358 |                4 |           47 |           22 |           21 |          3488444 |              2.09307e+06 | 2014-03-02 00:00:00.000 |            411.458 |   2015 |              4 | Apr     | Opportunity #358 |    215 |        2 | Medium             |
| 2015-11-30 10:59:00.000 |              173 |                1 |           52 |            3 |           19 |          6335917 |         633592           | 2014-04-27 00:00:00.000 |            582.458 |   2015 |             11 | Nov     | Opportunity #173 |    360 |        3 | Large              |
| 2015-02-26 10:59:00.000 |               28 |                4 |           28 |            8 |           22 |          5636292 |              3.38178e+06 | 2014-01-03 00:00:00.000 |            419.458 |   2015 |              2 | Feb     | Opportunity #28  |    324 |        3 | Large              |
| 2015-06-30 10:59:00.000 |              350 |                1 |          272 |            8 |           20 |          3134986 |         313499           | 2014-01-19 00:00:00.000 |            527.458 |   2015 |              6 | Jun     | Opportunity #350 |    189 |        2 | Medium             |
| 2015-11-30 10:59:00.000 |              411 |                1 |          110 |           22 |            2 |          6949790 |         694979           | 2014-05-11 00:00:00.000 |            568.458 |   2015 |             11 | Nov     | Opportunity #411 |    382 |        3 | Large              |
| 2015-06-15 10:59:00.000 |              149 |                2 |          118 |           48 |           10 |          9040519 |              1.8081e+06  | 2014-01-11 00:00:00.000 |            520.458 |   2015 |              6 | Jun     | Opportunity #149 |    441 |        3 | Large              |
| 2015-11-30 10:59:00.000 |              428 |                1 |          329 |           90 |            2 |         11888801 |              1.18888e+06 | 2014-01-09 00:00:00.000 |            690.458 |   2015 |             11 | Nov     | Opportunity #428 |    483 |        3 | Large              |
| 2015-04-13 10:59:00.000 |              397 |                4 |          310 |           22 |           15 |          5952410 |              3.57145e+06 | 2014-01-07 00:00:00.000 |            461.458 |   2015 |              4 | Apr     | Opportunity #397 |    340 |        3 | Large              |
| 2015-07-31 08:00:00.000 |                6 |                1 |            6 |            5 |           19 |            25932 |           2593.2         | 2014-05-01 00:00:00.000 |            456.333 |   2015 |              7 | Jul     | Opportunity #6   |      3 |        1 | Small              |
| 2015-12-31 10:59:00.000 |              206 |                1 |          103 |           22 |           17 |            61254 |           6125.4         | 2014-12-14 00:00:00.000 |            382.458 |   2015 |             12 | Dec     | Opportunity #206 |      5 |        1 | Small              |
| 2015-12-31 10:59:00.000 |              134 |                1 |          110 |           22 |           17 |          3249174 |         324917           | 2014-04-08 00:00:00.000 |            632.458 |   2015 |             12 | Dec     | Opportunity #134 |    201 |        2 | Medium             |
| 2015-09-30 10:59:00.000 |               16 |                1 |           16 |           12 |            3 |          6746912 |         674691           | 2014-03-12 00:00:00.000 |            567.458 |   2015 |              9 | Sep     | Opportunity #16  |    377 |        3 | Large              |
| 2015-02-27 10:59:00.000 |              310 |                4 |          243 |           22 |           15 |          5112248 |              3.06735e+06 | 2014-02-05 00:00:00.000 |            387.458 |   2015 |              2 | Feb     | Opportunity #310 |    301 |        2 | Medium             |
| 2015-12-31 10:59:00.000 |              155 |                1 |          123 |           49 |            3 |          1211056 |         121106           | 2014-10-01 00:00:00.000 |            456.458 |   2015 |             12 | Dec     | Opportunity #155 |     83 |        1 | Small              |
| 2015-04-30 10:59:00.000 |              327 |                1 |          210 |           22 |            7 |           590086 |          59008.6         | 2014-03-03 00:00:00.000 |            423.458 |   2015 |              4 | Apr     | Opportunity #327 |     48 |        1 | Small              |
| 2015-06-05 10:59:00.000 |              192 |                1 |          155 |           22 |           18 |          4053946 |         405395           | 2014-05-04 00:00:00.000 |            397.458 |   2015 |              6 | Jun     | Opportunity #192 |    247 |        2 | Medium             |
| 2015-12-31 10:59:00.000 |              375 |                1 |          293 |           12 |            1 |          6461315 |         646132           | 2014-03-15 00:00:00.000 |            656.458 |   2015 |             12 | Dec     | Opportunity #375 |    366 |        3 | Large              |
| 2015-11-20 10:59:00.000 |               84 |                1 |           72 |           22 |            1 |           356981 |          35698.1         | 2014-02-09 00:00:00.000 |            649.458 |   2015 |             11 | Nov     | Opportunity #84  |     33 |        1 | Small              |
| 2015-06-30 10:59:00.000 |              393 |                1 |          306 |           22 |            4 |          3412054 |         341205           | 2014-06-08 00:00:00.000 |            387.458 |   2015 |              6 | Jun     | Opportunity #393 |    210 |        2 | Medium             |
| 2015-07-31 08:00:00.000 |                2 |                1 |            2 |            2 |           19 |            24700 |           2470           | 2014-03-23 00:00:00.000 |            495.333 |   2015 |              7 | Jul     | Opportunity #2   |      2 |        1 | Small              |
| 2015-05-29 10:59:00.000 |              301 |                2 |          237 |           22 |           16 |           825397 |         165079           | 2014-03-01 00:00:00.000 |            454.458 |   2015 |              5 | May     | Opportunity #301 |     61 |        1 | Small              |
| 2015-06-30 10:59:00.000 |              348 |                2 |          270 |           22 |            4 |          2200700 |         440140           | 2014-04-03 00:00:00.000 |            453.458 |   2015 |              6 | Jun     | Opportunity #348 |    147 |        1 | Small              |
| 2015-09-30 10:59:00.000 |               23 |                2 |           23 |           16 |           10 |          3563871 |         712774           | 2014-05-26 00:00:00.000 |            492.458 |   2015 |              9 | Sep     | Opportunity #23  |    219 |        2 | Medium             |
| 2015-08-31 10:59:00.000 |              456 |                2 |          215 |            8 |            5 |          8054791 |              1.61096e+06 | 2014-06-08 00:00:00.000 |            449.458 |   2015 |              8 | Aug     | Opportunity #456 |    416 |        3 | Large              |
| 2015-06-25 10:59:00.000 |              101 |                1 |           86 |            3 |           10 |          1097304 |         109730           | 2014-03-16 00:00:00.000 |            466.458 |   2015 |              6 | Jun     | Opportunity #101 |     77 |        1 | Small              |
| 2015-07-31 08:00:00.000 |               24 |                1 |           24 |           17 |           19 |          8880021 |         888002           | 2014-07-27 00:00:00.000 |            369.333 |   2015 |              7 | Jul     | Opportunity #24  |    437 |        3 | Large              |
| 2015-12-31 10:59:00.000 |              124 |                1 |           52 |           24 |           20 |          3214265 |         321426           | 2014-06-20 00:00:00.000 |            559.458 |   2015 |             12 | Dec     | Opportunity #124 |    197 |        2 | Medium             |
| 2015-06-26 10:59:00.000 |              242 |                1 |          193 |           22 |            5 |          2154078 |         215408           | 2014-06-05 00:00:00.000 |            386.458 |   2015 |              6 | Jun     | Opportunity #242 |    142 |        1 | Small              |
| 2015-07-31 08:00:00.000 |                7 |                1 |            7 |            2 |           12 |            23725 |           2372.5         | 2014-03-22 00:00:00.000 |            496.333 |   2015 |              7 | Jul     | Opportunity #7   |      1 |        1 | Small              |
| 2015-01-30 10:59:00.000 |              449 |                5 |           73 |            8 |           18 |          6770072 |              5.41606e+06 | 2014-01-06 00:00:00.000 |            389.458 |   2015 |              1 | Jan     | Opportunity #449 |    378 |        3 | Large              |
| 2015-12-31 10:59:00.000 |              359 |                1 |          280 |           12 |           15 |          8146942 |         814694           | 2014-09-17 00:00:00.000 |            470.458 |   2015 |             12 | Dec     | Opportunity #359 |    417 |        3 | Large              |
| 2015-11-30 10:59:00.000 |              218 |                1 |           61 |           22 |           24 |          6203732 |         620373           | 2014-09-20 00:00:00.000 |            436.458 |   2015 |             11 | Nov     | Opportunity #218 |    352 |        3 | Large              |



label: Opportunity ID
Name
Opportunity ID
Rank
Opportunity ID
SizeID
Opportunity ID
Opportunity Size
output: {"Functional-Dependency": [["Opportunity ID", "Name"], ["Opportunity ID", "Rank"], ["Opportunity ID", "SizeID"], ["Opportunity ID", "Opportunity Size"]]}
labeled_fds: Opportunity ID
Name
Opportunity ID
Rank
Opportunity ID
SizeID
Opportunity ID
Opportunity Size
Opportunity ID
Sales Stage ID
Opportunity ID
Product ID
Opportunity ID
ProductRevenue
Opportunity ID
FactoredProductRevenue
Opportunity ID
Create Date
Opportunity ID
Opportunity Days
ProductRevenue
EstimatedCloseDate
ProductRevenue
Opportunity ID
ProductRevenue
Sales Stage ID
ProductRevenue
Partner ID
ProductRevenue
Product ID
ProductRevenue
FactoredProductRevenue
ProductRevenue
Opportunity Days
ProductRevenue
Month_Number
ProductRevenue
Month
ProductRevenue
Name
FactoredProductRevenue
Opportunity ID
FactoredProductRevenue
Account ID
FactoredProductRevenue
Product ID
FactoredProductRevenue
Create Date
FactoredProductRevenue
Opportunity Days
FactoredProductRevenue
Name
Name
Product ID
Name
ProductRevenue
Name
FactoredProductRevenue
Name
Create Date
Rank
EstimatedCloseDate
Rank
Opportunity ID
Rank
Sales Stage ID
Rank
Account ID
Rank
Partner ID
Rank
ProductRevenue
Rank
FactoredProductRevenue
Rank
Create Date
Rank
Month_Number
Rank
Month
Rank
Name
source: $MMTU_HOME/resources/Relationship-finding/FD/330636151