Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
Database |
A set of interrelated, centrally coordinated data files that are stored with as little data redundancy as possible. |
|
Database Management System (DBMS) |
A program that manages and controls the data and the interfaces between the data and the application programs that use the data stored in the database. |
|
Database System |
This comprises the database itself, the DBMS, and the application program (software). |
|
Database Administrator |
The person responsible for coordinating, controlling, and managing the database. |
|
Data Warehouse |
A very large database that contains detailed and summarized data for a lot of years used for analysis rather than transaction processing. |
|
Data Dictionary |
Information about the structure of the database, including a description of each data element. |
|
Data Definition Language (DDL) |
DBMS language that builds the data dictionary, creates the database, describes logical views, and specifies record or field security constraints. |
|
Data Manipulation Language (DML) |
DBMS Language that changes database content, including data element creations, updates, insertions, and deletions. |
|
Data Query Language (DQL) |
High-level, English-like, DBMS language that contains powerful, easy-to-use commands that enable users to retrieve, sort, order and display data. |
|
Semantic Modeling |
Using knowledge of a business process and information needs to create a diagram that shows what to include in a fully normalized database (in 3NF). |