Each service provider offers at least one service. A service cannot be offered twice by the same provider. Each service is identified by its name and has a description. By anti-trust laws, the same service in the same city must be offered by at least two providers. Institutions are located in a city and are identified by name.
Institutions can only use a service from a provider in the same city.
A service is provided to an institution for a certain month for a certain price. For simplicity, we assume that months are consecutive numbers. Draw the ER diagram corresponding to this design. For each of the following integrity constraints, say whether or not they are captured in the primary key and foreign key constraints. A service cannot be offered twice by the same provider.