Statement I: Composite attributes cannot be divided into smaller subparts. Statement II: Complex attributes are formed by nesting composite and multivalued attributes in an arbitrary way. Statement III: A derived attribute is one whose values are computed from other attributes. Which is correct?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. Statement I false and Statements II, III true
Explanation
Composite attributes can be divided into parts (I false). II and III are the standard definitions of complex and derived attributes.
More Database Management Systems questions
- The order of a leaf node in a B+ tree is the maximum number of (value, data record pointer) pairs it can hold. Given a block size of 1K byt…
- Which of the DBMS component ensures that concurrent execution of multiple operations on the database results into a consistent database sta…
- Consider following two statements: Statement I: Relational database schema represents the logical design of the database. Statement II: Cur…
- Given a fixed‐length record file that is ordered B on the key field. The file needs disk blocks to R store number of records. Find the aver…
- Given the following STUDENT‐COURSE scheme: STUDENT (Rollno, Name, courseno) COURSE (courseno, coursename, capacity), where Rollno is the pr…
- Given STUDENT(Rollno, Name, Courseno) and COURSE(Courseno, Coursename, Capacity) with 5 and 3 records, R = STUDENT × COURSE is computed. Ma…