Download Data Management Fundamentals: Key Concepts and Definitions and more Exams Finance in PDF only on Docsity!
Data Management Foundation C175 WGU
Questions and Answers with Verified Solutions
Associative Entity - ✔✔An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - ✔✔An attribute is a property or characteristic of an entity. Binary relationship - ✔✔A binary relationship is a relationship between two entity types. Candidate Key - ✔✔Is any column or a combination of columns that can qualify as unique key in database. Cardinality - ✔✔Cardinality represents the maximum number of entities that can be involved in a particular relationship. Cartesian product - ✔✔Usually the result of a missing join condition or a method of expanding the data of 1 table by the number of rows in the second table. Cascade Delete - ✔✔Will delete all records that reference the primary key column subquery - ✔✔Returns a single column of one or more values.
data encryption - ✔✔When data is encrypted, it is changed, bit by bit or character by character, into a form that looks totally garbled. It can and must be reconverted, or decrypted, back to its original form to be of use. Data normalization - ✔✔Is a methodology for organizing attributes into tables so that redundancy among the non-key attributes is eliminated. Data volatility - ✔✔Describes how often stored data is updated. Data Volume Assessment - ✔✔Understanding of how much data will be in a database or a table within a database Database - ✔✔A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. DCL - ✔✔Data control language is used to control access to data stored in a database. DDL - ✔✔Data definition language - involves instructing the DBMS software on what tables will be in the database, what attributes will be in the tables, which attributes will be indexed, and so forth. Definer - ✔✔Definer is a MySQL term where AuthID is the same for another DBMS
Inner Join - ✔✔Shows row that have matches in both tables Intersection Data - ✔✔Intersection Data associated with the concatenation of two segments. Join - ✔✔Joins 2 tables together logical view - ✔✔Is a mapping onto a physical table or tables that allows an end user to access only a specified portion of data. Modality - ✔✔Modality represents the minimum number of entity occurrences that can be involved in a relationship. outer join - ✔✔Shows rows in one table that have no match in the other table. Two kinds of outer joins are left and right joins. Primary Key - ✔✔Uniquely identifies each record in the table. query mode - ✔✔The command goes directly to the relational DBMS, which evaluates the query and processes it against the database. Referential Integrity - ✔✔Referential integrity is a database concept that ensures that relationships between tables remain consistent.
referential integrity - ✔✔Enforces rules to guarantee that the foreign key relationship stays intact with no mismatches. Response time - ✔✔Is the delay from the time that the Enter Key is pressed to execute a query until the result appears on screen. Restrict Delete - ✔✔Will not allow deletes if the primary key is referenced row subquery - ✔✔Returns a single row of one or more values. scalar subquery - ✔✔is the most restrictive subquery because it produces only a single value Set-to-Null on Delete - ✔✔Will set values to null when primary key is deleted SQL - ✔✔Is a comprehensive database management language which incorporates DML and DDL subquery - ✔✔One SELECT statement is "nested" within another. table subquery - ✔✔Returns a table of one or more rows of one or more columns.
Clustering - ✔✔Descriptive - groups similar data together into clusters Extraction/Transformation/Loading - ✔✔ETL is the process of extracting raw data and then transforming and loading into a target to be used with Business intelligence. Regression - ✔✔Predictive - used to map a data item to a real valued prediction variable Sequence Discovery - ✔✔Descriptive - discovers sequential patterns Summarization Rules - ✔✔Descriptive - maps data into subsets with associated simple descriptions or generalizations. Time Series Analysis - ✔✔Predictive - analysis information over time to predict future data
- in the SELECT clause - ✔✔It indicates that all attributes of the selected row are to be retrieved. AND operator - ✔✔It displays a record if more than one condition is true. AVG() function - ✔✔It returns the average value of a numeric column.
BETWEEN operator - ✔✔It allows you to specify a range of numeric values in a search. Data definition - ✔✔It is operationalized with a data definition language (DDL), involves instructing the DBMS software on what tables will be in the database, what attributes will be in the tables, which attributes will be indexed, and so forth. Data management - ✔✔There are two aspects of data management: data definition and data manipulation. DISTINCT operator - ✔✔It is used to eliminate duplicate rows in a query result. IN operator - ✔✔It allows you to specify a list of character strings to be included in a search. JOIN clause - ✔✔It is used to combine rows from more than one table, based on a common field between them. LIKE operator - ✔✔It allows you to specify partial character strings in a "wildcard" sense. OR operator - ✔✔It displays a record if either the first condition OR the second condition is true. ORDER BY clause - ✔✔It simply takes the results of a SQL query and orders them by one or more specified attributes.
Structured Data - ✔✔Information with a high degree of organization Unstructured Data - ✔✔Information that does not have structure (such as text) ETL process - ✔✔Get the data from the source location. Map the data from its original form into a data model that is suitable for manipulation at the staging area. Validate and clean the data. Apply any transformations to the data that are required before the data sets are loaded into the repository. Map the data from its staging area model to its loading model. Move the data set to the repository. Load the data into the warehouse. Estimation - ✔✔It is a process of assigning some continuously valued numeric value to an object. Description - ✔✔It is the process of trying to characterize what has been discovered or trying to explain the results of the data mining process. Affinity grouping - ✔✔It is a process of evaluating relationships or associations between data elements.
