Register

UGC NET CSE | December 2004 | Part 2 | Question: 18

• edited by
2,217 views

1 Answer

3 votes
3 votes

Answer: B)Total specialization, Partial specialization

The completeness constraint specifies whether or not an entity in the higher-level entity set must belong to at least one of the lower-level entity sets within the generalization/specialization.

This constraint can be one of the following

  1.  Total specialization:Each higher-level entity(Super Type) must belong to a lower-level entity set(Subtype).

  1. Partial specialization: Some higher-level entities(SuperType) may not belong to any lower-level entity set(Subtype).

 

User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
4 answers
1
go_editor asked Mar 26, 2020
1,376 views
UGC NET CSE | December 2004 | Part 2 | Question: 16
The $\text{E-R}$ model is expressed in terms of : Entities The relationship among entities The attributes of the entities Then (i) and (iii) (i) and (ii) (ii) and (iii) None of the above
The $\text{E-R}$ model is expressed in terms of :EntitiesThe relationship among entitiesThe attributes of the entitiesThen(i) and (iii)(i) and (ii)(ii) and (iii)None of t...
User Avatar
1 votes
1 votes
2 answers
2
go_editor asked Mar 26, 2020
557 views
UGC NET CSE | December 2004 | Part 2 | Question: 17
Specialization is a __________ process. Top - down Bottom - up Both (A) and (B) None of the above
Specialization is a __________ process.Top - downBottom - upBoth (A) and (B)None of the above
User Avatar
0 votes
0 votes
1 answer
3
go_editor asked Mar 26, 2020
880 views
UGC NET CSE | December 2004 | Part 2 | Question: 19
The entity type on which the __________ type depends is called the identifying owner. Strong entity Relationship Weak entity E - R
The entity type on which the __________ type depends is called the identifying owner.Strong entityRelationshipWeak entityE - R
User Avatar
0 votes
0 votes
1 answer
4
go_editor asked Mar 26, 2020
525 views
UGC NET CSE | December 2004 | Part 2 | Question: 20
Match the following : ... -d i-d, ii-c, iii-a, iv-b i-d, ii-c, iii-b, iv-a i-a, ii-b, iii-c, iv-d
Match the following :$\begin{array}{ll}\text{(i) 2NF} &\text{(a) Transitive dependencies eliminated} \\ \text{(ii) 3NF} &\text{(b) Multivalued attribute removed} \...
User Avatar
Link Copied!