Chapter 6: Databases and data warehouses

Analyzing an organization's data and identifying the relationships among the data is called ____.
1. encapsulation
2. inheritance
3. data modelling
4. data redundancy
A(n) ____ creates a temporary table that is a subset of the original table or tables.
1. data model
2. relational operation
3. object
4. composite key
In a relational database, a table of records is called a(n) ____.
1. attribute
2. relation
3. tuple
4. schema
The fields related to the same entity make up a(n) ____.
1. record
2. character
3. field
4. file
____ has become the query language of choice for many developers of relational DBMSs.
1. SQL
2. ERD
3. DBA
4. Inheritance
The smallest piece of data is a(n) ____.
1. record
2. character
3. field
4. table
A(n) ____ is the general logical structure in which records are stored within a database and the method used to establish relationships among the records.
1. record
2. database model
3. schema
4. data mart
A(n) ____ is a large, typically relational, database that supports management decision making.
1. data warehouse
2. entity
3. data dictionary
4. schema
A(n) ____ is one piece of information about an entity, such as the last name or first name of a student, or the student's street address.
1. record
2. character
3. field
4. file
With respect to the object-oriented model, the combined storage of both data and the procedures that manipulate them is referred to as ____.
1. inheritance
2. a relational operation
3. encapsulation
4. a data model
In a relational database, a record is called a(n) ____.
1. attribute
2. relation
3. tuple
4. schema
A(n) ____ is any object about which an organization chooses to collect data.
1. entity
2. primary key
3. record
4. schema
A(n) ____ is a graphical representation of all entity relationships.
1. SQL
2. DBMS
3. DBA
4. ERD
A(n) ____ can be maintained, for instance, for lecturers and students in a university database.
1. one-to-many relationship
2. one-to-one relationship
3. many-to-many relationship
4. primary key
In a relational database, a field is called a(n) ____.
1. attribute
2. relation
3. tuple
4. schema
A collection of related records, such as all the records of a college's students, is called a(n) ____.
1. record
2. character
3. field
4. file
The description of each table structure and types of fields become part of a(n) ____, which is a repository of information about the data and their organization.
1. metadata
2. data dictionary
3. schema
4. entity relationship
A unique key can serve as a(n) ____.
1. character
2. file
3. record
4. primary key
The program used to build databases, populate them with data, and manipulate the data is called a(n) ____.
1. structured query language
2. data mart
3. database management system
4. table
Organizations often organize their data warehouse as a collection of ____, smaller collections of data that focus on a particular subject or department.
1. data models
2. data marts
3. objects
4. records

Chapter 6: Databases and data warehouses

Test Yourself on MIS