Prelim Flashcards
(34 cards)
Data and Information
Database Management
Collection of data organized so you can
access, retrieve, and use it
Database
Database software allows you to:
- Create database
- Add, change, and delete data
- Sort and retrieve data
- Create forms and reports
DBMS
Database Management System
Data is not raw facts , t or f
False
degree to which data is correct
Data integrity
GIGO
Garbage in Garbage Out
computer phrase that means you
cannot create correct information from
incorrect data
GIGO
What are common data types?
Text,numeric,currency,data
only the
values Yes or No (or True or False)
Boolean
address that links to
document or Web page
Hyperlink Web
photograph, audio, video, or
document created in other application such
as word processing or spreadsheet
Object also called BLOB
Types of Validity Check
CHeck DIgit, Alphabetic/numeric check, range check,completeness check,consistency check
same fields stored in multiple files
Data redundancy
Data Stored in seperate files so it is difficult to access
isolated data
many programs and users can share data in database
database approach
Contains data about each file in
database and each field within those files
Data Dictionary
Request for specific data from a
database
Query
Window on screen that provides areas
for entering or changing data in database
Form
Allows user to design a report on screen,
retrieve data into report design, then display
or print reports
Report Generator
define activities that
specific user or group of users can perform
Access privileges
User can view data, but cannot change it
Read only privileges
User can view and change data
Full update Privileges
a listing of activities that change
database contents
log
