WGU C170 Data Management - Applications
domain Correct Answer: In data modeling, the construct used to organize and describe an attribute's set of possible values
superkey Correct Answer: An attribute or attributes that uniquely identify each entity in a table. Any composite key with this i...
WGU C170 Data Management - Applications
domain Correct Answer: In data modeling, the construct used to organize and describe an attribute's set
of possible values
superkey Correct Answer: An attribute or attributes that uniquely identify each entity in a table. Any
composite key with this is also this.
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
referential integrity Correct Answer: 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 Correct Answer: 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 Correct Answer: A detailed system data dictionary that describes all objects in a
database
homonym Correct Answer: The use of the same name to label different attributes, much like similar-
sounding words with different meanings
synonym Correct Answer: 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 Correct Answer: Any candidate key must have these two constraints enforced
cardinality Correct Answer: Term for how many instances of one object are related to instances of
another object (maximum)
modality Correct Answer: Term for whether an instance of a specific entity is optional or mandatory in a
relationship (minimum)
connectivity Correct Answer: Term for the classification of the relationship between entities.
Classifications include 1:1, 1:M, and M:N
CREATE SCHEMA AUTHORIZATION Correct Answer: SQL command to create a database schema
DEFAULT Correct Answer: SQL option to define a default value for a column (when no value is given)
CHECK Correct Answer: SQL command to validate data in an attribute, used during table column
creation
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Classroom. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £7.06. You're not tied to anything after your purchase.
