For the following exercises, you do not use the Solmaris Condominium database.
1. The DBA asks for your help in planning the data archive for the following Solmaris Condominium database:
Location (LocationNum, LocationName, Address, City,
State, PostalCode)
Owner (OwnerNum, LastName, FirstName, Address, City,
State, PostalCode)
CondoUnit (CondoID, LocationNum, UnitNum, SqrFt, Bdrms, Baths,
CondoFee, OwnerNum)
ServiceCategory (CategoryNum, CategoryDescription)
ServiceRequest (ServiceID, CondoID, CategoryNum, Description,
Status, EstHours, SpentHours, NextServiceDate)
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 to archive, when it should be archived, and whether it should be archived with data from another table.

2. The DBA denormalized some of the data in the Solmaris Condominium database to improve performance, and one of the resulting tables is the following:
CondoUnit (CondoID, LocationNum, UnitNum, SqrFt, Bdrms, Baths,
CondoFee, OwnerNum, LastName, FirstName)
Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized table?
3. Interview the DBA at your school or at a local business to determine the security and access privilege procedures used to safeguard data, and then document your findings in a report.
4. Regression testing is one technique that quality assurance individuals use to test a database system. Use computer magazines, books, or the Internet to research regression testing. Then prepare a report that defines regression testing and explain its importance in the database system testing process. Cite your references.