A B C D 1 OrderNo OrderDate Customerl Fname 2 3 4 5 6 7 8...

 

Transcribed Image Text:

A B C D 1 OrderNo OrderDate Customerl Fname 2 3 4 5 6 7 8 9 10 33 02-Feb-23 33 02-Feb-23 33 02-Feb-23 12 14 04-Mar-23 07-Jun-23 07-Jun-23 14 Joe Joe Joe Amy Amy John E Lname Smith Smith Smith Taylor Taylor Glenn F StreetAddress City 11 12 Write down the name of the column (s) has a full dependecy? 13 14 15 16 17 Write down the name of the column (s) has a partial dependencies? 18 19 20 21 Show the partial dependency of Unit Price? 22 23 24 25 26 27 G H Province Toronto ON Toronto ON Toronto ON Calgary AL Vancouver BC Vancouver BC | J Postal Code Email A@abc.com A@abc.com A@abc.com B@abc.com A@abc.com A@abc.com K L M N P Sales PersonID Sales Perso Sales Person Phone Product No Product De: UnitPrice Quantity Mark Mark Mark Tony Tony Tony 1234567 1234567 1234567 1234567 1234567 1234567 124 109 110 109 109 107 $2.00 $3.00 $0.50 $3.00 $3.00 $6.00 2 2 10 6 27 4 R A B C D 1 OrderNo OrderDate Customerl Fname 2 3 4 5 6 7 8 9 10 33 02-Feb-23 33 02-Feb-23 33 02-Feb-23 12 14 04-Mar-23 07-Jun-23 07-Jun-23 14 Joe Joe Joe Amy Amy John E Lname Smith Smith Smith Taylor Taylor Glenn F StreetAddress City 11 12 Write down the name of the column (s) has a full dependecy? 13 14 15 16 17 Write down the name of the column (s) has a partial dependencies? 18 19 20 21 Show the partial dependency of Unit Price? 22 23 24 25 26 27 G H Province Toronto ON Toronto ON Toronto ON Calgary AL Vancouver BC Vancouver BC | J Postal Code Email A@abc.com A@abc.com A@abc.com B@abc.com A@abc.com A@abc.com K L M N P Sales PersonID Sales Perso Sales Person Phone Product No Product De: UnitPrice Quantity Mark Mark Mark Tony Tony Tony 1234567 1234567 1234567 1234567 1234567 1234567 124 109 110 109 109 107 $2.00 $3.00 $0.50 $3.00 $3.00 $6.00 2 2 10 6 27 4 R