Chapter 4 Relational Databases

Accounting Information Systems, 12e (Romney/Steinbart)
Chapter 4 Relational Databases

1) Using a file-oriented approach to data and information, data is maintained in
A) a centralized database.
B) many interconnected files.
C) many separate files.
D) a decentralized database.
Answer: C
Page Ref: 88
Objective: Learning Objective 1
Difficulty : Easy
AACSB: Analytic

2) In a well-structured relational database,
A) every table must be related to at least one other table.
B) every table must be related to all other tables.
C) one table must be related to at least one other table.
D) one table must be related to all other tables.
Answer: A
Page Ref: 96-98
Objective: Learning Objective 4
Difficulty : Moderate
AACSB: Reflective Thinking

3) File-oriented approaches create problems for organizations because of
A) multiple transaction files.
B) a lack of sophisticated file maintenance software.
C) multiple users.
D) multiple master files.
Answer: D
Page Ref: 88
Objective: Learning Objective 1
Difficulty : Moderate
AACSB: Analytic

4) Which statement is true regarding file systems?
A) Transaction files are similar to ledgers in a manual AIS.
B) Multiple master files create problems with data consistency.
C) Transaction files are permanent.
D) Individual records are never deleted in a master file.
Answer: B
Page Ref: 88
Objective: Learning Objective 1
Difficulty : Easy
AACSB: Analytic




1
Copyright © 2012 Pearson Education, Inc. publishing as Prentice Hall

,5) The ________ acts as an interface between the database and the various application programs.
A) data warehouse
B) database administrator
C) database management system
D) database system
Answer: C
Page Ref: 88
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic

6) The combination of the database, the DBMS, and the application programs that access the database
through the DBMS is referred to as the
A) data warehouse.
B) database administrator.
C) database system.
D) database manager.
Answer: C
Page Ref: 88
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic

7) The person responsible for the database is the
A) data coordinator.
B) database administrator.
C) database manager.
D) database master.
Answer: B
Page Ref: 88
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic

8) All of the following are benefits of the database approach except:
A) Data integration and sharing
B) Decentralized management of data
C) Minimal data redundancy
D) Cross-functional analysis and reporting
Answer: B
Page Ref: 89
Objective: Learning Objective 1
Difficulty : Easy
AACSB: Analytic




2
Copyright © 2012 Pearson Education, Inc. publishing as Prentice Hall

, 9) The physical view of a database system refers to
A) how a user or programmer conceptually organizes and understands the data.
B) how the DBMS accesses data for a certain application program.
C) how and where the data are physically arranged and stored.
D) how master files store data values used by more than one application program.
Answer: C
Page Ref: 90
Objective: Learning Objective 2
Difficulty : Moderate
AACSB: Analytic

10) The ________ handles the link between the way data are physically stored and each user's logical
view of that data.
A) data warehouse
B) data dictionary
C) database management (DBMS) software
D) schema
Answer: C
Page Ref: 90
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic

11) The logical structure of a database is described by the
A) data dictionary.
B) schema.
C) database management system.
D) internal level.
Answer: B
Page Ref: 90
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic

12) The schema that provides an organization-wide view of the entire database is known as the
A) external-level schema.
B) internal-level schema.
C) conceptual-level schema.
D) logical view of the database.
Answer: C
Page Ref: 90
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic




3
Copyright © 2012 Pearson Education, Inc. publishing as Prentice Hall