The instance diagram shown below illustrates the relationship between Sullivan Insurance Agency’s agents and clients. Using this instance diagram, write the narrative that describes the relationship between agents and clients. Your narrative should include a description of both the cardinality ratio and participation constraints implied in the instance diagram. In addition, draw the ER diagram that fully describes the relationship between the company’s agents and clients?
Sullivan Insurance Company agents sell insurance policies to clients. More experienced agents often sell separate policies to many different clients, while newer agents may sell none. Likewise, not all clients have purchased a policy from an agent, whereas some clients have purchased a policy from more than one agent.