Example: Partial functional dependencies

AdCampaignID AdCampaignName, StartDate, Duration, CampaignMgrID, CampaignMgrName

ModusID Media, Range

Full key functional dependency: AdCampaignID, ModusID BudgetPctg

Transitive functional dependency: CampaignMgrID CampaignMgrName

Question: Answer the question above with .

me nty MI A transportation company use the following relational table to keep track of its projects. Project ProjectNa Countyi CountyNa Project Manager Project Manager Na MilesinCou D me D ID me 1 Road X 1 Wilson MI Bob 10 1 Road X 2 Ottawa Bob 17 1 Road X 3 Davis MI Bob 12 2 Road Y 3 Davis M2 Sue 23 3 Bridge A 1 Wilson M3 Lee 0.5 3 Bridge A 2 Ottawa M3 Lee 0.3 4 Tunnel 2 Ottawa MI Bob 2 5 Road W 4 Pony Bob M4 23 In this table, a project has a manager, who may manage several projects. A project may involve several counties, and MilesinCounty indicates the miles (length) of the project in a county. Question: What are the full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the table? Please use the symbolic written expression (i.e., with an arrow symbol: ) to show functional dependencies. me nty MI A transportation company use the following relational table to keep track of its projects. Project ProjectNa Countyi CountyNa Project Manager Project Manager Na MilesinCou D me D ID me 1 Road X 1 Wilson MI Bob 10 1 Road X 2 Ottawa Bob 17 1 Road X 3 Davis MI Bob 12 2 Road Y 3 Davis M2 Sue 23 3 Bridge A 1 Wilson M3 Lee 0.5 3 Bridge A 2 Ottawa M3 Lee 0.3 4 Tunnel 2 Ottawa MI Bob 2 5 Road W 4 Pony Bob M4 23 In this table, a project has a manager, who may manage several projects. A project may involve several counties, and MilesinCounty indicates the miles (length) of the project in a county. Question: What are the full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the table? Please use the symbolic written expression (i.e., with an arrow symbol: ) to show functional dependencies