Consultant (ConsltNum, LastName, FirstName,Street,
City, State, ZipCode, Hours, Rate)
Client (ClientNum, ClientName, Street,City,
State, ZipCode, Balance, CreditLimit,ConsltNum)
WorkOrders (OrderNum, OrderDate, ClientNum)
OrderLine (OrderNum, TaskID, ScheduleDate,QuotedPrice)
Tasks (TaskID, Description, Category,Price)
Determine which data from the database to archive; thatis, for each table, specify whether data needs to be archived. Ifit does, specify which data, when it should be archived, andwhether it should be archived with data from anothertable.
Please tell me which table should archive and do we archive datawhose information changes daily or often or we dont archive
Expert Answer
An answer will be send to you shortly. . . . .