Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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,
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.
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
Step by Step Solution
★★★★★
3.48 Rating (148 Votes )
There are 3 Steps involved in it
Step: 1
Based on the Supplier table provided we can identify several functional dependencies FDs by looking ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started