Suppose we choose Part B-9 as our best design. PROPERTY(PropertyID, PropertyName, PropertyType, Street, City, ZIP) SERVICE(ServicelD, ServiceDate, Description, Amount, PropertyID) And suppose Garden Glory decides to add the following table as in Part C (Instead of SERVICE_FEE lets call it RENDERED_SERVICE). The RENDERED_SERVICE relation will store records of services that have been completed for properties. RENDERED_SERVICE (PropertyID, ServicelD, Description, Amount) Choose the modifications that will have to be made to the relations to reduce data redundancy and to work for the data given in Figure 2-34 below. Select All that apply. Select one or more: a. Remove ServiceDate and PropertyID from the SERVICE relation b. Exclude Description from the RENDERED_SERVICE relation. c. Include ServiceDate in the RENDERED_SERVICE relation d. Designate the composite key PropertyID, ServicelD, and ServiceDate as the primary key for the RENDERED_SERVICE relation