WGU C170 - Data Management - Applications

Document Content and Description Below

Domain Correct Answer: In data modeling, the construct used to organize and describe an attribute's set of possible values. Primary key (PK) Correct Answer: An identifier composed of one or more ... attributes that uniquely identifies a row. Also, a candidate key selected as a unique entity identifier. A minimal superkey. Key Correct Answer: One or more attributes that determine other attributes. Determination Correct Answer: 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. Determinant Correct Answer: Any attribute in a specific row whose value directly determines other values in that row. Dependent Correct Answer: An attribute whose value is determined by another attribute. Full functional dependence Correct Answer: A condition in which an attribute is functionally dependent on a composite key but not on any subset of the key. Composite key Correct Answer: A multiple-attribute key. Key attributes Correct Answer: The attributes that form a primary key Superkey Correct Answer: An attribute or attributes that uniquely identify each entity in a table. Candidate key Correct Answer: A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. Entity integrity Correct Answer: 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. Null Correct Answer: The absence of an attribute value. Foreign key Correct Answer: An attribute or attributes in one table whose values must match the primary key in another table or whose values must be null. Referential integrity [Show More]

Last updated: 3 years ago

Preview 1 out of 18 pages

Buy Now

Instant download

We Accept: