1D0-541 practice question 19 of 25
Which three pieces of information did
Full set: 128 questionsIn his seminal 1970 paper, "A Relational Model of Data for Large Shared Data Banks," E. F. Codd established the foundational principles of the relational model. A key feature is that data is addressed by its value, not its physical position. To uniquely identify and retrieve any single data value, three components are necessary: the name of the relation (table), the primary key of the tuple (row), and the name of the attribute (column). The intersection of the row identified by the primary key and the specified column within the correct table pinpoints the exact data value.
A. Attribute, domain, and tuple A domain defines the set of permissible values for an attribute; it is a constraint, not a locator. A tuple is the row itself, not the unique identifier (primary key) used to find it.
B. Entity, relation name, and domain An entity is a conceptual object being modeled, whereas the relation name is its logical implementation. A domain is a constraint, not a locator for a specific value.
C. Table name, primary key, and entity An entity is a concept from the Entity-Relationship model, not a direct component for data retrieval in the relational model itself. The table (relation) name is the correct term.
1. Codd, E. F. (1970). "A Relational Model of Data for Large Shared Data Banks". Communications of the ACM, 13(6), 377–387. In Section 2.2, "Redundancy and Consistency," Codd discusses the role of primary keys in uniquely identifying tuples within a relation, which is fundamental to retrieving specific data. The model's structure inherently requires the relation name and attribute name to complete the address. DOI: https://doi.org/10.1145/362384.362685
2. Ullman, J. D., & Widom, J. (2002). A First Course in Database Systems. Prentice Hall. In Chapter 2, "The Relational Model," the text explains that a relational database consists of relations (tables), and to access data, one must specify the relation, the attribute(s) of interest, and a condition to identify the specific tuple(s), which is most precisely done using a primary key. (See Section 2.1 "What is a Relational Model?" and Section 2.2 "Defining a Relation Schema").
3. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. Chapter 3, "The Relational Data Model and Relational Database Constraints," clarifies that a relation name, a primary key value, and an attribute name are the coordinates needed to locate any single value in a relational database. (See Section 3.2.2, "Characteristics of Relations").
Keep practicing
Take the free 1D0-541 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1D0-541 practice questions
- Question 3To create a view, what are the minimal privileges that a user must have for the relations…
- Question 5Consider the following relation definitions: STUDENT( Student_Number: integer NOT NULL Na…
- Question 7Which subset of Structured Query Language (SQL) is used to limit access to a database or …
- Question 10Which statement accurately describes a characteristic of attributes?
- Question 11In a relational database, which term describes a single table consisting of rows and colu…
- Question 12Which of the following occurs in a relation when records are added or removed?
