Term
|
Definition
| variety of techniques to restore the database to a usable form in case it is damaged or destroyed |
|
|
Term
| Object-oriented databases often use |
|
Definition
| Object Query Language (OQL) to manipulate and retrieve data |
|
|
Term
| object-oriented database (OODB) stores |
|
Definition
|
|
Term
| Multidimensional Databases |
|
Definition
Higher level of organization vs. relational
Avoids complex queries |
|
|
Term
| data warehouse is a huge database |
|
Definition
| that stores and manages the data required to analyze historical and current transactions |
|
|
Term
| Database Administrator (DBA) |
|
Definition
| Creates and maintains the data dictionary, manages security, monitors performance, and checks backup and recovery procedures |
|
|
Term
|
Definition
| Decides on proper field placement, defines data relationships, and identifies users’ access privileges |
|
|
Term
| Database analysts and administrators are responsible for |
|
Definition
| managing and coordinating all database activities |
|
|
Term
|
Definition
A DBMS provides means to ensure that only authorized users access data at permitted times
Access privileges
Principle of least privilege
Only data required for legitimate purposes can be accessed |
|
|
Term
|
Definition
| allows users to design a report on the screen, retrieve data into the report design, and then display or print the report |
|
|
Term
|
Definition
is a window on the screen that provides areas for entering or modifying data in a database
Simplifies data input (and validation)
Access: Create tab/Form Wizard |
|
|
Term
|
Definition
“answers a question” about your DB
e.g. What are the values of certain fields in a table |
|
|
Term
|
Definition
| consists of simple, English-like statements that allow users to specify the data to display, print, or store |
|
|
Term
|
Definition
| – Structured Query Language |
|
|
Term
| Query by example (QBE) provides a GUI to assist users |
|
Definition
with retrieving data
Can be created using Access
or your favorite DBMS |
|
|
Term
|
Definition
|
|
Term
|
Definition
| describes the structure of a database. |
|
|
Term
|
Definition
|
|
Term
| A data dictionary describes |
|
Definition
| in detail every table, field, and relationship in the database. |
|
|
Term
|
Definition
| data with a set of rules or values to find out if the data is correct. |
|
|
Term
|
Definition
Exactly one of second object occurs for each instance of first
‘1’ can include 0, but not always |
|
|
Term
|
Definition
One of first relates to many of second
Each second can only relate to one of first |
|
|
Term
|
Definition
First can relate to many of second
Second can relate to many of first |
|
|
Term
| data model consists of rules |
|
Definition
| and standards that define how the database organizes data |
|
|
Term
| A relational database model |
|
Definition
| stores data in tables that consist of rows and columns |
|
|
Term
|
Definition
|
|
Term
|
Definition
"link" between tables
Uses common fields
A foreign key is a primary key from one table that is included in a different table to form a relationship |
|
|
Term
|
Definition
| is a group of related fields in a table |
|
|
Term
|
Definition
| instances of the table data |
|
|
Term
|
Definition
| used for identifying, sorting, and searching records. |
|
|
Term
|
Definition
| uniquely identifies each record |
|
|
Term
| field is a characteristic |
|
Definition
| of an object. It is a combination of one or more bytes (e.g. alpha-numeric characters). A field includes the following attributes: |
|
|
Term
|
Definition
| represents an entity (object), which may be a person, place, thing |
|
|
Term
|
Definition
| contains data records, which are made up of fields |
|
|
Term
|
Definition
| multiple tables representing objects of interest |
|
|
Term
| Database software, often called a database management system (DBMS), allows users to: |
|
Definition
Create a computerized database
Add, modify, and delete data
Sort and retrieve data
Create forms and reports from the data |
|
|
Term
|
Definition
|
|
Term
| The management system (MS) |
|
Definition
| is an application which manages the DB |
|
|
