DATABASE ADMINISTRATION - Concepts of Database Management - page 272

4. What is a disaster recovery plan?
5. What are data archives? What purpose do they serve? What is the relationship between a database and its data
archives?
6. Name five categories that you usually find on a DBMS evaluation and selection checklist.
7. What is a shared lock? What is an exclusive lock?
8. What is a LAN?
9. What is context-sensitive help?
10. What is an intranet?
11. After a DBMS has been selected, what is the DBA's role in DBMS maintenance?
12. What are the DBA's responsibilities with regard to the data dictionary?
13. Who trains computer users in an organization? What is the DBA's role in this training?
14. What are the DBA's database design responsibilities?
15. What is the difference between production and test systems?
16. What is meant by “tuning a design”?
17. How can splitting a table improve performance?
18. What is denormalization?

272

Premiere Products Exercises

For the following exercises, you do not use the Premiere Products database.
1. The DBA asks for your help in planning the data archive for the following Premiere Products database:
Rep (RepNum, LastName, FirstName, Street, City, State,
Zip, Commission, Rate)
Customer (CustomerNum, CustomerName, Street, City,
State, Zip, Balance, CreditLimit, RepNum)
Orders ( OrderNum , OrderDate, CustomerNum)
OrderLine (OrderNum, PartNum, NumOrdered, QuotedPrice)
Part ( PartNum , Description, OnHand, Class, Warehouse, Price)
Determine which data from the database to archive; that is, for each table, specify whether data needs to be
archived. If it does, specify which data, when it should be archived, and whether it should be archived with data
from another table.
2. The DBA denormalized some of the data in the Premiere Products database to improve performance, and one
of the resulting tables is the following:
Customer (CustomerNum, CustomerName, Street, City,
State, Zip, Balance, CreditLimit, RepNum, RepName)
Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormal-
ized table?
3. Does your school have a formal disaster recovery plan? If it does, describe the general steps in the plan. If it
does not, describe the informal steps that would be taken if a disaster occurred.

Henry Books Case

Ray Henry wants you to complete the following exercises.You do not use the Henry Books database for any of these
exercises.
1. The DBA asks for your help in planning the data archive for the following Henry Books database:
Branch ( BranchNum , BranchName, BranchLocation, NumEmployees)
Publisher (PublisherCode, PublisherName, City)
Author ( AuthorNum , AuthorLast, AuthorFirst)
Book (BookCode, Title, PublisherCode, Type, Price, Paperback)
Wrote ( BookCode , AuthorNum , Sequence)
Inventory (BookCode, BranchNum, OnHand)