D426 Data Management Foundations Study guides, Class notes & Summaries

D426 DATA MANAGEMENT FOUNDATIONS OA EXAM 2 ACTUAL QUESTIONS AND VERIFIED SOLUTIONS 2024/2025 (WGU C175) VERSION A What does modality refer to? How does it appear on ER diagram? - CORRECT ANSWER - Refers to the MINIMUM number of times an instance in one entity can be associated with instance of another entity (minima) Appears as a 0 or 1 on the relationship line, next to cardinality Define: Referential Integrity - CORRECT ANSWER - Requires that ALL foreign key values must either be full...

data Numeric, textual, visual, or audio information that describes real-world systems scope, format, and access 3 ways data can vary scope the amount of data produced and collected format describes that data may be produced as numbers, text, image, audio, or video access describes that some data sets may be private while others are made publicly available analog historically, most data was ____, encoded as continuous variations on various physical media digita...

What Is a software that reads and writes data in a database? Database management system or DBMS What is a computer programming language for writing database queries? Query language What is a command for a database that typically inserts new data, retrieves data, updates data, or deletes data from a database Query What is a group of queries that must be either completed or rejected as a whole? A transaction What Interprets queries, creates a plan to modify the database...

Database object that maps one or more tables to a single file. Tablespace 3 multiple choice options Specifies tables, columns, and keys. Implements database requirements in a specific database system. Also called a schema. Logical Design 3 multiple choice options Specifies indexes, table structures, and partitions. Specifies how tables are organized on storage media. Physical Design 3 multiple choice options Components of a computer system and the relationships between compo...

The relationship (within the relation) that describes how the value of one attribute may be used to find the value of another attribute. Functional Dependency 3 multiple choice options An attribute that can be used to find the value of another attribute in the relation. Determinant 3 multiple choice options Value can be used to find the value of every other non-key attribute in the table. Unique and minimal. Candidate Key 3 multiple choice options Define & manage database st...

Data numeric , textual , visual or audio information that describes real-world systems. varies in ways such as scope, format, access. analog data Historically most common before computers, encoded as continuous variations on various physical media. digital data most common today, recorded as 0's and 1's on electronic and magnetic media. database designer determines the format of each data element and the overall database structure database user a consumer of data in a...

The relationship that describes how one attribute's value can determine another's Functional Dependency An attribute determining the value of another attribute Determinant Unique and minimal attribute determining non-key attributes Candidate Key Defines and manages database structures DDL Manipulates data: adding, deleting, modifying DML Manages user accounts and permissions DCL Commands: CREATE, DROP, ALTER, TRUNCATE, RENAME DDL Stored v...

Database Application Software that helps business users interact with database systems. Database Administrator Responsible for securing the database system against unauthorized users. A database administrator enforces procedures for user access and database system availability. Authorization Many database users should have limited access to specific tables, columns, or rows of a database. Database systems authorize individual users to access specific data. Rules Database...

The relationship (within the relation) that describes how the value of one attribute may be used to find the value of another attribute. Functional Dependency 3 multiple choice options An attribute that can be used to find the value of another attribute in the relation. Determinant 3 multiple choice options Value can be used to find the value of every other non-key attribute in the table. Unique and minimal. Candidate Key 3 multiple choice options Define & manage database st...