Find the functional dependencies and multi-valued functional dependencies in the following "Supplier" table with attributes SupNr, Name, Country, Postal Code, Town Street, Street Number, PartDescription, Volume, Date, Contact Name, Phone Number. You do not have to give trivial FDs nor FDs that follow from the ones you already established.  

Transcribed Image Text:

SupNr Name 10023 Acme 10023 Acme 10023 Acme 10023 Acme 10109 Wiley Coyote 10109 Wiley Coyote Country UK UK UK UK USA USA 10109 Wiley Coyote USA Postal Town Code EC EC EC EC London London London London 72956 Van Buren 72956 Van Buren 72956 Van Buren Street High Street High Street High Street High Street Co-Op Dr Co-Op Dr Co-Op Dr Street Number 136a 136a 136a 136a 717 717 717 PartNr PartDescription 20101 Widget for Gimble 20101 Widget 20115 Brumble for Gimble 20115 Brumble 20101 Widget 20101 for Gimble 20101 Widget for Gimble Widget for Gimble Volume Date 300 02-01-2023 300 02-01-2023 250 02-03-2023 250 02-03-2023 125 02-04-2023 125 02-04-2023 125 02-04-2023 Contact Name Liz Bower Liz Bower Liz Bower Liz Bower Frank Abbot Will Smith Jr Will Smith Jr Phone Number +44 1632 960107 +44 1632 960092 +44 1632 960107 +44 1632 960092 (479) 410-2086 (479) 410-2087 (479) 532-1099 SupNr Name 10023 Acme 10023 Acme 10023 Acme 10023 Acme 10109 Wiley Coyote 10109 Wiley Coyote Country UK UK UK UK USA USA 10109 Wiley Coyote USA Postal Town Code EC EC EC EC London London London London 72956 Van Buren 72956 Van Buren 72956 Van Buren Street High Street High Street High Street High Street Co-Op Dr Co-Op Dr Co-Op Dr Street Number 136a 136a 136a 136a 717 717 717 PartNr PartDescription 20101 Widget for Gimble 20101 Widget 20115 Brumble for Gimble 20115 Brumble 20101 Widget 20101 for Gimble 20101 Widget for Gimble Widget for Gimble Volume Date 300 02-01-2023 300 02-01-2023 250 02-03-2023 250 02-03-2023 125 02-04-2023 125 02-04-2023 125 02-04-2023 Contact Name Liz Bower Liz Bower Liz Bower Liz Bower Frank Abbot Will Smith Jr Will Smith Jr Phone Number +44 1632 960107 +44 1632 960092 +44 1632 960107 +44 1632 960092 (479) 410-2086 (479) 410-2087 (479) 532-1099

Answer rating: 100% (QA)

Based on the Supplier table provided we can identify several functional dependencies FDs by looking ... View the full answer