Management Information Systems, 14e (Laudon)
Chapter 6 Foundations of Business Intelligence: Databases and Information Management
1) The relationship between entities and attributes is best illustrated by
A) the entity CUSTOMER with the attribute PRODUCT.
B) the entity CUSTOMER with the attribute PURCHASE.
C) the entity PRODUCT with the attribute PURCHASE.
D) the entity PRODUCT with the attribute CUSTOMER.
E) the entity PURCHASE with the attribute CUSTOMER.
2) The traditional file environment does not typically have a problem with
A) data inconsistency.
B) program-data independence.
C) lack of flexibility in creating ad-hoc reports.
D) poor security.
E) data sharing.
3) A(n) ________ is a characteristic or quality that describes a database entity.
A) field
B) tuple
C) key field
D) attribute
E) relationship
4) A(n) ________ is an example of non-digital data storage that is comparable to a database.
A) library card catalog
B) cash register receipt
C) doctor’s office invoice
D) list of sales totals on a spreadsheet
E) schedule of due dates on a project outline
5) ________ creates confusion that hampers the creation of information systems that integrate
data from different sources.
A) Batch processing
B) Data redundancy
C) Data independence
D) Online processing
E) Data quality
6) Data ________ occurs when the same data is duplicated in multiple files of a database.
A) redundancy
B) repetition
C) independence
D) partitions
E) discrepancy
7) When the same attribute in related data files has different values, this is called data
A) redundancy.
B) duplication.
C) dependence.
D) discrepancy.
E) inconsistency.
8) A database record is a grouping of characters into a word, a group of words, or a complete
number.
9) An attribute is a characteristic or quality used to describe a particular entity.
10) The coupling of data with the software programs that manipulate the data, such that changes
in programs requires changes to the data, is called program-data dependence.
11) Databases record information about general categories of information referred to as entities.
12) When you design the new contracts database for the publishing house mentioned above,
what fields do you anticipate needing? Which of these fields might be in use in other databases
used by the company?
13) List at least three conditions that contribute to data redundancy and inconsistency.
14) Which of the following features enables a DBMS to reduce data redundancy and
inconsistency?
A) enforces referential integrity
B) couples program and data
C) data dictionary
D) two-dimensional tables
E) minimizes isolated files with repeated data
15) A DBMS makes the
A) physical database available for different logical views.
B) relational database available for different logical views.
C) physical database available for different analytic views.
D) relational database available for different analytic views.
E) logical database available for different analytic views.
16) The logical view of a database
A) displays the organization and structure of data on the physical storage media.
B) includes a digital dashboard.
C) allows the creation of supplementary reports.
D) enables users to manipulate the logical structure of the database.
E) presents data as they would be perceived by end users.
17) Which of the following is not a DBMS for midrange computers?
A) DB2
B) Oracle
C) Microsoft SQL Server
D) Microsoft Access
E) Microsoft Exchange
18) A(n) ________ organizes data in two-dimensional tables.
A) non-relational DBMS
B) mobile DBMS
C) relational DBMS
D) hierarchical DBMS
E) object-oriented DBMS
19) Microsoft SQL Server is a(n)
A) DBMS for both desktops and mobile devices.
B) Internet DBMS.
C) desktop relational DBMS.
D) DBMS for midrange computers.
E) DBMS for mobile devices.
20) In a table for customers, the information about a single customer would reside in a single
A) field.
B) row.
C) column.
D) table.
E) entity.
21) In a relational database, a record is referred to in technical terms as a(n)
A) tuple.
B) row.
C) entity.
D) field.
E) key.
22) A field identified in a table as holding the unique identifier of the table’s records is called the
A) primary key.
B) key field.
C) primary field.
D) unique ID.
E) primary entity.
23) A field identified in a record as holding the unique identifier for that record is called the
A) primary key.
B) key field.
C) primary field.
D) unique ID.
E) key attribute.
24) In a relational database, the three basic operations used to develop useful sets of data are
A) select, project, and where.
B) select, join, and where.
C) select, project, and join.
D) where, from, and join.
E) where, find, and select.
25) The select operation
A) combines relational tables to provide the user with more information than is otherwise
available.
B) creates a subset consisting of columns in a table.
C) identifies the table from which the columns will be selected.
D) creates a subset consisting of all records in the file that meet stated criteria.
E) creates a subset consisting of rows in a table.
26) The join operation
A) combines relational tables to provide the user with more information than is otherwise
available.
B) identifies the table from which the columns will be selected.
C) creates a subset consisting of columns in a table.
D) organizes elements into segments.
E) creates a subset consisting of rows in a table.
27) The project operation
A) combines relational tables to provide the user with more information than is otherwise
available.
B) creates a subset consisting of columns in a table.
C) organizes elements into segments.
D) identifies the table from which the columns will be selected.
E) creates a subset consisting of rows in a table.
28) The data dictionary serves as an important data management tool by
A) assigning attributes to the data.
B) creating an inventory of the data elements contained in the database.
C) presenting data as end users or business specialists would perceive them.
D) maintaining data in updated form.
E) providing a guide to database terms and settings.
29) An automated or manual file that stores information about data elements and data
characteristics such as usage, physical representation, ownership, authorization, and security is
the
A) data dictionary.
B) data definition diagram.
C) entity-relationship diagram.
D) relationship dictionary.
E) data table.
30) The specialized language programmers use to add and change data in the database is called
A) a data access language.
B) a data manipulation language.
C) structured query language.
D) a data definition language.
E) a DBMS.
31) The most prominent data manipulation language today is
A) Access.
B) DB2.
C) SQL.
D) Crystal Reports.
E) NoSQL.
32) DBMSs typically include report-generating tools in order to
A) retrieve and display data.
B) display data in an easier-to-read format.
C) display data in graphs.
D) perform predictive analysis.
E) analyse the database’s performance.
33) The process of streamlining data to minimize redundancy and awkward many-to-many
relationships is called
A) normalization.
B) data scrubbing.
C) data cleansing.
D) data defining.
E) optimization.
34) A schematic of the entire database that describes the relationships in a database is called a(n)
A) data dictionary.
B) intersection relationship diagram.
C) entity-relationship diagram.
D) data definition diagram.
E) data analysis table.
35) A one-to-many relationship between two entities is symbolized in a diagram by a line that
ends with
A) one short mark.
B) two short marks.
C) three short marks.
D) a crow’s foot.
E) a crow’s foot topped by a short mark.
36) You are creating a database to store temperature and wind data from national airport
locations. Which of the following fields is the most likely candidate to use as the basis for a
primary key in the Airport table?
A) address
B) city
C) airport code
D) state
E) day
37) The logical and physical views of data are separated in a DBMS.
38) Every record in a file should contain at least one key field.
39) NoSQL technologies are used to manage sets of data that don’t require the flexibility of
tables and relations.
40) The DBMS programming language that end users and programmers use to manipulate data
in the database is called CGI.
41) Complicated groupings of data in a relational database need to be adjusted to eliminate
awkward many-to-many relationships.
42) A physical view shows data as it is actually organized and structured on the data storage
media.
43) DBMS have a data definition capability to specify the structure of the content of the
database.
44) Relational DBMSs use key field rules to ensure that relationships between coupled tables
remain consistent.
45) The small publishing company you work for wants to create a new database for storing
information about all of their author contracts. What factors will influence how you design the
database?
46) List and describe three main capabilities or tools of a DBMS.