The DBA asks for your help in planning the data archive for the following TAL Di

Question

The DBA asks for your help in planning the data archive for the following TAL Distributors database:

Rep (RepNum, LastName, FirstName, Stree,

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.

*note, it is answered under Concepts of Database Management Ed.8, Ch8 TDE1, but one of the comments said it was completely wrong so I am looking for clarificaiton.

Explanation / Answer

Given Tables:

Rep (RepNum, LastName, FirstName, Street,City, State, PostalCode, Commission, Rate):

This table needs not to be archieved, as it contains the details which are regularily used.

Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum):

Customer table needs to be archieved. since we have more number of customers. so all customer details must be archived, with taking attribute CustomerNum as primary key.

Orders (OrderNum, OrderDate, CustomerNum):

OrderLine (OrderNum, ItemNum, NumOrdered, QuotedPrice):

As there are more number of order than the customers may be double or triple, it needs to archieved same as Order Line table.

Item (ItemNum, Description, OnHand, Category, StoreHouse, Price):

Item table must be archieved as there would be many items and more chance for the items to get increase, so this table needs to archieved by taking the ItemNum as primary key.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.