Term
|
Definition
| columns; Characteristics that describe entities |
|
|
Term
|
Definition
| Maximum number of occurrences of one entity for a single occurrence of the related entity |
|
|
Term
|
Definition
| table; any object or concept about which we want to store data |
|
|
Term
|
Definition
| an attribute in one table that is a primary key in another table |
|
|
Term
|
Definition
| an attribute or set of attributes that can be used to identify individual instances of an entity |
|
|
Term
|
Definition
| refers to the extent of detail within the informaiton |
|
|
Term
| transactional information |
|
Definition
|
|
Term
|
Definition
| organizational info; supports managerial tasks |
|
|
Term
|
Definition
| immediate, up-to-date info |
|
|
Term
|
Definition
| provides real-time info in response to queries |
|
|
Term
|
Definition
| simple, objective, obtainable, definable, valid, robust |
|
|
Term
|
Definition
| accurate, complete, consistent, unique, timely |
|
|
Term
|
Definition
| the physical storage of information on a storage device such as a hard disk |
|
|
Term
|
Definition
| focuses on how users logically access information to meet their particular business needs |
|
|
Term
|
Definition
| the duplication of information or storing the same information in multiple places |
|
|
Term
|
Definition
| a measure of the quality of information |
|
|
Term
|
Definition
| the rules that help ensure the quality of information |
|
|
Term
| relational integrity constraint |
|
Definition
| the rules that enforce basic and fundamental information-based constraints |
|
|
Term
| business-critical integrity constraint |
|
Definition
| enforces business rules vital to an organization's success and often requires more insight and knowledge than relational integrity constraints |
|
|
Term
| database management system |
|
Definition
| software through which users and application programs interact with a database |
|
|
Term
|
Definition
| allows separate systems to communicate directly with each other |
|
|
