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 uniq
...
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]