Assuming that we use the PropertyID field to uniquely identify a property and the following functional dependencies exist: PropertyID → (PropertyName, PropertyType, Street, City, ZIP) (PropertyID, Description, ServiceDate) → Amount What is wrong with the relation design in Part B-7? Choose all that apply. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, ZIP, ServiceDate) SERVICE (ServiceID, ServiceDate, Description, Amount) Question 4 Select one or more: a. In this design, a property cannot have more than one ServiceDate. b. There is no need for two relations. c. ServiceDate should be designated as the primary key in the SERVICE relation. d. ServiceDate is designated as a foreign key in PROPERTY, but is not a primary key in SERVICE.
