BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Database
data organized and stored on a computer that can be searched and retrieved.
Data
collection of unprocessed items (text, numbers, images, video, audio)
Information
processed data from a data base, the finished product of a database. (The information
is used to create documents, images, audio)
Database Management System (DBMS)
creates a computerized database. Sorts and retrieve data, add, modify, and deletes
data. creates forms and reports from data.
Data Integrity
the quality of the data
Garbage In, Garbage Out (GIGO)
computer phrase meaning you cannot create correct information from incorrect data.
Qualities of Valuable information
Accurate, Verifiable, Accessible, Timely, Organized, Useful, Cost-effective
Hierarchy Data
Data that contains Database, Files, Tables, Records, Field, Data (in that order)
Field
combination of one or more characters. smallest unit of data user accesses.
Data Types
Text, numbers, Yes/No, Auto number, Currency, Hyperlink, Date, Memo, Object
Record
a group of related fields
Table
a group of related records, usually organized by a common subject
Primary Key
a field value unique to a record; its impossible to duplicate (SSN, Drivers License)
Data File
collection of related records stored on a disk
File Maintenance
procedures that keep data current (adding records, changing records, deleting records)
Validation
process of comparing data with a set of rules to find out if data is correct
Query
request for a specific data from a database
Query By Example (QBE)
a program that retrieves records that match criteria entered in form fields.
Data Model
rules and standards that define how database organizes data. defines how users view
organization of data.
Relational Database
, stores data in tables that consist of rows and columns. Each row has a primary key,
each column has a unique name
Relationship
connection within data, connection between tables
Structured Query Language (SQL)
allows you to manage, update, and retrieve data . Allows you to search, sort and
retrieve through data that is stored in database
Object Oriented Database (OODB)
stores data in objects (items that contains data). it can store more types of data, can
access data faster, programs can reuse objects
Data Mining
process by which data are analyzed and investigated. Objective is to spot patterns or
trends within the data
Import
receive data in the form of text filing
Browse
navigate through information
Sort
rearrange records (alphabetically or numerically)
Print
reports, labels, and forms letters
Export
to another program for printing
Data Redundancy
wastes space and may cause inaccuracies
Data Consistency
all tables must contain the correct information
Database Trends
real time computing, allows instant access to information
Interactive Processing
allows users to access data in real time
Batch Processing
requires transactions to be accumulated and then fed into computers in large batches
Multidimensional Database Technology
stores data in more than two dimensions, the data is organized in cubes
Record matching
uses a unique field to combine information from different databases
Normalization
the process of removing redundant data from relational data. Helps keep database as
small as possible
One-to-One Relationship
one entity is related to at most one other entity (SSN, Drivers License, Birth certificate0
Objects
components that make a database function. Consisting of tables, queries, forms,
reports; less commonly used are macros and modules
Compacting and repairing database
GRADED
Database
data organized and stored on a computer that can be searched and retrieved.
Data
collection of unprocessed items (text, numbers, images, video, audio)
Information
processed data from a data base, the finished product of a database. (The information
is used to create documents, images, audio)
Database Management System (DBMS)
creates a computerized database. Sorts and retrieve data, add, modify, and deletes
data. creates forms and reports from data.
Data Integrity
the quality of the data
Garbage In, Garbage Out (GIGO)
computer phrase meaning you cannot create correct information from incorrect data.
Qualities of Valuable information
Accurate, Verifiable, Accessible, Timely, Organized, Useful, Cost-effective
Hierarchy Data
Data that contains Database, Files, Tables, Records, Field, Data (in that order)
Field
combination of one or more characters. smallest unit of data user accesses.
Data Types
Text, numbers, Yes/No, Auto number, Currency, Hyperlink, Date, Memo, Object
Record
a group of related fields
Table
a group of related records, usually organized by a common subject
Primary Key
a field value unique to a record; its impossible to duplicate (SSN, Drivers License)
Data File
collection of related records stored on a disk
File Maintenance
procedures that keep data current (adding records, changing records, deleting records)
Validation
process of comparing data with a set of rules to find out if data is correct
Query
request for a specific data from a database
Query By Example (QBE)
a program that retrieves records that match criteria entered in form fields.
Data Model
rules and standards that define how database organizes data. defines how users view
organization of data.
Relational Database
, stores data in tables that consist of rows and columns. Each row has a primary key,
each column has a unique name
Relationship
connection within data, connection between tables
Structured Query Language (SQL)
allows you to manage, update, and retrieve data . Allows you to search, sort and
retrieve through data that is stored in database
Object Oriented Database (OODB)
stores data in objects (items that contains data). it can store more types of data, can
access data faster, programs can reuse objects
Data Mining
process by which data are analyzed and investigated. Objective is to spot patterns or
trends within the data
Import
receive data in the form of text filing
Browse
navigate through information
Sort
rearrange records (alphabetically or numerically)
reports, labels, and forms letters
Export
to another program for printing
Data Redundancy
wastes space and may cause inaccuracies
Data Consistency
all tables must contain the correct information
Database Trends
real time computing, allows instant access to information
Interactive Processing
allows users to access data in real time
Batch Processing
requires transactions to be accumulated and then fed into computers in large batches
Multidimensional Database Technology
stores data in more than two dimensions, the data is organized in cubes
Record matching
uses a unique field to combine information from different databases
Normalization
the process of removing redundant data from relational data. Helps keep database as
small as possible
One-to-One Relationship
one entity is related to at most one other entity (SSN, Drivers License, Birth certificate0
Objects
components that make a database function. Consisting of tables, queries, forms,
reports; less commonly used are macros and modules
Compacting and repairing database
