Skip to content
CramShare
PremiumPractice exam

Wgu C175/D426 Data Management Foundations

C175 C 175 · Western Governors University

Updated today

Health Care exam material, 95 pages. Originally published on StudyMerit.

Pages
95
Academic year
2025/2026
Language
English

What’s included

Preview 3 of 95 pages

See the first 3 pages exactly as they appear in the document.

Read page 1 as text

WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA EXAM 2023-2024 ACTUAL EXAM 2 LATEST VERSIONS 300 QUESTIONS AND CORRECT DETAILED ANSWERS WITH RATIONALES (100% CORRECT AND VERIFIED ANSWERS)|ALREADY GRADED A+ written by johnkabiru www.stuvia.com Downloaded by: awilczynski | awilczynski@hotmail.com Distribution of this document is illegal Want to earn $1.236 extra per year?

Read page 2 as text

WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA EXAM 2023 - 2024 ACTUAL EXAM 2 LATEST VERSIONS 300 QUESTIONS AND CORRECT DETAILED ANSWERS WITH RATIONALES (100% CORRECT AND VERIFIED ANSWERS)|ALREADY GRADED A+ VERSIO N A What does modality refer to? How does it appear on ER diagram? - ANSWER - Refers to the MINIMUM number of times an instance in one entity can be associated with instance of another entity (minima) Appears as a 0 or 1 on the relationship line, next to cardi nality Define: Referential Integrity - ANSWER - Requires that ALL foreign key values must either be fully NULL or match some primary key value 4 Ways Referential Integrity can be violated: - ANSWER - 1. Primary key is updated 2. Foreign key is updated 3. R ow containing primary key is DELETED 4. Row containing foreign key is INSERTED 4 Actions to Correct Referential Integrity Violation: - ANSWER - 1. RESTRICT - rejects an insert, update, or delete 2. SET NULL - sets invalid foreign keys to null 3. SET DEFAUL T - sets invalid foreign keys to a default primary value 4. CASCADE - propagates primary key changes to foreign keys What is an important aspect to referential integrity? - ANSWER - reference to data in one relation is based on values in another relation Stuvia.com - The Marketplace to Buy and Sell your Study Material Downloaded by: awilczynski | awilczynski@hotmail.com Distribution of this document is illegal Want to earn $1.236 extra per year?

Read page 3 as text

Stuvia.com - The Marketplace to Buy and Sell your Study Material What is a broad definition of data? - ANSWER - Raw facts captured on printed or digital media What are data? - ANSWER - Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? - ANSWER - It does no t follow a data model What is true about flat files? - ANSWER - - They contain no internal hierarchical organization How were data retrieved before database management systems? - ANSWER - Sequentially from simple files What is an attribute or group of attributes that uniquely identify a tuple in a relation? - ANSWER - Primary Key What is necessary for a primary key in on e relation of a database to match with its corresponding foreign key in another relation of the same database? - ANSWER - A domain of values What uniquely identifies each entity in a collection of entities but is not the primary key? - ANSWER - Alternate Ke y What is the term for a set of columns in a table that can uniquely identify any record in that table without referring to other data? - ANSWER - Candidate Key What happens to the original data in database indexing? - ANSWER - It is copied to the index W hy are indexes created in a physical database design? - ANSWER - To retrieve data DIRECTLY using a pointer Why is an index created on a database column? - ANSWER - To optimize data retrievals Define: Functional Dependency - ANSWER - Each value of a column r elates to at MOST one value of another column Dependence of one column on another Stuvia.com - The Marketplace to Buy and Sell your Study Material Downloaded by: awilczynski | awilczynski@hotmail.com Distribution of this document is illegal Want to earn $1.236 extra per year?

92 more pages after this

You’ve read 3 of 95. Unlock once and it stays in your library — and if the rest doesn’t match what you just read, you get a refund.

$10.00

Yours permanently