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:
| Community   | Date                    |    POC |   POC Bin |   Current Month POC | Year   | QuarterOfYear   | MonthOfYear   | DayOfMonth   | DateInt   | MonthName   | MonthInCalendar   | QuarterInCalendar   | DayInWeek   | DayOfWeekName   | WeekEnding              | Week Number   | MonthnYear   | QuarternYear   | ShortYear   | FY   | IF Prev Month and above   | CurrentAndFutureMonths   |
|:------------|:------------------------|-------:|----------:|--------------------:|:-------|:----------------|:--------------|:-------------|:----------|:------------|:------------------|:--------------------|:------------|:----------------|:------------------------|:--------------|:-------------|:---------------|:------------|:-----|:--------------------------|:-------------------------|
| ABC         | 2025-09-30 00:00:00.000 | 1      |      1    |              1      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2016-09-30 00:00:00.000 | 0.0078 |      0    |              0.0078 |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2023-10-31 00:00:00.000 | 1      |      1    |              1      | 2023   | 4               | 10            | 31           | 20231031  | October     | Oct 2023          | Q4 2023             | 2           | Tuesday         | 2023-11-04 00:00:00.000 | 44            | 20231000     | 20230400       | 23          | FY24 | Y                         | True                     |
| ABC         | 2019-09-30 00:00:00.000 | 0.4487 |      0.4  |              0.4487 | 2019   | 3               | 9             | 30           | 20190930  | September   | Sep 2019          | Q3 2019             | 1           | Monday          | 2019-10-05 00:00:00.000 | 40            | 20190900     | 20190300       | 19          | FY20 | N                         | False                    |
| ABC         | 2018-07-31 00:00:00.000 | 0.1694 |      0.15 |              0.1694 | 2018   | 3               | 7             | 31           | 20180731  | July        | Jul 2018          | Q3 2018             | 2           | Tuesday         | 2018-08-04 00:00:00.000 | 31            | 20180700     | 20180300       | 18          | FY19 | N                         | False                    |
| ABC         | 2017-03-31 00:00:00.000 | 0.0255 |      0    |              0.0255 |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2020-06-30 00:00:00.000 | 0.6235 |      0.6  |              0.6235 | 2020   | 2               | 6             | 30           | 20200630  | June        | Jun 2020          | Q2 2020             | 2           | Tuesday         | 2020-07-04 00:00:00.000 | 27            | 20200600     | 20200200       | 20          | FY21 | N                         | False                    |
| ABC         | 2023-03-31 00:00:00.000 | 1      |      1    |              1      | 2023   | 1               | 3             | 31           | 20230331  | March       | Mar 2023          | Q1 2023             | 5           | Friday          | 2023-04-01 00:00:00.000 | 13            | 20230300     | 20230100       | 23          | FY24 | Y                         | True                     |
| ABC         | 2024-02-29 00:00:00.000 | 1      |      1    |              1      | 2024   | 1               | 2             | 29           | 20240229  | February    | Feb 2024          | Q1 2024             | 4           | Thursday        | 2024-03-02 00:00:00.000 | 9             | 20240200     | 20240100       | 24          | FY25 | Y                         | True                     |
| ABC         | 2023-11-30 00:00:00.000 | 1      |      1    |              1      | 2023   | 4               | 11            | 30           | 20231130  | November    | Nov 2023          | Q4 2023             | 4           | Thursday        | 2023-12-02 00:00:00.000 | 48            | 20231100     | 20230400       | 23          | FY24 | Y                         | True                     |
| ABC         | 2018-05-31 00:00:00.000 | 0.1542 |      0.15 |              0.1542 | 2018   | 2               | 5             | 31           | 20180531  | May         | May 2018          | Q2 2018             | 4           | Thursday        | 2018-06-02 00:00:00.000 | 22            | 20180500     | 20180200       | 18          | FY19 | N                         | False                    |
| ABC         | 2018-09-30 00:00:00.000 | 0.1921 |      0.15 |              0.1921 | 2018   | 3               | 9             | 30           | 20180930  | September   | Sep 2018          | Q3 2018             | 0           | Sunday          | 2018-10-06 00:00:00.000 | 40            | 20180900     | 20180300       | 18          | FY19 | N                         | False                    |
| ABC         | 2021-09-30 00:00:00.000 | 0.8555 |      0.85 |              0.8555 | 2021   | 3               | 9             | 30           | 20210930  | September   | Sep 2021          | Q3 2021             | 4           | Thursday        | 2021-10-02 00:00:00.000 | 40            | 20210900     | 20210300       | 21          | FY22 | N                         | False                    |
| ABC         | 2018-03-31 00:00:00.000 | 0.0817 |      0.05 |              0.0817 | 2018   | 1               | 3             | 31           | 20180331  | March       | Mar 2018          | Q1 2018             | 6           | Saturday        | 2018-03-31 00:00:00.000 | 13            | 20180300     | 20180100       | 18          | FY19 | N                         | False                    |
| ABC         | 2015-05-31 00:00:00.000 | 0      |      0    |              0      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2019-07-31 00:00:00.000 | 0.3941 |      0.35 |              0.3941 | 2019   | 3               | 7             | 31           | 20190731  | July        | Jul 2019          | Q3 2019             | 3           | Wednesday       | 2019-08-03 00:00:00.000 | 31            | 20190700     | 20190300       | 19          | FY20 | N                         | False                    |
| ABC         | 2016-03-31 00:00:00.000 | 0      |      0    |              0      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2021-02-28 00:00:00.000 | 0.7135 |      0.7  |              0.7135 | 2021   | 1               | 2             | 28           | 20210228  | February    | Feb 2021          | Q1 2021             | 0           | Sunday          | 2021-03-06 00:00:00.000 | 10            | 20210200     | 20210100       | 21          | FY22 | N                         | False                    |
| ABC         | 2016-11-30 00:00:00.000 | 0.0088 |      0    |              0.0088 |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2024-03-31 00:00:00.000 | 1      |      1    |              1      | 2024   | 1               | 3             | 31           | 20240331  | March       | Mar 2024          | Q1 2024             | 0           | Sunday          | 2024-04-06 00:00:00.000 | 14            | 20240300     | 20240100       | 24          | FY25 | Y                         | True                     |
| ABC         | 2016-04-30 00:00:00.000 | 0      |      0    |              0      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2021-10-31 00:00:00.000 | 0.8755 |      0.85 |              0.8755 | 2021   | 4               | 10            | 31           | 20211031  | October     | Oct 2021          | Q4 2021             | 0           | Sunday          | 2021-11-06 00:00:00.000 | 45            | 20211000     | 20210400       | 21          | FY22 | N                         | False                    |
| ABC         | 2020-02-29 00:00:00.000 | 0.5857 |      0.55 |              0.5857 | 2020   | 1               | 2             | 29           | 20200229  | February    | Feb 2020          | Q1 2020             | 6           | Saturday        | 2020-02-29 00:00:00.000 | 9             | 20200200     | 20200100       | 20          | FY21 | N                         | False                    |
| ABC         | 2019-12-31 00:00:00.000 | 0.5086 |      0.5  |              0.5086 | 2019   | 4               | 12            | 31           | 20191231  | December    | Dec 2019          | Q4 2019             | 2           | Tuesday         | 2020-01-04 00:00:00.000 | 53            | 20191200     | 20190400       | 19          | FY20 | N                         | False                    |
| ABC         | 2020-08-31 00:00:00.000 | 0.6355 |      0.6  |              0.6355 | 2020   | 3               | 8             | 31           | 20200831  | August      | Aug 2020          | Q3 2020             | 1           | Monday          | 2020-09-05 00:00:00.000 | 36            | 20200800     | 20200300       | 20          | FY21 | N                         | False                    |
| ABC         | 2023-04-30 00:00:00.000 | 1      |      1    |              1      | 2023   | 2               | 4             | 30           | 20230430  | April       | Apr 2023          | Q2 2023             | 0           | Sunday          | 2023-05-06 00:00:00.000 | 18            | 20230400     | 20230200       | 23          | FY24 | Y                         | True                     |
| ABC         | 2022-03-31 00:00:00.000 | 0.9755 |      0.95 |              0.9755 | 2022   | 1               | 3             | 31           | 20220331  | March       | Mar 2022          | Q1 2022             | 4           | Thursday        | 2022-04-02 00:00:00.000 | 14            | 20220300     | 20220100       | 22          | FY23 | N                         | False                    |
| ABC         | 2020-07-31 00:00:00.000 | 0.6295 |      0.6  |              0.6295 | 2020   | 3               | 7             | 31           | 20200731  | July        | Jul 2020          | Q3 2020             | 5           | Friday          | 2020-08-01 00:00:00.000 | 31            | 20200700     | 20200300       | 20          | FY21 | N                         | False                    |
| ABC         | 2018-04-30 00:00:00.000 | 0.1466 |      0.1  |              0.1466 | 2018   | 2               | 4             | 30           | 20180430  | April       | Apr 2018          | Q2 2018             | 1           | Monday          | 2018-05-05 00:00:00.000 | 18            | 20180400     | 20180200       | 18          | FY19 | N                         | False                    |
| ABC         | 2024-07-31 00:00:00.000 | 1      |      1    |              1      | 2024   | 3               | 7             | 31           | 20240731  | July        | Jul 2024          | Q3 2024             | 3           | Wednesday       | 2024-08-03 00:00:00.000 | 31            | 20240700     | 20240300       | 24          | FY25 | Y                         | True                     |
| ABC         | 2022-06-30 00:00:00.000 | 1      |      1    |              1      | 2022   | 2               | 6             | 30           | 20220630  | June        | Jun 2022          | Q2 2022             | 4           | Thursday        | 2022-07-02 00:00:00.000 | 27            | 20220600     | 20220200       | 22          | FY23 | Y                         | True                     |
| ABC         | 2025-11-30 00:00:00.000 | 1      |      1    |              1      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2018-11-30 00:00:00.000 | 0.2194 |      0.2  |              0.2194 | 2018   | 4               | 11            | 30           | 20181130  | November    | Nov 2018          | Q4 2018             | 5           | Friday          | 2018-12-01 00:00:00.000 | 48            | 20181100     | 20180400       | 18          | FY19 | N                         | False                    |
| ABC         | 2021-01-31 00:00:00.000 | 0.6865 |      0.65 |              0.6865 | 2021   | 1               | 1             | 31           | 20210131  | January     | Jan 2021          | Q1 2021             | 0           | Sunday          | 2021-02-06 00:00:00.000 | 6             | 20210100     | 20210100       | 21          | FY22 | N                         | False                    |
| ABC         | 2014-11-30 00:00:00.000 | 0      |      0    |              0      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2017-08-31 00:00:00.000 | 0.0373 |      0    |              0.0373 |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2019-10-31 00:00:00.000 | 0.4692 |      0.45 |              0.4692 | 2019   | 4               | 10            | 31           | 20191031  | October     | Oct 2019          | Q4 2019             | 4           | Thursday        | 2019-11-02 00:00:00.000 | 44            | 20191000     | 20190400       | 19          | FY20 | N                         | False                    |
| ABC         | 2017-07-31 00:00:00.000 | 0.0355 |      0    |              0.0355 |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2022-11-30 00:00:00.000 | 1      |      1    |              1      | 2022   | 4               | 11            | 30           | 20221130  | November    | Nov 2022          | Q4 2022             | 3           | Wednesday       | 2022-12-03 00:00:00.000 | 49            | 20221100     | 20220400       | 22          | FY23 | Y                         | True                     |
| ABC         | 2025-12-31 00:00:00.000 | 1      |      1    |              1      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2020-03-31 00:00:00.000 | 0.5971 |      0.55 |              0.5971 | 2020   | 1               | 3             | 31           | 20200331  | March       | Mar 2020          | Q1 2020             | 2           | Tuesday         | 2020-04-04 00:00:00.000 | 14            | 20200300     | 20200100       | 20          | FY21 | N                         | False                    |
| ABC         | 2016-01-31 00:00:00.000 | 0      |      0    |              0      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2016-05-31 00:00:00.000 | 0      |      0    |              0      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2021-07-31 00:00:00.000 | 0.8155 |      0.8  |              0.8155 | 2021   | 3               | 7             | 31           | 20210731  | July        | Jul 2021          | Q3 2021             | 6           | Saturday        | 2021-07-31 00:00:00.000 | 31            | 20210700     | 20210300       | 21          | FY22 | N                         | False                    |
| ABC         | 2022-04-30 00:00:00.000 | 1      |      1    |              1      | 2022   | 2               | 4             | 30           | 20220430  | April       | Apr 2022          | Q2 2022             | 6           | Saturday        | 2022-04-30 00:00:00.000 | 18            | 20220400     | 20220200       | 22          | FY23 | N                         | False                    |
| ABC         | 2014-12-31 00:00:00.000 | 0      |      0    |              0      |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |
| ABC         | 2025-01-31 00:00:00.000 | 1      |      1    |              1      | 2025   | 1               | 1             | 31           | 20250131  | January     | Jan 2025          | Q1 2025             | 5           | Friday          | 2025-02-01 00:00:00.000 | 5             | 20250100     | 20250100       | 25          | FY26 | Y                         | True                     |
| ABC         | 2019-03-31 00:00:00.000 | 0.3064 |      0.3  |              0.3064 | 2019   | 1               | 3             | 31           | 20190331  | March       | Mar 2019          | Q1 2019             | 0           | Sunday          | 2019-04-06 00:00:00.000 | 14            | 20190300     | 20190100       | 19          | FY20 | N                         | False                    |
| ABC         | 2022-09-30 00:00:00.000 | 1      |      1    |              1      | 2022   | 3               | 9             | 30           | 20220930  | September   | Sep 2022          | Q3 2022             | 5           | Friday          | 2022-10-01 00:00:00.000 | 40            | 20220900     | 20220300       | 22          | FY23 | Y                         | True                     |
| ABC         | 2016-10-31 00:00:00.000 | 0.0084 |      0    |              0.0084 |        |                 |               |              |           |             |                   |                     |             |                 |                         |               |              |                |             |      |                           |                          |



label: Date
Year
Date
QuarterOfYear
Date
MonthOfYear
Date
DayOfMonth
Date
DateInt
Date
MonthName
Date
MonthInCalendar
Date
QuarterInCalendar
Date
DayInWeek
Date
DayOfWeekName
Date
WeekEnding
Date
Week Number
Date
MonthnYear
Date
QuarternYear
Date
ShortYear
Date
FY
Date
IF Prev Month and above
Date
CurrentAndFutureMonths
output: {"Functional-Dependency": [["Date", "Year"], ["Date", "QuarterOfYear"], ["Date", "MonthOfYear"], ["Date", "DayOfMonth"], ["Date", "DateInt"], ["Date", "MonthName"], ["Date", "MonthInCalendar"], ["Date", "QuarterInCalendar"], ["Date", "DayInWeek"], ["Date", "DayOfWeekName"], ["Date", "WeekEnding"], ["Date", "Week Number"], ["Date", "MonthnYear"], ["Date", "QuarternYear"], ["Date", "ShortYear"], ["Date", "FY"], ["Date", "IF Prev Month and above"], ["Date", "CurrentAndFutureMonths"]]}
labeled_fds: Date
Year
Date
QuarterOfYear
Date
MonthOfYear
Date
DayOfMonth
Date
DateInt
Date
MonthName
Date
MonthInCalendar
Date
QuarterInCalendar
Date
DayInWeek
Date
DayOfWeekName
Date
WeekEnding
Date
Week Number
Date
MonthnYear
Date
QuarternYear
Date
ShortYear
Date
FY
Date
IF Prev Month and above
Date
CurrentAndFutureMonths
Current Month POC
IF Prev Month and above
QuarterInCalendar
IF Prev Month and above
QuarternYear
CurrentAndFutureMonths
source: $MMTU_HOME/resources/Relationship-finding/FD/484416652