TAL Distributors Exercises For the following exercises, you do not use the TAL D
ID: 652271 • Letter: T
Question
TAL Distributors Exercises
For the following exercises, you do not use the TAL Distributors database.
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
REP Table - repnum, firstname, lastname, street, city, state, postalcode, commision, rate
Customer table -customer num customer name, street, city, state, postalcode, balance, creditlimit, repnum.... repnum should be populated from rep table
Order - ordernum, orderdate, customernum = customer num should be populated from customer table.
OrderLine - ordernum, itemnum, quotedprice - ordernum is from orders table.
Item - itemnum, onhand, category, storehouse, price.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.