• Register
0 votes

Problem :

I have following issue related to Partial Dependency
a dependency of one nonprime attribute on another nonprime attribute is a partial dependency.
6 5 3
6,930 points

1 Answer

0 votes

Solution :

Partial Dependency is one of the kind of functional dependency that occurs when primary key must be the candidate key and non prime attribute those depens on the subset/part of candidates key (i.e more than one primary key).

So try to understand partial dependency by following example :

Seller(Id, Product, Price)

Candidate Key : Id, Product
Non prime attribute : Price

Here Price attribute only depends on Product attribute which is a subset of candidate key,But Not the whole candidate key(Id, Product).It is called partial dependency.

So Product->Price is partial dependency.

9 7 4
38,600 points

Related questions

0 votes
1 answer 13 views
Problem: A dependency of one nonprime attribute on another nonprime attribute is a partial dependency? True False
asked Jul 21 sstones 830 points
0 votes
2 answers 322 views
Problem: A _____ is a simple database program whose records have no relationship to one another? Select one: a.flat file b.schema c.relational system d.user view
asked Apr 12 ArifulIslam 5.7k points
0 votes
1 answer 94 views
Problem: Can anyone help it was actually asked in exam as following and I need to know whether my answer was right or not? Ideally, an entity identifier is composed of _____ attribute(s)? A) one B) two C) three D) six
asked Feb 21 maddi86 5.4k points
0 votes
1 answer 5 views
0 votes
1 answer 7 views
I need to copy a table information from one database to another table of another database. Is it possible for me to do it? if it is, can someone help me? Thank you!
asked Oct 12 robin_gallo 300 points