Q90.Marks: +2.0UGC NET Paper 2: Computer Science 8th Oct 2022
Consider the following statements:
Statement I: Composite attributes cannot be divided into smaller subparts.
Statement II: Complex attribute is formed by nesting composite attributes and multi- valued attributes in an arbitrary way.
Statement III: A derived attribute is an attribute whose values are computed from other attribute.
Which of the following is correct?
1.Statement I, Statement II and Statement III are true
2.Statement I true and Statement II, Statement III false
3.Statement I, Statement II true and Statement III false
4.Statement I false and Statement II, Statement III true✓ Correct
Solution
Statement I: Composite attributes cannot be divided into smaller subparts. Explanation - False. Composite attributes can be divided into smaller subparts which represent more basic attributes and have independent meaning.
Statement II: Complex attribute is formed by nesting composite attributes and multi- valued attributes in an arbitrary way. Explanation - True. The multi-valued and composite attributes are called 'Components' of complex attributes.
Statement III: A derived attribute is an attribute whose values are computed from other attribute. Explanation - True. Derived attributes comprises of basic attributes.