The DBA asks for your help in planning the data archive for the following Colonial Adventure Tours database:
Guide (GuideNum, LastName, FirstName, Address, City, State, PostalCode, PhoneNum, HireDate)
Trip (TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type, Season)
Customer (CustomerNum, LastName, FirstName, Address, City, State, PostalCode, Phone)
Reservation (ReservationID, TripID, TripDate, NumPersons, TripPrice, OtherFees, CustomerNum)
TripGuides (TripID, GuideNum)
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.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.