The following exercises are based on the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. No computer work is required.
1. Using the types of entities found in the Solmaris Condominium Group database (condo locations, owners, condo units, service categories, and service requests), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but not in third normal form. In each case, justify your answer and show how to convert to the higher forms.
2. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form:
Location (LocationNum, LocationName, (UnitNum, SqrFt, Bdrms, Baths, CondoFee))
3. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form:
CondoUnit (CondoID, LocationNum, UnitNum, SqrFt, Bdrms, Baths,
CondoFee, OwnerNum, LastName, FirstName)
4. Solmaris is considering adding tenant information to the database. A tenant is the person occupying a condo; this person may or may not be the condo€™s owner. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form:
CondoUnit (CondoID, LocationNum, UnitNum, SqrFt, Bdrms, Baths, CondoFee, OwnerNum, OwLastName, OwFirstName, TenantNum, TnLastName, TnFirstName)
5. What type of relationship exists between tenants and condos? Why? What type of relationship exists between tenants and owners? Why?

Figure 1-21

Transcribed Image Text:

Address 100 Ocean Ave. 2 Solmaris Bayside 405 Bayside Blvd. Glander Bay State PostalCode LocationNum LocationName 1 Solmaris Ocean City Bowton FL 31313 31044 FL