100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
WGU C170 Data Management - Applications $8.99   Add to cart

Exam (elaborations)

WGU C170 Data Management - Applications

 5 views  0 purchase
  • Course
  • Institution

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

[Show more]

Preview 1 out of 4  pages

  • July 21, 2022
  • 4
  • 2021/2022
  • Exam (elaborations)
  • Questions & answers
avatar-seller
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

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

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

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 $8.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

72042 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$8.99
  • (0)
  Add to cart