WGU D412 Latest Update with complete solutions Of
Questyions And Answers Guarantee An A+ Grade
RELATIONAL DATABASE CONCEPTS
Functional Dependency โ Relationship where one attributeโs value determines anotherโs
Determinant โ Attribute used to determine the value of another attribute
Candidate Key โ Unique, minimal attribute(s) that identify every non-key attribute
Primary Key โ Column(s) used to uniquely identify a row
Foreign Key โ Non-unique key that references a primary key
SQL LANGUAGE CATEGORIES
DDL (Data Definition Language) โ Defines & manages database structures (CREATE, DROP,
ALTER, TRUNCATE, RENAME)
DML (Data Manipulation Language) โ Adds, deletes, modifies stored data
DCL (Data Control Language) โ Manages users, permissions, access
TCL (Transaction Control Language) โ COMMIT and ROLLBACK
DQL (Data Query Language) โ Retrieves data
VIEWS & METADATA
Materialized View โ Stored view; uses memory; updates when base data changes
Virtual View โ Not stored; computed when accessed
Metadata โ Data about data (tables, columns, data types)
Base Table โ Table referenced in a view
DATABASE STORAGE & ACCESS
Table Scan โ Reads table blocks directly
Index Scan โ Reads index blocks to locate table data
Binary Search โ Index search by repeatedly splitting in half
Tablespace โ Maps tables to a single physical file
