chapter 15 - databases Flashcards
is well thought-out collection of computer files called tables that consist of records (rows) of data separated by fields (columns) that can be queried (questions) to produce subsets of information.
Database software
In a DBMS, data is stored in computer files called tables, and tables are combined with other tables with related information, hence, a
relational database.
The records retrieved by these queries become information that can be used to make business decisions.
Database
are always distributed on a computer network for multiple users.
Business databases
Databases are referred to as
database management systems (DBMS)
At its core a _____ is made up of files called tables that are related to each other.
database
construct databases by using entity relationship diagrams (ER Diagram)
Database designers
is a database-modeling method to construct a theoretical and conceptual representation of data to produce a schema.
entity relationship diagrams (ER Diagram)
A ______ field can be set up to ensure that a user only enters five digits or ten digits (85714 or 85714-1201) and only accept numeric figures.
“Zip Code”
Once a field has a _____, it ensures data integrity.
“data validation”
attempt to avoid data input errors like typing errors.
Data integrity techniques
one of the most common uses of ____ is to query a table(s).
SQL
Avoiding ____ ensures accuracy system wide throughout a DBMS which can reduce reconciliation errors immensely.
data redundancy
is the most widely used standard computer language for relational databases that allows a programmer to manipulate and query data.
Structured Query Language (SQL)
