• Register
0 votes
27 views

Problem :

I have following issue related to Partial Dependency
a dependency of one nonprime attribute on another nonprime attribute is a partial dependency.
6.9k 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.

36.1k points

Related questions

0 votes
1 answer 8 views
8 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 178 views
178 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 65 views
65 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 13 views
13 views
Problem: In this logic structure, one program statement follows another?
asked Apr 12 ArifulIslam 5.7k points
0 votes
1 answer 3 views
3 views
Problem: Each time a user logs on locally, which database is used to verify sign-in credentials?
asked Jul 22 HenryL 620 points