WGU C175 Data Management Foundations (WGUC175)

atomic attribute - -An attribute that cannot be further subdivided to produce meaningful components. For example, a person's last name attribute cannot be meaningfully subdivided. atomicity - -The transaction property that requires all parts of a transaction to be treated as a single, indivisible, logical unit of work. All parts of a transaction must be completed or the entire transaction is aborted. Boyce-Codd normal form (BCNF) - -A special type of third normal form (3NF) in which every ...

What is a broad definition of data? - -*Raw facts* that are captured on printed or digital media What are data? - -Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? - -It does not follow a data model. Which item represents unstructured data? - -Training Video Content Which is true about flat files? - -They contain no internal hierarchical organization. Which technology has no internal hierarchy? - -Flat files How were data r...

Flat files - -What is a file having no internal hierarchy Heap files - -What are files containing an unsorted set of records that are uniquely identified by a record id which allows them to be inserted or deleted using that id Index files - -What are files that store a list of lookup field values from a data file - along with the location (address) in the data file of the corresponding record. Because the lookup field is much smaller than the entire record, the entire index will usually fit...

ad hoc query - -A "spur-of-the-moment" question. analytical database - -A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making. availability - -In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes. centralized database - -A database located at a single site. cloud database - -A database that is created and maintained using cloud service...

What is a broad definition of data? a. Numbers that are captured on digital media b. Raw facts that are captured on printed or digital media c. Alphanumeric combinations that can be captured on media that a computer can read d. Any information that can be transferred from print to digital - -b. Raw facts that are captured on printed or digital media What is data? a. Facts that have been organized in a meaningful way b. Facts that are the result of a query of a database system c. Facts t...

ad hoc query A "spur-of-the-moment" question analytical database A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making availability In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes centralized database A database located at a single site cloud database A database that is created and maintained using cloud services, such as Microso...

They can serve as a communication tool between the users and designers. Which of the following is true of business rules? entity A(n) _______ is anything about which data are to be collected and stored. XML/Hybrid data model Oracle 11g is an example of the _______. entity instance Each row in the relational table is known as a(n) relational data model MySQL is an example of the _______. attribute A(n) _______ is the equivalent of a field in a file system. entity relationship The _______ m...