Flashcards in Chapter 7: Databases and Data Warehouses Deck (41)
Data can be maintained in one of the two ways: the _________ - which has no mechanism for tagging, retrieving, and manipulating data- and the _________, which does have this mechanism.
traditional files approach
_________ wastes storage space (and consequently money) and is inefficient.
Inaccuracies affect _______ - the characteristic that the data represents what it is supposed to represent and that it is complete and correct.
An ________ is any object about which an organization chooses to collect data.
The smallest piece of data is a _________.
A ______ is one piece of information about an entity, such as the last name or first name of a student, or the student's address.
The fields related to the same entity make up a _______.
A collection of related records, such as all the records of a college's students, is called a _______.
The program used to build databases, populate them with data, and manipulate the data is called a ________.
database management system (DBMS)
The program used to build databases, populate them with data, and manipulate the data is called a _____.
database management system (DBMS)
Data is accessed in a database by sending messages called _____, which request data from specific records and/or fields and direct the computer to display the results.
The _________ consists of tables. Its roots are in relational algebra, but you do not have to know relational algebra to build and use them.
relational database model
A ___ is a field whose values identify records either for display or for processing.
A _____ combines data from two or more tables.
A _____ is the field by which records in a table are uniquely identified. If your query specified that you wanted the record whose CustomerID value is 36003, the system would retrieve the record of the person you wanted, even if there are more records of people with the same name.
A _____ is a combination of two or more fields that together serves as a primary key, because it is impractical to use a single field as a primary key.
A ____ is created when a group of employees belongs to only one department. All would have the same department number as a foreign key in their records, and none will have more than one department key.
A ______ can be maintained, for instance, for professors and students in a college database as a professor might have many students, and a student might have many professors.
The ______ uses the object-oriented approach to maintaining records.
object-oriented database model
The combined storage of both data and the procedures that manipulate them is referred to as ______.
The ability in object-oriented structures to create a new object automatically by replicating all or some of the characteristics of a previously developed object (called the parent object) is called _______.
A _______ creates a temporary table that is a subset of the original table or tables. It allows you to create a report containing records that satisfy a condition, create a list with only some fields about an entity, or product a report from a join table, which combines relevant data from two or more tables. If so desired, the user can save the newly created table.
The three most important relational operations are ____, ____, and ____.
____ is the selection of records that meet certain conditions. For example, a human resources manager might need a report showing the entire record of every employee whose salary exceeds $60,000.
______ is the selection of certain columns from a table, such as the salaries of all the employees.
In relational model, the joining of data from multiple tables is a called a ____.
________ has become the query language of choice for many developers of relational DBMSs. It is an international standard and is provided with most relational database management programs.
Structured Query Language (SQL)
The _____ describes the structure of the database being designed: the names and types of fields in each record type and the general relationships among different sets of records or files.
The description of each table structure and types of fields become part of a _____, which is a repository of information about the data and their organization.