8.1 1. The DBA asks for your help in planning the data archive for the following

Question

8.1

1. The DBA asks for your help in planning the data archive for the following TAL Distributors database: Rep (RepNum, LastName, FirstName, Street, 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.

Explanation / Answer

1)

Given tables ..

Rep, Customer, Orders, OrderLine, Item

As Repository table do not contain more or huge data .. so archieve table not required.

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

As more number of customers are there.. we will have more orders and similarly orderLine. So both Orders and OrderLIne tables must be archieved with taking index data as OrderNum, since it acts as primary key(unique) for both tables.

Item table also mus archieve, As number of items increases in cart, it will be difficult to handle. So, archieve with taking ItemNum as primary key.

Related Questions

Navigate

• Browse (All)
• Browse 8
• Subjects

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