Lesson 1 Flashcards
is a collection of related records
Data file
is a combination of one or more related characters
Field
compares data with a set of rules or values to find out if the data is correct
Validation
consists of simple, English-like statements that allow users to specify the data to display, print, or store
Query language
is a query language that allows users to manage, update, and retrieve data
Structured Query language
refers to the procedures that keep data current
File maintenance
uniquely identifies each record
Primary key
Collection of data organized in a manner that allows access, retrieval, and use of that data
Data base
a tool used to organize, store, retrieve, and communicate (report on) group of related information.
Database
a tool used by businesses to manage the huge amount of data required to run the business.
Database
contains data about each file in the database and each field in those files
Data Dictionary
the accuracy of a computer’s output depends on the accuracy of the input
Garbage in, garbage out (GIGO)
Collection of unprocessed items
* Text
* Numbers * Images
* Audio
* Video
Data
- Processed data * Documents
- Audio
- Images
- Video
Information
store data in rows and columns
Table
retrieve and process data
Queries
control data entry and data views
Forms
summarize and print data
Reports
group of related fields
Record
a window on the screen that provides areas for entering or modifying data in a database
Form
are used by a manager of any small organization to track necessary data
Filesystems
provides a GUI to assist users with retrieving data
Query by example (QBE)
allows users to design a report on the screen
Report Generator
provides a variety of techniques to restore the database to a usable form in case it is damaged or destroyed
DBMS
consists of rules and standards that define how the database organizes data
Data Model`
stores data in tables that consist of rows and columns
Relational Database
can store data in more than two dimensions of data
Multidimensional database
is a huge database that stores and manages the data required to analyze historical and current transactions
Data Warehouse
Creates and maintains the data dictionary, manages security, monitors performance, and checks backup and recovery procedures
Data administrator (DBA)
Decides on proper field placement, defines data relationship, and identifies users’ access privileges
Database Analyst (DA)