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
group of programs to manage database
|
1. Database management system (DBMS):
|
|
Bits, characters, fields, records, files, and databases
|
2. Hierarchy of Data
|
|
represents a circuit that is either on or off
|
a. Bit
|
|
typically made up of eight bits
|
b. Byte
|
|
generalized class of people, places, or things (objects) for which data is collected, stored, and maintained
|
3. Entity
|
|
characteristic of an entity
|
4. Attribute
|
|
specific value of an attribute
|
5. Data item
|
|
field or set of fields in a record that is used to identify the record
|
6. Key
|
|
field or set of fields that uniquely identifies the record
|
7. Primary key
|
|
a pool of related data is shared by multiple application programs
|
8. Database approach to data management
|
|
diagram of data entities and their relationships
|
9. Data model
|
|
data models that use basic graphical symbols to show the organization of and relationships between data
|
10. Entity-relationship (ER) diagrams
|
|
describes data in which all data elements are placed in two-dimensional tables, called relations, that are the logical equivalent of files
|
11. Relational model
|
|
• Selecting: eliminates rows according to certain criteria
• Projecting: eliminates columns in a table • Joining: combines two or more tables • Linking: manipulating two or more tables that share at least one common data attribute to provide useful information and reports |
12. Relational database model
|
|
process of looking for and fixing inconsistencies to ensure that data is accurate and complete
|
13. Data cleanup
|
|
Simple database program whose records have no relationship to one another
|
14. Flat File
|
|
description of the entire database
|
15. Schema
|
|
collection of instructions and commands used to define and describe data and relationships in a specific database
|
16. Data definition language (DDL
|
|
detailed description of all the data used in the database
|
17. Data dictionary
|
|
commands that manipulate the data in a database
|
18. Data manipulation language (DML
|
|
Adopted by the American National Standards Institute (ANSI) as the standard query language for relational databases
|
19. Structured Query Language (SQL)
|
|
database that collects business information from many sources in the enterprise, covering all aspects of the company’s processes, products, and customers
|
20. Data warehouse
|
|
subset of a data warehouse
|
21. Data mart
|
|
information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse
|
22. Data mining
|
|
process of gathering enough of the right information in a timely manner and usable form and analyzing it to have a positive impact on business strategy, tactics, or operations
|
23. Business intelligence (BI):
|
|
aspect of business intelligence limited to information about competitors and the ways that knowledge affects strategy, tactics, and operations
|
24. Competitive intelligence
|
|
Database in which the data may be spread across several smaller databases connected via telecommunications devices
|
25. Distributed database
|
|
Database that holds a duplicate set of frequently used data
|
26. Replicated database
|
|
Software that allows users to explore data from a number of different perspectives
|
27. Online Analytical Processing (OLAP)
|