retagged by
4,533 views

2 Answers

1 votes
1 votes
ans : D

prime attribute

Attributes that occur in any candidate  key are  called prime attributes and

attributes that doesnot occur in candidate key are called nonprime attributes .
0 votes
0 votes
Option D

The constituent attributes of a Candidate key or simply the attributes of a candidate key are called the prime attributes.

Suppose ABC is one candidate key of a Relation R(ABCDEFGH). Then the attributes A, B and C all are prime attributes. Similarly if ABD is also another candidate key in the same relation R, then D is also the prime attribute. And conversely, an attribute that does not occur in ANY candidate key is called a non-prime attribute.

atomic attribute ,candidate attribute there is no such term exist in RDBMS so option A,B, are false
Answer:

Related questions

0 votes
0 votes
2 answers
1
admin asked Mar 31, 2020
867 views
Normalization from which is based on transitive dependency is classified as:First normal form.Second normal form.Fourth normal form.Third normal form.
0 votes
0 votes
2 answers
2
admin asked Mar 31, 2020
3,362 views
In functional dependency between two sets of attribute $A$ and $B$ then set of attributes $A$ of database is classified as:top right sidedown left sideleft hand sideright...
2 votes
2 votes
1 answer
4
admin asked Mar 31, 2020
1,226 views
Which of the following is a fundamental operation in relational algebra?Set intersectionAssignmentNatural JoinNone of the above