Review Questions -
2. What are the DBA's responsibility regarding access privileges?
4. What is a disaster recovery plan?
8. What is LAN?
10. What is an intranet?
12. What are the DBA's responsibilities with regard to the data dictionary?
14. What are the DBA's database design responsibilities?
TAL Distributors Exercises -
For the following exercise, you do not use the TAL Distribution database.
1. The DBA asks for your help in planning the data archive for the following TAL Distribution database:
Rep (RepNum, LastName, FirstName, Street, City, State, Postalcode, Commission, Rate)
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum)
Orders (OrderNum, OrderDate, CustomerNum)
OrderLine (OrderNum, ItemNum, NumOrdered, QuotedPrice)
Item (ItemNum, Description, OnHand, Category, Storehouse, 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.