• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/39

Click to flip

39 Cards in this Set

  • Front
  • Back
A piece of information describing a particular entity
Attribute
The logical description of the entire database showing all the data elements and relationships among them
Conceptual schema
A special organizational function for manageing the organization's data resources that is concerned with information policy, data planning, maintenance of data dictionaries, and data quality standards
Data administration
Activities for detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant.
Data cleansing
The component of a database management system that defines each data element as it appears in the database
Data definition language
An automated or manual tool for storing and organiuzing information about the data maintained in a database
Data dictionary
A field
Data element
The presense of different values for the same attribute when the same data are stored in multiple locations
Data inconsistency
A language associated with a database management system that end users and programmers use to manipulate data in the database
Data manipulation language
A small data warehouse containing only a portion of the organization's data for a specified function or popultion of users
Data mart
Analysis of lare pools of data to find patterns and rules that can be used to guide decision making and predict future behavior
Data mining
A survey and/or sample of files to determine accuracy and completeness of data in an information system
Data quality audit
The presence of duplicate data in multiple data files
Data redundancy
A database with reporting and query tools that stores current and historical data extracted from various operational systems and consollidated for management reporting and analysis
Data warehouse
A group of related fields
Database
Refers to the more technical and operational aspects of managing data, including physical database design and maintenance
Database administration
Special software to create and maintain a database and enable individual business applications to extract the data they need without having to create seperate files or data defintions in their computer programs
Database management system (DBMS)
A computer in a client/server environment that is responsible for running a database management system (DBMS) to process structured query language (SQL) statements and perform database management tasks
Database server
A collection of data organized to service many applications at the same time by storing and managing data so that they appear to be in one location
Database (Rigorous defintion)
A database that is stored in more then one physical location. Parts or copies of the database are physically stored in one location, and other parts or copies are stored and maintained in other locations
Distributed database
A person, place, thing, or event about which information must be kept
Entity
A methodology for documenting databases illustrating the relationship between various entities in the database
Entity-relationship diagram
A grouping of characters into a word, a group of words, or a complete number, such as a person's name or age
Field
A group of records of the same type
File
One type of logical database model that organizes data in a treelike structure. A record is subdivided into segments that are connected to each other in one-to-many parent-child relationships
Hierarchical DBMS
An approach to data manageement that organizes data as a network of nodes linked in any pattern the user specifies; the nodes can contain text, graphicsm sound, full-motion video, or executable programs
Hypermedia database
Formal rules governing the maintenance, distribution, and use of information in an organization
Information policy
A field in a record that uniquely identifies instances of that record so that it can be retrived, updatedm or sorted
Key Field
Older logical database model that is useful for depicting many-to-many relationships
Network DBMS
The process of creating small stable data structures from complex groups of data when designing a relational database
Normalization
An approach to data management that stores both data and the procedures acting on the data as objects that can be automatically retrieved and shared; the objects can contain multimedia
Object-oriented DBMS
A database management system that combines the capabilites of a relational database management system (DBMS) for storing traditional information and capabilites of an object-oriented DBMS for storing graphics and multimedia
Object-relational DBMS
Capability for manipulating and analyzing large volumes of data from multiple persepctives
Online analytical processing (OLAP)
The close relationship between data stored in files and the software programs that update and maintain those files. Any change in data organization or format requires a change in all the programs associated with those files
Program-data dependence
A group of related fields
Record
A type of logical database model that treats data as if they were stored in two-dimensional tables. It can relate data stored in one table to data in another as long as the two tables share common data element.
Relational DBMS
The standard data manipulation language for relational database management systems
Structured query language (SQL)
The specific set of data from the database that is required by each user or application programed
Subschemes
A row or record in a relational database
Tuple