Ch. 11 Logical Data Flashcards
30 test answers
Unlock all answers in this set
Unlock answers 30question
record
answer
A collection of related fields.
Unlock the answer
question
database
answer
An integrated collection of logically related records or objects.
Unlock the answer
question
primary key / key field
answer
A database has at least one distinctive field that uniquely identifies the record.
Unlock the answer
question
batch processing
answer
Data is collected over several periods, and then processed all at once.
Unlock the answer
question
real-time processing / online processing
answer
Data is processed at the same time the transaction occurs
Unlock the answer
question
data redundancy
answer
Records for the same data entity may appear in different files.
Unlock the answer
question
Data integrity
answer
Database characteristics relating to the consistency and accuracy of data.
Unlock the answer
question
data definition subsystem
answer
Defines the logical structure of the database.
Unlock the answer
question
query-by-example
answer
A database tool that supports viewing all or selected parts of the data
Unlock the answer
question
SQL
answer
A specialized database programming language.
Unlock the answer
question
1.Hierachical 2.Network 3.Relational 4.Multidimensional 5.Object-oriented
answer
DBMS structures (Know 5 models)
Unlock the answer
question
Hierarchical database
answer
Field or records are structured in nodes in a one-to-many relationship.
Unlock the answer
question
Network database
answer
A database structure that uses a many-to-many relationship.
Unlock the answer
question
Relational database
answer
A database structure where data elements are stored in different tables, each of which consists of rows and columns.
Unlock the answer
question
Multidimensional databases
answer
A data model that include additional or multiple dimensions.
Unlock the answer
question
Object-oriented database
answer
A database that can store data as well as instructions to manipulate the data, and is able to handle unstructured data.
Unlock the answer
question
1.Individual 2.Company 3.Distributed 4.Commercial
answer
Types of databases (Know 4 types)
Unlock the answer
question
Individual database
answer
A collection of integrated files primarily used by just one person (AKA a personal computer database).
Unlock the answer
question
Company database
answer
Databases companies create for their own use.
Unlock the answer
question
Distributed database
answer
A database that is located in a place or places other than where users are located.
Unlock the answer
question
Commercial database
answer
An enormous database that an organization develops to cover particular subjects.
Unlock the answer
question
CSI - example of commercial database
answer
Offers consumer and business service, including electronic mail.
Unlock the answer
question
Dialog Information Services - example of commercial database
answer
Offers business information, as well as technical and scientific information.
Unlock the answer
question
Dow Jones Interactive Publishing - example of commercial database
answer
Provides world news and information on business, investments, and stocks.
Unlock the answer
question
LexisNexis - example of commercial database
answer
Offers news and information on legal, public records, and business issues.
Unlock the answer
question
data warehouse
answer
Data collected from a variety of internal and external databases and stored in one location.
Unlock the answer
