WGU C170 Data Management(with correct answers)
domain correct answersIn data modeling, the construct used to organize and describe an
attribute's set of possible values
superkey correct answersAn attribute or attributes that uniquely identify each entity in a table.
Any composite key with this is also this.
candidate key correct answersA minimal superkey; that is, a key that does not contain a subset of
attributes that is itself a superkey
entity integrity correct answersThe 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
referential integrity correct answersA condition by which a dependent table's foreign key must
have either a null entry or a matching entry in the related table
data dictionary correct answersA DBMS component that stores metadata. It contains the data
definition & their characteristics and relationships; may also include data external to the DBMS
system catalog correct answersA detailed system data dictionary that describes all objects in a
database
homonym correct answersThe use of the same name to label different attributes, much like
similar-sounding words with different meanings
synonym correct answersThe use of different names to identify the same object, such as an
entity, an attribute, or a relationship. These should generally be avoided.
not null and unique correct answersAny candidate key must have these two constraints enforced
cardinality correct answersTerm for how many instances of one object are related to instances of
another object (maximum)
modality correct answersTerm for whether an instance of a specific entity is optional or
mandatory in a relationship (minimum)
connectivity correct answersTerm for the classification of the relationship between entities.
Classifications include 1:1, 1:M, and M:N
CREATE SCHEMA AUTHORIZATION correct answersSQL command to create a database
schema
DEFAULT correct answersSQL option to define a default value for a column (when no value is
given)
domain correct answersIn data modeling, the construct used to organize and describe an
attribute's set of possible values
superkey correct answersAn attribute or attributes that uniquely identify each entity in a table.
Any composite key with this is also this.
candidate key correct answersA minimal superkey; that is, a key that does not contain a subset of
attributes that is itself a superkey
entity integrity correct answersThe 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
referential integrity correct answersA condition by which a dependent table's foreign key must
have either a null entry or a matching entry in the related table
data dictionary correct answersA DBMS component that stores metadata. It contains the data
definition & their characteristics and relationships; may also include data external to the DBMS
system catalog correct answersA detailed system data dictionary that describes all objects in a
database
homonym correct answersThe use of the same name to label different attributes, much like
similar-sounding words with different meanings
synonym correct answersThe use of different names to identify the same object, such as an
entity, an attribute, or a relationship. These should generally be avoided.
not null and unique correct answersAny candidate key must have these two constraints enforced
cardinality correct answersTerm for how many instances of one object are related to instances of
another object (maximum)
modality correct answersTerm for whether an instance of a specific entity is optional or
mandatory in a relationship (minimum)
connectivity correct answersTerm for the classification of the relationship between entities.
Classifications include 1:1, 1:M, and M:N
CREATE SCHEMA AUTHORIZATION correct answersSQL command to create a database
schema
DEFAULT correct answersSQL option to define a default value for a column (when no value is
given)
