WGU D426 Objective Assessment V2 (Latest 2024/ 2025 Update) Data Management Foundations | Questions and Verified Answers|100% Correct| Grade A

WGU D426 Objective Assessment V2 (Latest 2024/ 2025 Update) Data Management Foundations | Questions and Verified Answers|100% Correct| Grade A Q: SUBQUERY Sometimes nested query or inner query, which is a query within another SQL query Q: ALIAS Answer: Temporary name assigned to a column or table Q: Flattening Answer: Replaces a subquery with an equivalent join Q: Entity Answer: Person, place, product, concept, or activity Q: Relationship Answer: A statement about two entities Q: Attribute Answer: Descriptive property of an entity Q: Reflexive Relationship Answer: Relates an entity to itself Q: Database Design Answer: 1.Analysis (Develops an ER model) 2.Logical Design (Converts the ER model into tables, columns, and keys) 3.Physical Design (Adds indexes and specifies how tables are organized on storage media) Q: Cardinality Answer: Maxima and Minima of relationships and attributes Q: Relationship Maximum Answer: Greatest number of instances of one entity that can relate to a single instance of another entity Q: Relationship Minimum Least number of instances of