Emails us- Call US

Assignment help 6344

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 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 denormalized table?


15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.