Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
25 Cards in this Set
- Front
- Back
database management system
|
allows users to create a computerized database; add, modify, and delete data; sort and retrieve data; create forms and reports from the data
|
|
Garbage In, Garbage Out
|
GIGO, points out the accuracy of a computer's output depends on the accuracy of the input
|
|
character
|
is one byte
|
|
field
|
a combination of one or more related characters
|
|
record
|
a group of related fields
|
|
primary key
|
uniquely identifies each record
|
|
table
|
a collection of related records
|
|
file maintenance
|
the procedures that keep data current
|
|
validation
|
compares data with a set of rules or values to find out if the data is correct
|
|
data dictionary
|
contains data about each file in the database and each field
|
|
query
|
restricted view of the data
|
|
query language
|
consists of simple, English-like statements that allow users to specify the data to display, print, or store
|
|
Query by example (QBE)
|
provides a GUI to assist users with retrieving data
|
|
form
|
a window on the screen that provides area for entering or modifying data in a database
|
|
report generator
|
allows users to design a report on the screen, retrieve data into the report design, and then display or print the report
|
|
principle of least privilege
|
means that access is granted only to items that one needs
|
|
data model
|
consists of rules and standards that define how the database organizes data
|
|
relational database
|
stores data in tables that consist of rows and columns
|
|
relationship
|
a link within the data
|
|
Structured Query Language (SQL)
|
a query language that allows users to manage, update, and retrieve data
|
|
object-oriented database (OODB)
|
stores data in objects, it allows more field types
|
|
multidimensional database
|
can store data in more than two dimensions of data
|
|
data warehouse
|
a huge database that stores and manages the data required to analyze historical and current transactions
|
|
database analyst (DA)
|
decides on proper field placement, defines data relationships, and identifies users' access privileges
|
|
database administrator (DBA)
|
creates and maintains the data dictionary, manages security, monitors performance, and checks backup and recovery procedures
|