PRELIM Q1 Flashcards
is a tool used to organize, store,
retrieve, and communicate (report on) group of
related information.
database
4 main Objects
- Tables – store data in rows and columns
- Queries – retrieve and process data
- Forms – control data entry and data views.
a Form is a customized manner of inputting data into a
database or representing data on a screen. - Reports – summarize and print data.
Database software, often called a
database
management system (DBMS)
identifies the quality of the data
Data integrity
GIGO
Garbage in, garbage out
points out the
accuracy of a computer’s output depends on the
accuracy of the input
(GIGO)
Valuable information should have the following
characteristics
Accurate
Verifiable
Timely
Organized
Accessible
Useful
Costeffective
is one byte
– Numbers, letters, space,
punctuation marks, or
other symbols
A character
is a combination
of one or more related
characters
– Field name
– Field size
– Data type
A field
is a group of related fields
record
uniquely identifies each record
primary key
is a collection of related records
data file
refers to the procedures that
keep data current
File maintenance
compares data with a set of rules or
values to find out if the data is correct
Validation
Database approach
* Programs and users share
data
* Reduce data redundancy
* Improve data integrity
* Share data
* Allows easier access
* Reduces development time
* Can be more vulnerable
File processing system
* Each department has its
own set of files
* Used for many years
* Have data redundancy
* Isolate data
contains data about each file in
the database and each field in those files
A data dictionary
provides several tools that allow users
and programs to retrieve and maintain data in the
database
DBMS
consists of simple, English-like
statements that allow users to specify the data to
display, print, or store
query language
provides a GUI to assist
users with retrieving data
Query by example (QBE
is a window on the screen that provides
areas for entering or modifying data in a database
form
allows users to design a report
on the screen, retrieve data into the report
design, and then display or print the report
A report generator
A DBMS provides means to
ensure that only authorized users
access data at permitted times
Access privileges
Principle of least privilege
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
is a link
within the data
relationship
is a query
language that allows users to manage, update,
and retrieve data
Structured Query Language (SQL)
stores data
in objects
An object-oriented database (OODB
can store data in more
than two dimensions of data
– Sometimes known as a hypercube
– Can consolidate data much faster than a relational database
A multidimensional database
is a huge database that stores and
manages the data required to analyze historical and
current transactions
data warehouse
is the process of sorting through large data sets
to identify patterns and relationships that can help solve
business problems through data analysis
Datamining
