UGC NET COMPUTER SCIENCE SOLVED PAPERS 2014-16 - UGC NET Computer Science Paper 3 August 2016

12. Which one of the following pairs is correctly matched in the context of database design?

List – IList – II
(Database term)(Definition)
I. SpecializationA. Result of taking the union of two or more disjoint (lower-level) entity sets to produce a higher-level entity set.
II. GeneralizationB. Express the number of entities to which another entity can be associated via a relationship set.
III. AggregationC. Result of taking a subset of a higher-level entity set to form a lower-level entity set.
IV. Mapping cardinalitiesD. An abstraction in which relationship sets (along with their associated entity sets) are treated as higher-level entity sets, and can participate in relationships.

Codes:

 IIIIIIIV
(1)DABC
(2)DCBA
(3)CDAB
(4)CADB

  • Option : D
  • Explanation :
  • Result of taking a subset of a higher-level entity set to form a lower-level entity set is Specialization
  • Result of taking the union of two or more disjoint(lower-level) entity sets to produce a higher-level entity set is Generalization
  • An abstraction in which relationship sets (along with their associated entity sets) are treated as higher-level entity sets, and can participate in relationships.Aggregation
  • Express the number of entities to which another entity can be associated via a relationship set Mapping cardinalities
  • So, option (D) is correct.
Cancel reply
Cancel reply