Reading...
Play button
Play button
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;
17 Cards in this Set
- Front
- Back
- 3rd side (hint)
|
Database
|
Collection of related files containing records on people places or things
|
|
|
|
Entity
|
Generalized category representing person, place, thing on which we store and maintain information
|
|
|
|
Attributes
|
Specific characteristics of each entity
|
|
|
|
Regional database
|
Organize data into two dimensional tables (relations) with columns and rows
|
|
|
|
Fields
|
Store data representing an attribute (columns)
|
|
|
|
Key field
|
Uniquely identifies each record
|
|
|
|
Primary key
|
Provides unique identifier for all information in any row
|
|
|
|
Normalization
|
Process of streamlining complex groups if data to minimize redundant elements, awkward many to many relationships, increase stability
|
|
|
|
Records
|
Data stored in rows
|
|
|
|
Database management systems
|
Specific type of software for creating, storing, organizing, and accessing data from a database
|
|
|
|
Select
|
Creates a subset of all records meeting stated criteria
|
|
|
|
Join
|
Relationship
|
|
|
|
Project
|
Query
|
|
|
|
Data warehouse
|
Database that stores current and historical data that maybe of interest to decision makers
|
Accessed not altered
|
|
|
Data mart
|
Subset of a data warehouse highly focused and isolated for specific users
|
|
|
|
Business Intelligence
|
Tools for consolidating analyzing and providing access to large amounts of data to improve decision making
|
|
|
|
Data mining
|
Finds hidden patterns and relationships in large database and infers rules from them to predict future behavior
|
|
