In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the original Solmaris Condominium Group database so your data will not reflect the changes you made in Chapter 3.) If you have access to a DBMS, use the DBMS to perform the tasks and explain the steps you used in the process. If not, explain how you would use SQL to obtain the desired results. Check with your instructor if you are uncertain about which approach to take.

The management of Solmaris Condominium Group wants to split service category 2 (Heating/Air Conditioning) into separate categories by changing category 2 to “Heating” and adding a new category 7 for “Air Conditioning.” Would management encounter any problems in modifying the Service Category table? What additional updates would management need to make to ensure that the data in the database is correct?