WGU D426 V3 Data Management Foundations OA Master Study Guide | SQL, Database
Design, ERD, Keys & Normalization | 2026 Updated.
Course: D426 – Data Management – Foundations
Institution: Western Governors University (WGU)
Assessment: Objective Assessment (OA)
Version: V3
Purpose: Comprehensive OA preparation and database-concept mastery
Edition: 2026 Updated
TABLE OF CONTENTS
1. Course Alignment and OA Strategy
2. Database Fundamentals
3. Database Systems and Architecture
4. Relational Database Model
5. SQL Foundations and SQL Sublanguages
6. SQL Syntax, Identifiers, Keywords, and Literals
7. Tables and Data Types
8. NULL Values and Three-Valued Logic
9. CRUD Operations
10. Keys and Constraints
11. Referential Integrity
12. SELECT Queries
13. Filtering, Sorting, and Special Operators
14. Simple and Aggregate Functions
15. GROUP BY and HAVING
16. JOIN Operations
17. Subqueries
18. Views
19. Entity-Relationship Modeling
20. Cardinality and Modality
21. Strong, Weak, Supertype, and Subtype Entities
22. Database Design Process
23. Functional Dependencies
24. Normalization: 1NF, 2NF, 3NF, and BCNF
25. Data Storage Structures
26. Indexes
27. Query Access and Performance Concepts
28. Tablespaces and Partitioning
29. Physical Database Design
30. High-Yield Comparison Tables
31. Common OA Traps
, 32. Final Cram Sheet
33. Seven-Day Review Plan
34. Readiness Checklist
1. COURSE ALIGNMENT AND OA
STRATEGY
WGU describes Data Management Foundations as an introduction to conceptual, logical, and
physical data modeling, creation of databases and tables in SQL-enabled database systems, and
database normalization. Officially published WGU learning outcomes also identify three major
technical competencies:
Explaining attributes of databases, database tables, and SQL commands
Determining how queries create and manipulate relational data
Defining primary and foreign keys in normalization
(Western Governors University)
The current V3 material is considerably more compact than the older version. An August 2026
student report describes the current version as five ZyBooks chapters and warns that some older
V2 study resources no longer map directly to the course. (Reddit)
What this means for preparation
Do not study D426 as merely an SQL coding course.
The OA primarily requires you to understand why database concepts work, recognize the
correct terminology, and interpret SQL.
You should be able to look at:
an ER diagram and determine cardinality;
two tables and identify their primary/foreign-key relationship;
a SQL statement and predict its purpose;
a badly designed table and determine which normalization rule it violates;
an index scenario and determine which structure is most appropriate;
a database-design scenario and determine whether it represents conceptual, logical, or
physical design.
,2. DATABASE FUNDAMENTALS
Data
Data consists of raw facts that can be recorded and stored.
Examples:
2026-08-28
Customer 104
$79.99
Nairobi
Product A
Data becomes useful information when it is organized and interpreted.
Information
Information is processed or organized data that has meaning.
Example:
Raw data:
Customer Purchases
A 7
B 4
C 12
Information:
Customer C generated the most purchases.
Database
A database is an organized collection of related data.
The database itself is the data collection.
DBMS
, A Database Management System (DBMS) is software used to create, maintain, access, secure,
and manipulate databases.
Examples of relational DBMS products include:
MySQL
PostgreSQL
Microsoft SQL Server
Oracle Database
Do not confuse:
Database = stored data
DBMS = software that manages the data
Major DBMS functions
A DBMS can provide:
data storage
data retrieval
data modification
security
integrity enforcement
concurrent access
backup and recovery
metadata management
transaction management
3. DATABASE SYSTEMS AND
ARCHITECTURE
Database system
A database system generally consists of:
Database + DBMS + applications + users + supporting hardware/software
Design, ERD, Keys & Normalization | 2026 Updated.
Course: D426 – Data Management – Foundations
Institution: Western Governors University (WGU)
Assessment: Objective Assessment (OA)
Version: V3
Purpose: Comprehensive OA preparation and database-concept mastery
Edition: 2026 Updated
TABLE OF CONTENTS
1. Course Alignment and OA Strategy
2. Database Fundamentals
3. Database Systems and Architecture
4. Relational Database Model
5. SQL Foundations and SQL Sublanguages
6. SQL Syntax, Identifiers, Keywords, and Literals
7. Tables and Data Types
8. NULL Values and Three-Valued Logic
9. CRUD Operations
10. Keys and Constraints
11. Referential Integrity
12. SELECT Queries
13. Filtering, Sorting, and Special Operators
14. Simple and Aggregate Functions
15. GROUP BY and HAVING
16. JOIN Operations
17. Subqueries
18. Views
19. Entity-Relationship Modeling
20. Cardinality and Modality
21. Strong, Weak, Supertype, and Subtype Entities
22. Database Design Process
23. Functional Dependencies
24. Normalization: 1NF, 2NF, 3NF, and BCNF
25. Data Storage Structures
26. Indexes
27. Query Access and Performance Concepts
28. Tablespaces and Partitioning
29. Physical Database Design
30. High-Yield Comparison Tables
31. Common OA Traps
, 32. Final Cram Sheet
33. Seven-Day Review Plan
34. Readiness Checklist
1. COURSE ALIGNMENT AND OA
STRATEGY
WGU describes Data Management Foundations as an introduction to conceptual, logical, and
physical data modeling, creation of databases and tables in SQL-enabled database systems, and
database normalization. Officially published WGU learning outcomes also identify three major
technical competencies:
Explaining attributes of databases, database tables, and SQL commands
Determining how queries create and manipulate relational data
Defining primary and foreign keys in normalization
(Western Governors University)
The current V3 material is considerably more compact than the older version. An August 2026
student report describes the current version as five ZyBooks chapters and warns that some older
V2 study resources no longer map directly to the course. (Reddit)
What this means for preparation
Do not study D426 as merely an SQL coding course.
The OA primarily requires you to understand why database concepts work, recognize the
correct terminology, and interpret SQL.
You should be able to look at:
an ER diagram and determine cardinality;
two tables and identify their primary/foreign-key relationship;
a SQL statement and predict its purpose;
a badly designed table and determine which normalization rule it violates;
an index scenario and determine which structure is most appropriate;
a database-design scenario and determine whether it represents conceptual, logical, or
physical design.
,2. DATABASE FUNDAMENTALS
Data
Data consists of raw facts that can be recorded and stored.
Examples:
2026-08-28
Customer 104
$79.99
Nairobi
Product A
Data becomes useful information when it is organized and interpreted.
Information
Information is processed or organized data that has meaning.
Example:
Raw data:
Customer Purchases
A 7
B 4
C 12
Information:
Customer C generated the most purchases.
Database
A database is an organized collection of related data.
The database itself is the data collection.
DBMS
, A Database Management System (DBMS) is software used to create, maintain, access, secure,
and manipulate databases.
Examples of relational DBMS products include:
MySQL
PostgreSQL
Microsoft SQL Server
Oracle Database
Do not confuse:
Database = stored data
DBMS = software that manages the data
Major DBMS functions
A DBMS can provide:
data storage
data retrieval
data modification
security
integrity enforcement
concurrent access
backup and recovery
metadata management
transaction management
3. DATABASE SYSTEMS AND
ARCHITECTURE
Database system
A database system generally consists of:
Database + DBMS + applications + users + supporting hardware/software
