| A | B |
|---|
| Raw | Facts that haven't been processed |
| Information | A foundation for decision making |
| Formatted | Raw data that is processed, storage, and presented should be? |
| "new" Knowledge can be derived from "old" Knowledge | What is knowledge key characteristics? |
| Information | What is the key to good decision making? |
| Metadata | Data about Data |
| the proper generation, storage, and retrieval of data | Database management focuses on |
| it helps create an environment for end users to have access to more data | What is one of DBMS benefit? |
| DBMS | interaction between the end user and the database |
| DBMS | receives all application requests |
| Spur of the moment question | Ad hoc query |
| Integrated | promotes a view of operations and the big picture |
| Query set result | What sends back to the application? |
| Desktop | A single-user database |
| Distributed | database that supports data |
| Data warehouse | storing data, make tactical or strategic decisions |
| Transactional | Another name for a production database |
| expected type and extent of use | Applied to DBMS as most common classfication |
| create a new query | John needs to know what customers are located in Florida |
| 50 | # of users a workgroup database supports |
| MS Access | does not provide an enterprise database |
| Data warehouse | recognizes the use of historical and aggregated data |
| the need to track data and produce required reports | Data processing (DP) specialists are in existence because of |
| Database | software, hardware, data, procedures and people |
| File cabinet | traditional file system |
| set of one or more fields | What is a record consisting of? |
| Record | A specific entity that can be grouped together. (Hint: All fields) |
| Data | A raw fact |
| Nonprocedural langage | specifying what must be done |
| Independence (Data independence) | possible to make changes in the data storage |
| Data dependence | subject to change (Hint: changing the data type) |
| Logical data format | human beings view |
| Structural independence | possible to make changes in the file structure |
| Data redundancy | same data stored at different places |
| inconsistent redundant data | results in a data anomaly |
| Data integrity | real-world events and conditions |
| Data anamoly | areas that are not made successfully because of the redundant area |
| Database system | regulate the collection, storage, management etc. |
| End users | run the organization's daily operations |
| Software | Database management systems, operating systems, applications and utilities are all examples of |
| Database designers | Database architects |
| Data dictionary | store the definitions |
| Procedures | rules that govern the design |
| Performance tuning | make the database perform more efficiently |
| Query language | without having to specify how it is to be done |
| Recovery | fixing failures of a database |
| Structure Query Language (SQL) | de facto query language |
