Determine which data from the database to archive that is


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 denormalized 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.

4. Use your computer magazines, books or the Internet to investigate the role the cloud computing plays in disaster recovery planning. Then prepare a report that defines cloud computing and explains how it can be used in a disaster recovery planning. Make proper Cite your sources.

Solution Preview :

Prepared by a verified Expert
Database Management System: Determine which data from the database to archive that is
Reference No:- TGS01235061

Now Priced at $25 (50% Discount)

Disaster recovery in the cloud is a relatively new concept, and like many technology trends, there's a lot of hype and misinformation out there. Cloud computing, along with mobile and tablet devices, accounts for much of the high-tech buzz these days. But when it comes to hype, the cloud seems to absorb more than its fair share, which has had the unintended consequence of sometimes overshadowing its real utility.

Recommended (99%)

Rated (4.3/5)