Computer Science > QUESTIONS & ANSWERS > WGU C170 - Data Management – Applications Questions and Answers Graded A+ (All)

WGU C170 - Data Management – Applications Questions and Answers Graded A+

Document Content and Description Below

WGU C170 - Data Management – Applications Questions and Answers Graded A+ Domain ✔✔In data modeling, the construct used to organize and describe an attribute's set of possible values. Prima ... ry key (PK) ✔✔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 ✔✔One or more attributes that determine other attributes. Determination ✔✔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 ✔✔Any attribute in a specific row whose value directly determines other values in that row. Dependent ✔✔An attribute whose value is determined by another attribute. Full functional dependence ✔✔A condition in which an attribute is functionally dependent on a composite key but not on any subset of the key. Composite key ✔✔A multiple-attribute key. Key attributes ✔✔The attributes that form a primary key Superkey ✔✔An attribute or attributes that uniquely identify each entity in a table. Candidate key ✔✔A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. Entity integrity ✔✔The property of a relational table that guarantees each entity has a [Show More]

Last updated: 3 years ago

Preview 1 out of 22 pages

Buy Now

Instant download

We Accept: