CORRECT ANSWERS VERIFIED BY EXPERT| NWELY
UPDATED 2025| GRADED A+.
Database Software - ANSWER ✔✔ a well thought-out collection of computer files, the most
important of which are called tables.
Tables - ANSWER ✔✔ where a database holds data. ___ consist of records (rows) separated by
fields (columns) that can be queried (questioned) to produce subsets of information.
Records - ANSWER ✔✔ Rows
Fields - ANSWER ✔✔ Columns
Queries - ANSWER ✔✔ Questions
Database Management Systems (DBMS) - ANSWER ✔✔ Databases are created using software
systems known as ___. In a ___, data is stored in computer files called tables, and tables are
connected to other tables with related information
Relational Database - ANSWER ✔✔ Databases where tables are connected to other tables with
related information.
Filing Cabinets - ANSWER ✔✔ The first database management system
Database - ANSWER ✔✔ is made up of files called tables that are related to each other.
Reports - ANSWER ✔✔ Another file that exists within a database; display database information
on screen or on paper
Saved Query Files - ANSWER ✔✔ Another file that exists within a database; used to find specific
populations (subsets) within databases
Forms - ANSWER ✔✔ Overlay data tables and queries for more specific views of data. Overlays
data to show information in a more organized manner.
Entity Relationship (ER) Diagram - ANSWER ✔✔ What database designers use to construct
databases
, Entity Relationship Modeling (ERM) - ANSWER ✔✔ a database-modeling method used to
construct a theoretical and conceptual representation of data to produce a schema. Simply
stated, an ___ is a picture of a database's tables and how they relate to each other.
Database Schema - ANSWER ✔✔ a "map" of data tables and their relationships to one another.
One-to-Many Relationship - ANSWER ✔✔ When one thing in one table relates to many things in
another table.
Data Validation Rules - ANSWER ✔✔ Rules that help to ensure the data's integrity (rules or
constraints that make sure data is correct).
Data Integrity Techniques - ANSWER ✔✔ Attempt to avoid data input errors like typing mistakes.
Data Redundancy - ANSWER ✔✔ Avoiding ___ ensures accuracy system wide throughout a
DBMS and that can reduce reconciliation errors immensely Ex: having a name in one specific
area of a database rather than everywhere.
Structured Query Language (SQL) - ANSWER ✔✔ the most widely used standard computer
language for relational databases as it allows a programmer to manipulate and query data. One
of the most common uses of ___ is to query a table
REO - ANSWER ✔✔ Real Estate Owned
Field Mask - ANSWER ✔✔ Restricts certain input data
Filtering - ANSWER ✔✔ The ability to add a filter to a data table that would only display specific
information
Information Technology - ANSWER ✔✔ Career that offers broader opportunities throughout
business because it courses throughout every aspect of the business world. ___ enhances
businesses
Common Axiom for IT Professionals - ANSWER ✔✔ "Know the business." IT Professionals are
business professionals first
Value-Added - ANSWER ✔✔ refers to the added value of a product or service over the cost of
products and services used to produce it from the previous stage of production.
Information Technology Departments - ANSWER ✔✔ responsible for servicing and enhancing all
computing, technical assets, and intellectual property of a business organization.