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;
29 Cards in this Set
- Front
- Back
Table |
group of records for the same entity, and each row has a record |
|
field |
an attribute of an entity, numeric data and/or tect |
|
Data Definition |
specifies the characteristics of a field (i.e. text type, max characters) |
|
Record |
a means to represent an entity |
|
Batch Processing |
read through of each record by the computer and it takes an action |
|
Database |
integrated collection of information that is logically related and stored to minimize duplication and facilitate rapid retrieval |
|
Data management software |
ensures security, replication, retrieval, acts as a gateway to the database |
|
Relational Database |
model that organizes info into tables of records that are related to one another by linking a field in one table to a field in another |
|
Scalability |
a system's ability to handle rapidly increasing demand |
|
Referential integrity |
ensuring that every foreign key entry exists as a primary key in its main table |
|
Database Schema |
graphic that documents the data model and shows the table |
|
data dictionary |
documentation that contains the details of every field in every table |
|
shadow system |
quick, separate solution |
|
master data management |
uniforming defintitions for entities across all business units |
|
data warehouse |
a collection of multiple databases from multiple sources that can be used for analysis, intelligence, and strategic planning |
|
data stweard |
a person that ensures that people adhere to the definitions for the master data in their organizational units |
|
Structured Information |
reasonably ordered, can be broken down into hierarchies |
|
unstructured information |
cannot be easily linked together. No inherent structure |
|
semi-structured system |
some structure, like webpages and documents, that bear creation dates, titles, and authors |
|
Metadata |
data about data |
|
Quality of Information |
accuracy, precision, completeness, consistency, timeliness, bias, duplication |
|
primary key |
field that makes the data unique in that table |
|
Autonumbering |
assign primary keys incrementally |
|
normalization |
minimizing the amount of duplication of information in the table as well as avoids inconsistencies |
|
functionally dependent |
only one value for each of the attributes in the table, and the attribute determines that value |
|
Foreign keys |
primary keys that appear as an attribute in another table. these can be used to link records |
|
Structured query language (SQL) |
manipulate information in relational databases |
|
interactive voice response |
access to database by telephone to retrieve info and enter data |
|
databases without boundaries |
people outside the enterprise enter and manage most of the records, i.e. craigslist, and can be used in disaster relief |