Extended E-R Features

Question 1
Marks : +2 | -2
Pass Ratio : 100%
The process of designating sub groupings within the entity set is called as _______
Specialization
Division
Aggregation
Finalization
Explanation:
The process of designating sub-groupings within the entity set is called as specialization. Specialization allows us to distinguish among entities.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
________ is an abstraction through which relationships are treated as higher level entities
Creation
Superseding
Attribute separation
Aggregation
Explanation:
One limitation of E-R model is that it cannot express relationships among relationships. Thus for this purpose, aggregation is used. Aggregation is an abstraction through which relationships are treated as higher level entities.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is not a generalization constraint?
Condition-defined
User defined
Disjoint
Machine defined
Explanation:
Machine definition is not a generalization constraint. Condition defined, user defined, disjoint and overlapping are 4 generalization constraints.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
State true or false: Specialization can be applied only once
True
False
Explanation:
We can apply specialization multiple times to refine a design. An entity set may also be specialized by more than one distinguishing feature.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
The similarities between the entity set can be expressed by which of the following features?
Specialization
Generalization
Uniquation
Inheritance
Explanation:
The similarities between the entity set can be expressed by the generalization feature. It is a containment o the relationship that exists between a higher level entity set and one or more lower level entity sets.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
Higher level entity sets are designated by the term _________
Sub class
Super class
Parent class
Root class
Explanation:
Higher level entity sets can also be designated by the term super class. In the similar manner lower level entity sets can also be designated by the term sub class.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
Condition defined generalization constraint is also said to be ________
Attribute defined
Constraint defined
Value defined
Undefined
Explanation:
Condition defined generalization constraint is also said to be attribute defined.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
If each higher level entity belongs to the lower level entity, then what kind of generalization is it?
Modal generalization
Partial generalization
Total generalization
None of the mentioned
Explanation:
If each higher level entity belongs to the lower level entity then it is called as total generalization. It is also called as total specialization. If some higher level entities do not belong, it is called as partial generalization.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is the specialization that permits multiple sets
Superclass specialization
Disjoint specialization
Overlapping specialization
None of the mentioned
Explanation:
Overlapping specialization is the type of specialization that permits multiple sets. But disjoint specialization does not permit multiple sets. Disjoint specialization permits at most one set.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
State true or false: The attributes of the higher level entity sets are inherited by the attributes of the lower level entity sets
True
False
Explanation:
The attributes of the higher level entity sets are inherited by the attributes of the lower level entity sets. But the inverse is not true in this case.