• Register
0 votes
45 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 36 views
36 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 663 views
663 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 7.5k points
0 votes
1 answer 17 views
0 votes
1 answer 7 views
7 views
Problem How can i copy one array to another array in c++
asked Mar 25 Subhendu 4.1k points
0 votes
1 answer 3 views
3 views
Problem: How to copy rows from one table to another?
asked Mar 23 charles mathews 5.5k points
0 votes
1 answer 12 views
12 views
Problem: I have a database named foo and a database named bar. I have a table in foo called tblFoobar that I want to move data (and all) to the database from the database bar of foo. What is the sql statement to do this?
asked Feb 27 sasha 16.2k points
0 votes
1 answer 9 views
9 views asked Oct 24, 2020 miki 1.9k points
0 votes
1 answer 16 views
0 votes
1 answer 50 views
50 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 14 views