Give two examples of aggregation over-specification and two for aggregation
under-specification.
Use parameterized participation constraints to create the aggregation hierarchy
of a high rise building. The building has a certain number of floors, each having
two types of apartments, standard and luxury. In each floor from floor 4 and
above there are three standard and two luxury apartments. In the first three
floors, there is one small and two large offices. Decide how many floors there
are and how many faucets are required for each unit, and create the appropriate
OPD with participation constraints. Using your diagram, compute the number
of faucets the contractor needs to order.