Chapter 1 Flashcards
What is a non-procedural database language?
A language, such as SQL, that allows you to specify the parts of a database to access rather than to code a complex procedure.
What does data independence mean?
A database should have an identity separate from the applications (computer programs, forms, and reports) that use it. The separate identity allows the database definition to be changed without affecting related applications.
What is a table?
A named, two-dimensional arrangement of data consisting of a heading part and body part.
The ___ language is an industry standard that includes statements for database ____, ____, and ____.
SQL, definition, manipulation, control.
A ____ is a collection of components that support data acquisition, dissemination, maintenance, retrieval, and formatting.
DBMS - database management system
Define transaction processing
A reliable and efficient processing of large volumes of repetitive work
Describe client-server architecture
An arrangement of components (clients and servers) and data among computers connected by a network–supports efficient processing of messages between clients and severs.
What is a database administrator?
A support position that specializes in managing individuals’ databases and DBMSs.
What is a data administrator?
A management position that performs planning and policy setting for the information resources of an entire organization.
A ____ is a database description.
Schema
Name the three characteristics of a database.
Persistent, Shared, & Interrelated
List the six common features of most DBMSs
Database definition, Nonprocedural access, Application development, Procedural language interface, Transaction processing, Database tuning
Three Schema Architecture has three levels of database description. What are they?
External, Conceptual,Internal
What is the goal of information management?
To use IT as a tool for processing, distributing, and integrating information throughout an organization
What does persistence mean?
Persistent data is data that is saved to a device such as a hard drive or USB drive.
