Reference no: EM132266762
Develop a Domain Class diagram, given the scenario below:
Sarah, the owner of Sarah’s Events, wants a database to keep track of information related to the events that she sets up. She wants to keep a list of all the clients who do business with her. She wants to track the name, address, and phone number of each client. For each event, she needs to know the cost and date for the event. Sarah has a list of potential locations for events that she can recommend to her clients. She would like the database to store the name, address, phone number, cost, and name of the manager at each location that she uses. When an event is set up, she would like to know which location was used for that event, because events occur at only one location. In addition to arranging the location for the event, Sarah sets up the entertainment for the client. She wants to maintain a list of performers that are used for the various events. For each performer, she needs a name, address, and phone number, as well as the normal fee they would charge for an event. Each event uses at least one but potentially several performers. Finally, Sarah has a group of employees who work at the events. She needs to know which employees have worked at which event, including the number of hours each employee puts in at each event. A given employee can work at several events, and each event typically needs more than one employee to staff it. Sarah wants to know each employee’s social insurance number, name, address, phone number and hourly pay rate.