Answered step by step
Verified Expert Solution
Link Copied!

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.student submitted image, transcription available below  

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2014

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven Gill

32nd Edition

1285424549, 978-1285424545

More Books

Students also viewed these Databases questions

Question

What made you decide on this subfield of psychology?

Answered: 1 week ago