WGU C170 - Data Management : Cards Questions & Correct Answers | Grade A+

AREA Ans- In DB2, a named section of permanent storage space that is reserved to store the database. candidate key Ans- A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. closure Ans- A property of relational operators that permits the use of relational algebra operators on existing tables (relations) to produce new relations. composite entity Ans- An entity designed to transform an M:N relationship into two 1:M relationships. The composite entity's primary key comprises at least the primary keys of the entities that it connects. Also known as a bridge entity or associative entity. composite key Ans- A multiple-attribute key. dependent Ans- An attribute whose value is determined by another attribute. determination Ans- The role of a key. In the context of a database table, the statement "A determines B" indicates that knowing the value of attribute A means that the value of attribute B can be looked up. DIFFERENCE Ans- In relational algebra, an operator used to yield all rows from one table that are not found in another union-compatible table. DIVIDE Ans- In relational algebra, an operator that answers queries about one set of data being associated with all values of data in another set of data. domain Ans- In data modeling, the construct used to organize and describe an attribute's set of possible values. entity integrity Ans- The property of a relational table that guarantees each entity has a unique value in a primary key and that the key has no null values. equijoin Ans- A join operator that links tables based on an equality condition that compares specified columns of the tables. flags Ans- Special codes implemented by designers to trigger a required response, alert end users to specifie