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;
33 Cards in this Set
- Front
- Back
database management system (DBMS)
|
a group of programs that manipulates the database and provides an interface between the database and the user of the database and other application programs.
|
|
database administrator
|
a skilled IS professional who directs all activities related to an organization's database.
|
|
hierarchy of data
|
bits, characters, fields, records, files, and databases.
|
|
character
|
a basic building block of information, consisting of uppercase letters, lowercase letters, numeric digits, or special symbols.
|
|
entity
|
a generalized class of people, places, or things for which data is collected, stored, and maintained. (eg. employees, inventory, and customers)
|
|
field
|
typically a name, number, or combination of characters that describes an aspect of a business object or activity. (employee, location, or truck)
|
|
attribute
|
a characteristic of an entity. (employee number, last name, first name, hire date, and department number are attributes for an employee)
|
|
record
|
a collection of related data fields.
|
|
data item
|
the specific value of an attribute.
|
|
file
|
a collection of related records.
|
|
key
|
a field or set of fields in a record that is used to identify the record.
|
|
primary key
|
a field or set of fields that uniquely identifies the record. (employee number)
|
|
traditional approach to data management
|
an approach whereby separate data files are created and stored for each application program.
|
|
database approach to data management
|
an approach whereby a pool of related data is shared by multiple application programs.
|
|
planned data redundancy
|
a way of organizing data in which the logical database design is altered so that certain data entities are combined, summary totals are carried in the data records rather than calculated from elemental data, and some data attributes are repeated in more than one data entity to improve database performance.
|
|
data model
|
a diagram of entities and their relationships.
|
|
enterprise data modeling
|
data modeling done at the level of the entire enterprise.
|
|
entity relationship diagrams
|
data models that use basic graphical symbols to show the organization of and relationships between data.
|
|
relational model
|
a database model that describes data in which all data elements are placed in two dimensional tables, called relations, which are the logical equivalent of files.
|
|
domain
|
the allowable values for data attributes.
|
|
selecting
|
manipulating data to eliminate rows according to certain criteria.
|
|
projecting
|
manipulating data to eliminate columns in a table
|
|
data cleanup
|
the process of looking for and fixing inconsistencies to ensure that data is accurate and complete
|
|
joining
|
involves combining two or more tables
|
|
schema
|
a description of the entire database.
|
|
linked
|
manipulating two or more tables that share at least one common data attribute to provide useful information and reports.
|
|
data definition language (DDL)
|
a collection of instructions and commands used to define and describe data and relationships in a specific database.
|
|
data dictionary
|
a detailed description of all the data used in the database.
|
|
concurrency control
|
a method of dealing with a situation in which two or more people need to access the same record in a database at the same time.
|
|
data manipulation language
|
the commands that are used to manipulate the data in a database
|
|
data administrator
|
a nontechnical positio responsible for defining and implementing consistent principles for a variety of data issues.
|
|
data warehouse
|
a database that collects business information from many sources in the enterprise, covering all aspects of the company's processes, products, and customers.
|
|
data mart
|
a subset of a data warehouse
|