• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 2 fuera de 14 páginas
Examen

WGU D426 - Data Management Foundations: Study Guide

Document preview thumbnail
Vista previa 2 fuera de 14 páginas

WGU D426 - Data Management Foundations: Study Guide (V2) Disclaimer: This guide is a synthesis of standard data management principles and common WGU course objectives. Always refer to the official WGU course materials, cohort videos, and syllabus as your primary sources. This is for illustrative study and concept reinforcement. Chapter 1: Data & Database Concepts Q1: What is the primary purpose of a database? ANSWER To provide an organized, persistent, and secure repository for structured data that can be efficiently retrieved and managed by multiple users and applications. Q2: Define "data redundancy" in a database context. ANSWER Data redundancy occurs when the same piece of data is stored in multiple places within a database, leading to potential inconsistencies, wasted storage, and update anomalies. Q3: What is the key difference between data and information? ANSWER Data are raw, unorganized facts (e.g., the number 42). Information is data that has been processed, organized, and contextualized to be meaningful and useful (e.g., "42° Celsius is the patient's body temperature"). Q4: What is a Database Management System (DBMS)? ANSWER A software application (e.g., MySQL, Oracle) that interacts with end-users, applications, and the database itself to capture, analyze, and manage data. It provides controlled access and administrative operations. Q5: List three advantages of using a DBMS over file-based systems. ANSWER 1. Reduced data redundancy. 2. Improved data integrity and consistency. 3. Enhanced security and controlled access. 4. Concurrent access and crash recovery. 5. Data abstraction and independence. Q6: What is the role of metadata? ANSWER Metadata is "data about data." It describes the structure, constraints, type, and relationships of data elements within the database (e.g., the schema). Q7: What is a data anomaly? Name one type. ANSWER A data anomaly is an inconsistency or error in the data, often caused by redundancy. An update anomaly occurs when changing data in one location requires the same change in multiple locations, risking inconsistency. Chapter 2: Relational Model & Terminology Q8: In the relational model, what is a relation? ANSWER A relation is a two-dimensional table with rows (tuples) and columns (attributes). It must have distinct rows and single-valued, atomic attributes. Q9: What is a tuple? ANSWER A tuple is a single, horizontal row in a relation (table), representing a unique instance or record of the entity. Q10: What is an attribute? ANSWER An attribute is a named vertical column in a relation, representing a characteristic or property of the entity (e.g., CustomerID, LastName). Q11: What is a domain in the context of an attribute? ANSWER The domain defines the set of all possible valid values for an attribute (e.g., the domain for a "Grade" attribute might be {'A', 'B', 'C', 'D', 'F'}). Q12: What is a candidate key? ANSWER A candidate key is a minimal set of one or more attributes that uniquely identifies each tuple in a relation. A relation can have multiple candidate keys. Q13: What is the primary key (PK)? ANSWER The primary key is the candidate key selected by the database designer to be the primary means of uniquely identifying tuples within a relation. It must contain unique and non-NULL values. Q14: What is a foreign key (FK)? ANSWER A foreign key is an attribute (or set of attributes) in one relation that references the primary key of another relation. It establishes and enforces a logical link between the data in the two tables.

Vista previa del contenido

WGU D426 - Data Management Foundations: Study Guide (V2)
Disclaimer: This guide is a synthesis of standard data management principles and
common WGU course objectives. Always refer to the official WGU course materials,
cohort videos, and syllabus as your primary sources. This is for illustrative study and
concept reinforcement.




Chapter 1: Data & Database Concepts
Q1: What is the primary purpose of a database?
ANSWER ✓ To provide an organized, persistent, and secure repository for structured
data that can be efficiently retrieved and managed by multiple users and applications.

Q2: Define "data redundancy" in a database context.
ANSWER ✓ Data redundancy occurs when the same piece of data is stored in multiple
places within a database, leading to potential inconsistencies, wasted storage, and
update anomalies.

Q3: What is the key difference between data and information?
ANSWER ✓ Data are raw, unorganized facts (e.g., the number 42). Information is data
that has been processed, organized, and contextualized to be meaningful and useful
(e.g., "42° Celsius is the patient's body temperature").

Q4: What is a Database Management System (DBMS)?
ANSWER ✓ A software application (e.g., MySQL, Oracle) that interacts with end-users,
applications, and the database itself to capture, analyze, and manage data. It provides
controlled access and administrative operations.

Q5: List three advantages of using a DBMS over file-based systems.
ANSWER ✓ 1. Reduced data redundancy. 2. Improved data integrity and consistency. 3.
Enhanced security and controlled access. 4. Concurrent access and crash recovery. 5.
Data abstraction and independence.

Q6: What is the role of metadata?
ANSWER ✓ Metadata is "data about data." It describes the structure, constraints, type,
and relationships of data elements within the database (e.g., the schema).

, Q7: What is a data anomaly? Name one type.
ANSWER ✓ A data anomaly is an inconsistency or error in the data, often caused by
redundancy. An update anomaly occurs when changing data in one location requires
the same change in multiple locations, risking inconsistency.




Chapter 2: Relational Model & Terminology
Q8: In the relational model, what is a relation?
ANSWER ✓ A relation is a two-dimensional table with rows (tuples) and columns
(attributes). It must have distinct rows and single-valued, atomic attributes.

Q9: What is a tuple?
ANSWER ✓ A tuple is a single, horizontal row in a relation (table), representing a unique
instance or record of the entity.

Q10: What is an attribute?
ANSWER ✓ An attribute is a named vertical column in a relation, representing a
characteristic or property of the entity (e.g., CustomerID, LastName).

Q11: What is a domain in the context of an attribute?
ANSWER ✓ The domain defines the set of all possible valid values for an attribute (e.g.,
the domain for a "Grade" attribute might be {'A', 'B', 'C', 'D', 'F'}).

Q12: What is a candidate key?
ANSWER ✓ A candidate key is a minimal set of one or more attributes that uniquely
identifies each tuple in a relation. A relation can have multiple candidate keys.

Q13: What is the primary key (PK)?
ANSWER ✓ The primary key is the candidate key selected by the database designer to
be the primary means of uniquely identifying tuples within a relation. It must contain
unique and non-NULL values.

Q14: What is a foreign key (FK)?
ANSWER ✓ A foreign key is an attribute (or set of attributes) in one relation that
references the primary key of another relation. It establishes and enforces a logical link
between the data in the two tables.

Información del documento

Subido en
8 de enero de 2026
Número de páginas
14
Escrito en
2025/2026
Tipo
Examen
Contiene
Preguntas y respuestas
$13.59

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
SmartscoreAaron
3.1
(7)
Vendido
96
Seguidores
6
Artículos
4154
Última venta
1 semana hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes