After some thought, the business owners decided to go with surrogate keys for a property and a service, to provide a more simpler and convenient unique identifier, and because a service could be repeated on the same day, determinants that use ServiceDate and Description may not be suitable. your normalization to BCNF using the functional dependencies that we define in class to use and showing your work. Specify which of the designs in (B) looks closest to the result of your normalization.Given PROPERTY(PropertyId, ServiceId, PropertyName, PropertyType, Street, City, ZIPServiceDate, Description, Amount)

PropertyId -> (PropertyName, PropertyType, Street, City, ZIP)

ServiceId-> (ServiceDate, Description, Amount);