WGU C170 Data Management –
Applications All Solutions Complete
domain Ans- In data modeling, the construct used to organize and describe an attribute's set of possible
values
superkey Ans- An attribute or attributes that uniquely identify each entity in a table. Any composite key
with this is also this.
candidate key Ans- A minimal superkey; that is, a key that does not contain a subset of attributes that is
itself a superkey
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
referential integrity Ans- A 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 Ans- A DBMS component that stores metadata. It contains the data definition & their
characteristics and relationships; may also include data external to the DBMS
system catalog Ans- A detailed system data dictionary that describes all objects in a database
homonym Ans- The use of the same name to label different attributes, much like similar-sounding words
with different meanings
synonym Ans- The 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 Ans- Any candidate key must have these two constraints enforced
, cardinality Ans- Term for how many instances of one object are related to instances of another object
(maximum)
modality Ans- Term for whether an instance of a specific entity is optional or mandatory in a relationship
(minimum)
connectivity Ans- Term for the classification of the relationship between entities. Classifications include
1:1, 1:M, and M:N
CREATE SCHEMA AUTHORIZATION Ans- SQL command to create a database schema
DEFAULT Ans- SQL option to define a default value for a column (when no value is given)
CHECK Ans- SQL command to validate data in an attribute, used during table column creation
CREATE TABLE AS Ans- SQL command to create a new table based on a query in the user's database
schema
HAVING Ans- SQL option that restricts a selection of grouped rows based on a condition
EXISTS Ans- SQL option that checks whether a subquery returns any rows
DECIMAL Ans- SQL data type like the NUMBER specification, but the storage length is a minimum
specification
True Ans- True or false: if an INSERT or SELECT command is embedded inside a program for later use,
the attribute list should always be used, as the table may change over time
inner join Ans- A join operation in which only rows that meet a given criterion are selected. The most
common type of join
Applications All Solutions Complete
domain Ans- In data modeling, the construct used to organize and describe an attribute's set of possible
values
superkey Ans- An attribute or attributes that uniquely identify each entity in a table. Any composite key
with this is also this.
candidate key Ans- A minimal superkey; that is, a key that does not contain a subset of attributes that is
itself a superkey
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
referential integrity Ans- A 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 Ans- A DBMS component that stores metadata. It contains the data definition & their
characteristics and relationships; may also include data external to the DBMS
system catalog Ans- A detailed system data dictionary that describes all objects in a database
homonym Ans- The use of the same name to label different attributes, much like similar-sounding words
with different meanings
synonym Ans- The 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 Ans- Any candidate key must have these two constraints enforced
, cardinality Ans- Term for how many instances of one object are related to instances of another object
(maximum)
modality Ans- Term for whether an instance of a specific entity is optional or mandatory in a relationship
(minimum)
connectivity Ans- Term for the classification of the relationship between entities. Classifications include
1:1, 1:M, and M:N
CREATE SCHEMA AUTHORIZATION Ans- SQL command to create a database schema
DEFAULT Ans- SQL option to define a default value for a column (when no value is given)
CHECK Ans- SQL command to validate data in an attribute, used during table column creation
CREATE TABLE AS Ans- SQL command to create a new table based on a query in the user's database
schema
HAVING Ans- SQL option that restricts a selection of grouped rows based on a condition
EXISTS Ans- SQL option that checks whether a subquery returns any rows
DECIMAL Ans- SQL data type like the NUMBER specification, but the storage length is a minimum
specification
True Ans- True or false: if an INSERT or SELECT command is embedded inside a program for later use,
the attribute list should always be used, as the table may change over time
inner join Ans- A join operation in which only rows that meet a given criterion are selected. The most
common type of join
