Skip to content
Solved Assignments

Premiere Products Exercise Chapter 8 Solution Correct Answers

Chapter 8 exercise answers for Premiere Products database.

Preview 3 of 9 pages

See the first 3 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Premiere Products Exercise Chapter 8 Solution Correct Answers 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 anothe r table. 2. The DBA denormalized some of the data in the Premiere Products database to improve performance, and one of the resulting t ables 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.

  2. Page 2
  3. Page 3
    Read page 3 as text

    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

6 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Information Technology study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.