BCIS

Database:

Collection of information that you organize and access according to the logical structure of the information.
Operational Database:
Relational Database:

series of logically related two-dimensionl tables or files for storing information.
OLTP (Online transaction processing):

gathering and processing information and updating existing information to reflect the processed information
OLAP (Online analytical processing):

manipulation of information to support decision making
Logical structure:
Primary Key:

field (or group of fields) that uniquely describes each record.
Foreign Key:

primary key of one file that appears in another file

Author

10mosolis

46692

Card Set

BCIS

Description

Test 2 Review

Updated

2010-11-02T05:28:53Z

Show Answers