Convert the unnormalized relation shown in Figure 2-2 to a relation that meets the six criteria defined on page 31. Identify the primary key for the table.

Using the Solmaris Condominium Group Case data shown on in Figures 1-21 through 1-25, complete the following:

Write an English statement to describe the following SQL Statement: SELECT OwnerNum, LastName, FirstName FROM Owner;

Write an English statement to describe the following SQL Statement: SELECT Owner.LastName, Owner.FirstName, CondoUnit.UnitNum, CondoUnit.CondoFee FROM Owner INNER JOIN CondoUnit ON Owner.OwnerNum = CondoUnit.OwnerNum WHERE CondoUnit.CondoFee >300;

Using the TAL Distributers database in Figure 2-1 to complete the following:

List the order number, order date, customer number and customer name for each order placed by any customer represented by the rep whose last name is not Campos.

List the number and date of all orders that were placed on 10/15/2015 by customer whose rep number is 60.

List the number and date of all orders that were placed on 10/15/2015 but not by a customer whose rep number is 60.

List the order number, order date, customer number and customer name for each order.

ServiceRequest Service Condo Category Description Status Est Spent Next ID ID Num Hours Hours ServiceDate 1 Back wall in pantry has mold indicating water seepage. Diagnose and repair Service rep has verified the problem. Plumbing contractor has been called. 2 10/12/2015 2 Air conditioning Service rep has verified problem. Air conditioning contractor has been called 1 10/12/2015 doesn't cool. Service call has been scheduled. 6 Hardwood floors 0 10/16/2015 must be refinished 4 4 Switches in kitchen andOpen adjoining dining room are reversed. 0 10/13/2015 5 Molding in pantry mustCannot schedule until be replaced 0 water leak is corrected. 6 3 Unit needs to be repainted due to previous tenant damage Scheduled 0 10/19/2015 4 Tenant complained thatService rep unable to using microwave caused short circuits on twO occasions duplicate problem Tenant to notify condo management if problem recurs 3 Kitchen must be repainted. Scheduled Walls discolored due to kitchen fire 0 10/16/2015 6 Shampoo all carpets Open 0 10/19/2015 10 5 Repair window sills Scheduled 4 0 10/20/2015