08

Database Processing, 13e (Kroenke/Auer)
Chapter 8: Database Redesign

1) Database redesign is rarely needed because databases are usually built correctly the first time.
Answer: FALSE
Diff: 1 Page Ref: 367

2) In a real sense, information systems and organizations do not just influence each other, but rather they create each other.
Answer: TRUE
Diff: 1 Page Ref: 367

3) A continuous circular process of changes in user behaviors and change in the information systems they use is a natural outcome of information system use.
Answer: TRUE
Diff: 1 Page Ref: 367

4) The continuous circular process of changes is known as the Systems Development Life Cycle (SDLC).
Answer: TRUE
Diff: 1 Page Ref: 367

5) Database redesign is equally difficult whether or not the database has data in it.
Answer: FALSE
Diff: 1 Page Ref: 367

6) In the database redesign process, it is often useful to test whether certain conditions or assumptions are valid before proceeding with the redesign.
Answer: TRUE
Diff: 1 Page Ref: 3

7) In the database redesign process, two SQL tools are useful for testing whether or not certain conditions or assumptions are valid: uncorrelated subqueries and EXISTS/NOT EXISTS.
Answer: FALSE
Diff: 2 Page Ref: 367

8) A correlated subquery looks very different from a noncorrelated subquery.
Answer: FALSE
Diff: 2 Page Ref: 368

9) Correlated subqueries can be used to verify functional dependencies.
Answer: TRUE
Diff: 2 Page Ref: 367-371

10) In a correlated subquery, the same table is used in the upper and lower SELECT statements.
Answer: TRUE
Diff: 2 Page Ref: 368-370
11) In the SQL statement:

SELECT S1.CustName, S1.SalesRepNo FROM SALES S1;

the "S1" is called an alias.
Answer: TRUE
Diff: 2 Page Ref: 369

12) In a correlated subquery, the DBMS can run the lower SELECT statement by itself and then send the results to the upper SELECT statement.
Answer: FALSE
Diff: 2 Page Ref: 368-370

13) In a