Answered You can hire a professional tutor to get the answer.
1. The DBA asks for your help in planning the data archive for the following Premiere Products database: Rep (RepNum, LastName, FirstName, Street,
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 bearchived. If it does, specify which data, when it should be archived, and whether it should be archived with datafrom another table.2. The DBA denormalized some of the data in the Premiere Products database to improve performance, and oneof 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 denormalizedtable?3. Does your school have a formal disaster recovery plan? If it does, describe the general steps in the plan. If itdoes not, describe the informal steps that would be taken if a disaster occurred.
