Consider the following statements: Statement I: Composite attributes cannot be…
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 multivalued 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 ?
- A.
Statement I, Statement II and Statement III are true
- B.
Statement I true and Statement II, Statement III false
- C.
Statement I, Statement II true and Statement III false
- D.
Statement I false and Statement II, Statement III true
Attempted by 1437 students.
Show answer & explanation
Correct answer: D
Final evaluation: Statement I is false; Statement II and Statement III are true.
Statement I: This is false. A composite attribute can be divided into smaller subparts. Example: an Address attribute can be split into Street, City, and Zip.
Statement II: This is true. A complex attribute can be formed by nesting composite and multivalued attributes (for example, a contact attribute that is multivalued and whose entries are themselves composite).
Statement III: This is true. A derived attribute's values are computed from other attribute(s), for example Age derived from Birthdate.
Conclusion: The correct evaluation is that Statement I is false while Statement II and Statement III are true.
A video solution is available for this question — log in and enroll to watch it.