D426 Data Management - Foundations Chapter 2 Exam Containing 74 Questions & Answers Updated 2024.

D426 Data Management - Foundations Chapter 2




D426 Data Management - Foundations
Chapter 2 Exam Containing 74
Questions & Answers Updated 2024.
Database Model - Answer: A conceptual framework for database systems, with 3
parts.
Data Structures
Operations
Rules


Data Structures - Prescribe how data is organized
Operations - Manipulate data structures
Rules - Govern valid data - Answer: 3 parts of a database model.

, D426 Data Management - Foundations Chapter 2


Relational Model - Answer: A database model based on a tabular data structure.


Big Data - Answer: The rise of the internet in the 1990's generated this. Data
characterized by unprecedented data volumes and rapidly changing data
structures.


Set - Answer: An unordered collection of elements enclosed in braces.
Ex: {a, b, c} and {c, b, a} are the same since unordered.


Tuple - Answer: An ordered collection of elements enclosed in parentheses.
Ex: (a, b, c) and (c, b, a) are different since ordered.


Table - Answer: Has a name, fixed tuple of columns, and a varying set of rows.


Column - Answer: Has a name and a data type.


Row - Answer: An unnamed tuple of values. Each value corresponds to a column
and belongs to the column's data type.


Data type - Answer: A named set of values where column values are drawn.


Relational Algebra - Answer: The theoretical foundation of the SQL language.


Relational Rules - Answer: Part of the relational modern and govern data in every
database.