• Register
0 votes
32 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 5 3
6,930 points

Please log in or register to answer this question.

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 17 views
17 views
Problem: A dependency of one nonprime attribute on another nonprime attribute is a partial dependency? True False
asked Jul 21, 2020 sstones 830 points
0 votes
2 answers 485 views
485 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, 2020 ArifulIslam 5.6k points
0 votes
1 answer 8 views
0 votes
1 answer 5 views
5 views asked Oct 24, 2020 miki 1.9k points
0 votes
1 answer 12 views
0 votes
1 answer 18 views
18 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, 2020 robin_gallo 420 points
0 votes
1 answer 23 views
23 views
Problem: In this logic structure, one program statement follows another?
asked Apr 12, 2020 ArifulIslam 5.6k points
0 votes
1 answer 146 views
146 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, 2020 maddi86 5.4k points
0 votes
1 answer 11 views
11 views
Problem: Each time a user logs on locally, which database is used to verify sign-in credentials?
asked Jul 22, 2020 HenryL 620 points