Studies Matters

_________ relational type is the “relational ideal.” | 1:1 | M:1 | 1:M | M:N | Any attribute that is part of a key is known as a __________. | Key attribute | Key determiner | Logical attribute | Selector | The attribute B is _________ the attribute A if each value in column A determines one and only one value in column B. | Logically dependent on | Determined by | Owned by | Functionally dependent on | All primary key entries are unique, and no part of a primary key may be __________. | Zero | Null | A foreign key | A candidate key | A _________ is any key that uniquely identifies each row. | Superkey | Selective | Special | Candidate | A(n) __________ is an ordered arrangement of keys and pointers. | Table | Relationship | Superkey | Index | A _________ key is a minimal (irreducible) superkey. | Secondary | Primary | Candidate | Foreign | A CUSTOMER table’s primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of ____ integrity. | Entity | Complete | Referential | Null | The relational model’s creator, E. F. Codd, used the term relation as a synonym for ____. | Index | Table | Key | Relationship |

In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable. | Relations | Indexes | Keys | Logical Structures | The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents. | Meta dictionary | Data dictionary | Schema | System catalog | A ____ is a textual representation of the database tables where each table is listed by its name followed by the list of its attributes in parentheses. | Relational dictionary | Relational schema | Logical schema | Data dictionary | A(n) ____ is perceived as a two-dimensional structure composed of rows and columns. | Table | Attribute | Rowset |