Using SQL Server Management Studio (SSMS) 2016 or 2017:

1. Drop the Index OwnerCityState

2. Assume the CondoUnit table has been created, but there are no integrity constraits. Create the necessary integrity constraints so that the condo fee must be less than $1,000 and the bedrooms must be greater than 0.

3. Ensure that the following are foreign keys for the Condominium Tables:

a. LocationNum is a foreign key in the CondoUnit table.

b. OwnerNum is a foreign key in the ServiceRequest table.

c. CategoryNum is a foreign key in the ServiceRequest table.

d. CondoID is a foreign key in the ServiceRequest table.

4. Add to the CondoUnit table a new character field named FeePaid that is one character in length.