100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
Previously searched by you
2024 Update|WGU C175/D426 Data Management Exam | LATEST|COMPLETE FREQUENTLY MOST TESTED QUESTIONS WITH VERIFIED ANSWERS/ALREADY GREADED A+ |GET IT 100% ACCURATE!!$12.99
Add to cart
10/30/24, 7:20 AM 2024 Update|WGU C175/D426 Data Management Exam |2024-2025 LATEST|COMPLETE FREQUENTLY MOST TESTED Q…
2024 Update|WGU C175/D426 Data
Management Exam |2024-2025
LATEST|COMPLETE FREQUENTLY MOST TESTED
QUESTIONS WITH VERIFIED
ANSWERS/ALREADY GREADED A+ |GET IT 100%
ACCURATE!!
Terms in this set (328)
Refers to the MINIMUM number of times an instance
in one entity can be associated with instance of
Modality
another entity (minima). Appears as a 0 or 1 on the
relationship line, next to cardinality.
Requires that ALL foreign key values must either be
Referential Integrity
fully NULL or match some primary key value.
1. Primary key is updated 2. Foreign key is updated 3.
Ways Referential Integrity
Row containing primary key is DELETED 4. Row
can be violated
containing foreign key is INSERTED.
1. RESTRICT - rejects an insert, update, or delete 2.
Actions to Correct SET NULL - sets invalid foreign keys to null 3. SET
Referential Integrity DEFAULT - sets invalid foreign keys to a default
Violation primary value 4. CASCADE - propagates primary
key changes to foreign keys.
Important aspect of Reference to data in one relation is based on values
Referential Integrity in another relation.
Broad definition of data Raw facts captured on printed or digital media.
Facts that are collected and stored in a database
Data
system.
, 10/30/24, 7:20 AM 2024 Update|WGU C175/D426 Data Management Exam |2024-2025 LATEST|COMPLETE FREQUENTLY MOST TESTED Q…
Determining It does not follow a data model.
characteristic of
unstructured data
Flat files They contain no internal hierarchical organization.
Data retrieval before Sequentially from simple files.
database management
systems
An attribute or group of attributes that uniquely
Primary Key
identify a tuple in a relation.
Foreign Key matching A domain of values.
requirement
What uniquely identifies each entity in a collection
Alternate Key
of entities but is not the primary key.
A set of columns in a table that can uniquely identify
Candidate Key any record in that table without referring to other
data.
Database indexing The original data is copied to the index.
Indexes in physical To retrieve data DIRECTLY using a pointer.
database design
Index creation on a To optimize data retrievals.
database column
Each value of a column relates to at MOST one
Functional Dependency
value of another column.
All non-key columns depend on primary key; Each
First Normal Form (1NF) table cell contains one value; A table with no
duplicate rows.
When all non-key columns depend on the WHOLE
Second Normal Form
primary key; Must be in 1NF; Non-key column
(2NF)
cannot depend on just one part of a composite key.
All non-key columns depend ONLY on the primary
Third Normal Form (3NF)
key; Tables are totally free of data redundancy.
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 or Stuvia-credit 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 CodedNurse. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.