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;
24 Cards in this Set
- Front
- Back
a specialist responsible for maintaining standards for the development,maintenance,and security of an organization's database.
|
Database Administrator(DBA)
|
|
An approach to the storage & processing of data in which independent files are consolidated into a common pool, or database of records avail to diff applicatio programs and end users for processing & data retrieval.
|
Database Management Approach
|
|
A set of computer programs that controls the creation, maint,& utilization of the databases of an organization.
|
Database Management System(DBMS)
|
|
A software module and database containing descriptions & definitions concerning the structure,data elements,interrelationships & other characteristics of a database.
|
Data Dictionary
|
|
A process in which the relatonships between data elements are identified and defined to develop data models.
|
Data Modeling
|
|
Using special-purpose software to analyze data from a data warehouse to find hidden patterns and trends.
|
Data Mining
|
|
The storage of a particular data element or elements in more than one physical location or form.
|
Data Redundancy
|
|
A managerial activity that applies info systems technology & management tools to the task of managing an organizations data rersources. Itys three major components are database admin, data admin, and data planning.
|
Data Resource Management
|
|
Organizing data into specialized files of data records designed for processing only by specific application programs. Contrast with database management approach.
|
File Processing
|
|
Data elements that are independent of the physical data media on which they are recorded.
|
Logical Data Elements
|
|
Data about data; data describing the structure, data elements, interrelationships and other characteristics of a database.
|
Metadata
|
|
A query language that is becoming a standard for advanced database management system packages. A queary's basic form is Select...From...Where.
|
Structured Query Language(SQL)
|
|
A group of related records
|
File or Table
|
|
What are four types of files?
|
-Master File
-Transaction File -History File -Archival File |
|
An integrated collection of logically related data elements
|
Database
|
|
Name five common database structures
|
-Hierarchical
-Network -Relational -Object-oriented -Multi-dimensional |
|
Most commonly used structure for database
|
Relational Structure
|
|
Database planning and design is bottom-up process. (T/F)
|
False
Top-down |
|
What are the planning stages of developing a database?
|
-Develop an enterprise model
-Define the information needs of end users -Identify the key data elements |
|
Managerial Activity:
-Uses data management, data warehousing and other IS technologies -Manages data for business stakeholders |
Data Resource Management
|
|
Cats OR felines AND NOT dogs OR Broadway
|
Boolean Logic:
-George Boole 1800's -Used to refine searches -Three logical operators |
|
World's Largest Database
|
????
|
|
Database Maintenance is supported by what?
|
DBMS
|
|
Name three DBMS Tools
|
-4GL programming language
-Built-in software development tools -Data manipulation language (DML) statements that eliminate conventional programming |