WGU D426 0A Data Management
Foundations LATEST NEW EXAM 2026
(COMPLIED FROM REAL EXAM) 100%
|SOLVED
Putting tables back together into a single table for business needs. Used in place
of a join to speed up a query, but it uses more space, data redundant,
modification anomalies.
Denormalization
Multiple values removed. Only one value in each cell.
First Normal Form
No partial dependencies. All non-key columns depend on the whole primary key.
Second Normal Form
No transitive dependencies (Functional dependencies on non-primary-key attributes.
Called transitive because the primary key is a determinant for another attribute,
which in turn is a determinant for a third. Solution: Non-key determinant with
transitive dependencies goes into a new table; non-key determinant becomes
primary key in the new table and remains as a foreign key in the old table).
Third Normal Form
Every determinate is also a candidate key during normalization. Optimal normal
form for frequent inserts, updates, and deletes. One key is a super key. If Column
A depends on Column B, then B must be unique.
Boyce-Codd Normal Form
Gets data from the left table that's not in the right table.
Left Outer Join
Gets data from the right table that's not in the left table.
Right Outer Join
, Unmatched data from either table is included. Will result in empty fields.
Full Outer Join
Specifies tables, columns, and keys. Implements database requirements in a
specific database system. Also called a schema.
Logical Design
Specifies indexes, table structures, and partitions. Specifies how tables are
organized on storage media.
Physical Design
Components of a computer system and the relationships between components.
Architecture
Interact directly with database users and administrators and send queries to the
query processor. Includes Connectors & APIs, Workbench, and utility programs.
Tools
Interprets queries. Compiles queries into low-level instructions for the storage
engine. Creates a plan to modify the database or retrieve data, and returns query
results to the application.
Query Processor
Link between tools and query processor
Connection
Foundations LATEST NEW EXAM 2026
(COMPLIED FROM REAL EXAM) 100%
|SOLVED
Putting tables back together into a single table for business needs. Used in place
of a join to speed up a query, but it uses more space, data redundant,
modification anomalies.
Denormalization
Multiple values removed. Only one value in each cell.
First Normal Form
No partial dependencies. All non-key columns depend on the whole primary key.
Second Normal Form
No transitive dependencies (Functional dependencies on non-primary-key attributes.
Called transitive because the primary key is a determinant for another attribute,
which in turn is a determinant for a third. Solution: Non-key determinant with
transitive dependencies goes into a new table; non-key determinant becomes
primary key in the new table and remains as a foreign key in the old table).
Third Normal Form
Every determinate is also a candidate key during normalization. Optimal normal
form for frequent inserts, updates, and deletes. One key is a super key. If Column
A depends on Column B, then B must be unique.
Boyce-Codd Normal Form
Gets data from the left table that's not in the right table.
Left Outer Join
Gets data from the right table that's not in the left table.
Right Outer Join
, Unmatched data from either table is included. Will result in empty fields.
Full Outer Join
Specifies tables, columns, and keys. Implements database requirements in a
specific database system. Also called a schema.
Logical Design
Specifies indexes, table structures, and partitions. Specifies how tables are
organized on storage media.
Physical Design
Components of a computer system and the relationships between components.
Architecture
Interact directly with database users and administrators and send queries to the
query processor. Includes Connectors & APIs, Workbench, and utility programs.
Tools
Interprets queries. Compiles queries into low-level instructions for the storage
engine. Creates a plan to modify the database or retrieve data, and returns query
results to the application.
Query Processor
Link between tools and query processor
Connection
