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;
66 Cards in this Set
- Front
- Back
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 related feilds.
|
record
|
|
A group of records of the same type.
|
file
|
|
A group of related files
|
database
|
|
a person, place, thing, or event about which information must be kept
|
entity
|
|
A piece of imformation describing a particular entity
|
attribute
|
|
field in a record that uniquely identifies instances of that record so that it can be retrieced, updated, or sorted.
|
key field.
|
|
The presence of duplicate data in multiple data files.
|
data redundancy
|
|
The presence of different values for same attribute when the same data are stored in multiple locations.
|
data inconsistency
|
|
The close relationship between data stored in files and the software programs that update and maintain those data. Any change in the software program requires a change in the data associated with thoses files.
|
program-data dependence
|
|
A collection of data organized to serice many application oat the same time by storing and managing data so that they appear to be in one location.
|
database (rigorous dedinition)
|
|
Special software to create and maintain a database and enable individual business applications to extract the data they need without having to create separate files or data definitions in their computer program
|
database management system (DBMS)
|
|
The logical decription of the entire database showing all the data elements and relationships among them.
|
conceptual schema
|
|
The specific set of data from the database that is required by each user or application program.
|
subschema
|
|
The component of a database management system that defines each data element as it appears in the database
|
data definition language
|
|
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 related feilds.
|
record
|
|
A group of records of the same type.
|
file
|
|
A group of related files
|
database
|
|
a person, place, thing, or event about which information must be kept
|
entity
|
|
A piece of imformation describing a particular entity
|
attribute
|
|
field in a record that uniquely identifies instances of that record so that it can be retrieced, updated, or sorted.
|
key field.
|
|
The presence of duplicate data in multiple data files.
|
data redundancy
|
|
The presence of different values for same attribute when the same data are stored in multiple locations.
|
data inconsistency
|
|
The close relationship between data stored in files and the software programs that update and maintain those data. Any change in the software program requires a change in the data associated with thoses files.
|
program-data dependence
|
|
A collection of data organized to serice many application oat the same time by storing and managing data so that they appear to be in one location.
|
database (rigorous dedinition)
|
|
Special software to create and maintain a database and enable individual business applications to extract the data they need without having to create separate files or data definitions in their computer program
|
database management system (DBMS)
|
|
The logical decription of the entire database showing all the data elements and relationships among them.
|
conceptual schema
|
|
The specific set of data from the database that is required by each user or application program.
|
subschema
|
|
The component of a database management system that defines each data element as it appears in the database
|
data definition language
|
|
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 related feilds.
|
record
|
|
A group of records of the same type.
|
file
|
|
A group of related files
|
database
|
|
a person, place, thing, or event about which information must be kept
|
entity
|
|
A piece of imformation describing a particular entity
|
attribute
|
|
field in a record that uniquely identifies instances of that record so that it can be retrieced, updated, or sorted.
|
key field.
|
|
The presence of duplicate data in multiple data files.
|
data redundancy
|
|
The presence of different values for same attribute when the same data are stored in multiple locations.
|
data inconsistency
|
|
The close relationship between data stored in files and the software programs that update and maintain those data. Any change in the software program requires a change in the data associated with thoses files.
|
program-data dependence
|
|
A collection of data organized to serice many application oat the same time by storing and managing data so that they appear to be in one location.
|
database (rigorous dedinition)
|
|
Special software to create and maintain a database and enable individual business applications to extract the data they need without having to create separate files or data definitions in their computer program
|
database management system (DBMS)
|
|
The logical decription of the entire database showing all the data elements and relationships among them.
|
conceptual schema
|
|
The specific set of data from the database that is required by each user or application program.
|
subschema
|
|
The component of a database management system that defines each data element as it appears in the database
|
data definition language
|
|
The standard data manipulation language for relational database management systems
|
Structured Query Languagd(SQL)
|
|
An automated or manual tool for storing and organizing information about the data maintained in a database
|
data dictionary
|
|
A field
|
data element
|
|
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 s long as the two tables share a common data element
|
relational DBMS
|
|
A row or record in a relational database.
|
tuple
|
|
Older logical database model that organizes data in a treelike structure. A record issubdivided into segments that are connected to each other in one-to-many parent-child relationships
|
hierarchical DBMS
|
|
Older logical database model tht is useful for depiction many-to-many relationships
|
network DBMS
|
|
An approach to data management that stores both data and the procedures actiong 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 ombines the capabilities of a relational DBMS for storing traditional information and the capabilities of an object-oriented DBMS.
|
object-relational DBMS
|
|
A methodology for documenting databases illustrating the relationship between various entities in the database.
|
entity-telationship diagram
|
|
The process of creating small, stabel, and adoptive data structures from complex groups of data when designing a relational database
|
normalization
|
|
A databasethat is stored in more than one physical location. Parts(partitioned database) or copies (replicated database) of the database are physically storedin one location, and other parts or copies are stored and maintained in other locations.
|
distributed database
|
|
A special organizational function for managing the organization's data resources, concerned with information policy, data planning, maintenance of data dictionaries, and data quality standards.
|
data adminstration
|
|
Formal rules governing the maintenance, distribution,and use of information in an organization.
|
information policy
|
|
Refers to the more technical and operational aspects of managing data, including physical database ddesign and maintenance.
|
database adminstration
|
|
Capability for manipulationg and analyzing large volumes of data from multiple perspectives.
|
online analytical processing (OLAP)
|
|
A database, with reporting and query tools, that stores current and historical data extracted from various operational systems and consolidated for management repoeting and analysis.
|
data warehouse.
|
|
A small data warehouse containing only a portion of the owgaization's data for a specified function or population of users.
|
data mart
|
|
Analysis of large pools of data to find patterns and rules that can be used to guide decision making and predict future behavior.
|
datamining
|
|
An apoproach to data management that organizes dat as a network of nodes linked in any pattern the user specifies, the nodes can contain text, graphics, sound, full-motion video, or executable programs.
|
hypermedia database
|
|
A computer in a client/server environment that is responsible for running a DBMS to process AQL statements and perform database management tasks.
|
database server
|