13.7: Chapter Review - Key Terms
- Page ID
- 32847
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)
( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\id}{\mathrm{id}}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\kernel}{\mathrm{null}\,}\)
\( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\)
\( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\)
\( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)
\( \newcommand{\vectorA}[1]{\vec{#1}} % arrow\)
\( \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow\)
\( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vectorC}[1]{\textbf{#1}} \)
\( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)
\( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)
\( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\(\newcommand{\avec}{\mathbf a}\) \(\newcommand{\bvec}{\mathbf b}\) \(\newcommand{\cvec}{\mathbf c}\) \(\newcommand{\dvec}{\mathbf d}\) \(\newcommand{\dtil}{\widetilde{\mathbf d}}\) \(\newcommand{\evec}{\mathbf e}\) \(\newcommand{\fvec}{\mathbf f}\) \(\newcommand{\nvec}{\mathbf n}\) \(\newcommand{\pvec}{\mathbf p}\) \(\newcommand{\qvec}{\mathbf q}\) \(\newcommand{\svec}{\mathbf s}\) \(\newcommand{\tvec}{\mathbf t}\) \(\newcommand{\uvec}{\mathbf u}\) \(\newcommand{\vvec}{\mathbf v}\) \(\newcommand{\wvec}{\mathbf w}\) \(\newcommand{\xvec}{\mathbf x}\) \(\newcommand{\yvec}{\mathbf y}\) \(\newcommand{\zvec}{\mathbf z}\) \(\newcommand{\rvec}{\mathbf r}\) \(\newcommand{\mvec}{\mathbf m}\) \(\newcommand{\zerovec}{\mathbf 0}\) \(\newcommand{\onevec}{\mathbf 1}\) \(\newcommand{\real}{\mathbb R}\) \(\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}\) \(\newcommand{\laspan}[1]{\text{Span}\{#1\}}\) \(\newcommand{\bcal}{\cal B}\) \(\newcommand{\ccal}{\cal C}\) \(\newcommand{\scal}{\cal S}\) \(\newcommand{\wcal}{\cal W}\) \(\newcommand{\ecal}{\cal E}\) \(\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}\) \(\newcommand{\gray}[1]{\color{gray}{#1}}\) \(\newcommand{\lgray}[1]{\color{lightgray}{#1}}\) \(\newcommand{\rank}{\operatorname{rank}}\) \(\newcommand{\row}{\text{Row}}\) \(\newcommand{\col}{\text{Col}}\) \(\renewcommand{\row}{\text{Row}}\) \(\newcommand{\nul}{\text{Nul}}\) \(\newcommand{\var}{\text{Var}}\) \(\newcommand{\corr}{\text{corr}}\) \(\newcommand{\len}[1]{\left|#1\right|}\) \(\newcommand{\bbar}{\overline{\bvec}}\) \(\newcommand{\bhat}{\widehat{\bvec}}\) \(\newcommand{\bperp}{\bvec^\perp}\) \(\newcommand{\xhat}{\widehat{\xvec}}\) \(\newcommand{\vhat}{\widehat{\vvec}}\) \(\newcommand{\uhat}{\widehat{\uvec}}\) \(\newcommand{\what}{\widehat{\wvec}}\) \(\newcommand{\Sighat}{\widehat{\Sigma}}\) \(\newcommand{\lt}{<}\) \(\newcommand{\gt}{>}\) \(\newcommand{\amp}{&}\) \(\definecolor{fillinmathshade}{gray}{0.9}\)Key Terms
- analytical database
- a database used by an organization for analytics and decision-making
- columnar layout
- a form layout that shows a single record
- criteria
- expressions that a database management system uses to limit the results of a query based on matching field values
- dark data
- data that is typically not used for analysis and therefore may or may not be valuable to an organization
- data lake
- a place to store data that keeps raw copies of the original documents
- data landscape
- the entirety of data storage and sharing in an organization
- data mart
- a subset of a data warehouse, optimized for specific workgroups or functions
- data warehouse
- a large store of data within an organization, often holding historical information and used for decision-making
- database
- a structured set of data stored in a way that allows us to make use of it
- datasheet layout
- a form layout that lists all records as they would appear in a datasheet
- Datasheet View
- view that shows the result of a query in table form
- Design View
- view that shows a query in the form of a QBE (query by example) grid
- development database
- a database used for experimental testing so that problems can be found and resolved before being pushed to the production database
- digital database
- a computerized file that stores data in a structured or organized way and also allows users to make changes to transform data
- digital platform
- a place where users can interact with and explore the products and services offered by a company
- flat files
- individual digital files that have a tabular structure, such as spreadsheets, tables, and lists
- group
- heading that organizes data items that have something in common
- join
- a clause used to create a relationship or connection between two records in a table
- justified layout
- a layout showing a record-by-record form, arranged across the screen
- key field
- a field in a table that serves as a unique identifier for an individual record in a table
- multiple-item form
- a form that displays information about more than one record or item at a time
- navigation form
- a form that allows you to add formatting, text, and commands to act as an interface, or navigation area, for your database
- NoSQL database
- database that stores large amounts of data, including documents and images, in their original format, not in tables
- object
- an item in a relational database
- page footer
- the bottom section of a document page, which typically repeats across pages and contains information useful to the report reader
- page header
- the top section of a document page, which typically repeats across pages and contains information useful to the report reader
- predefined queries
- queries used to answer frequently asked questions that meet specific organizational needs
- production database
- a database that runs transactions related to an organization’s core business functions
- query
- a structured data request
- record navigation buttons
- options that open whenever records are shown, enabling users to execute commands in a database
- relational database
- a database whose design and structure enable it to communicate with other systems that hold data
- relational database management system (RDBMS)
- computer software that provides the functions for a relational database
- relationship
- the association between two or more tables based on common fields or columns. It represents the way data is related and connected across different tables within the database
- report
- formatted summary of specific information in a database
- report detail
- the area where data from the Access database is displayed for each record
- report footer
- the bottom section of a report that does not typically repeat across pages and contains the name and dates of the report
- report header
- the bottom section of a report that does not typically repeat across pages and contains the number of pages in the entire report
- simple form
- a form that displays and allows editing of a single record at a time
- single point of truth (SPOT)
- the idea that there is one place storing information that all business units agree is factual
- split form
- a form that has two functions; for example, it might display a single record as well as a view of the datasheet in which the record is held
- SQL View
- a view that shows a query in structured query language form
- structured query language (SQL)
- language used to create and run queries in many relational databases
- table
- the structure that holds individual data records in a database
- tabular layout
- a form layout that shows all records listed in columns, similar to a datasheet