Direction:

- Use either Chens or Crow Foot notation (do not mix). - Identify primary keys for all the entities in your diagram (If a specific requirement is not given, make your own assumptions for identifying primary keys. State your assumptions in an appendix.). - Identify cardinalities (both the minimum and the maximum) for all the relationships in your diagram (If a specific requirement is not given, make your own assumptions for identifying cardinalities. State your assumptions in an appendix.).

First of all, EMart wants to keep good track of their employees. When an employee gets hired from the company, s/he is given with an employee number which will be used for an identification purpose. In addition, email, phone number, address, emergency contact, gender, and date of birth will be recorded for each employee. Note that company wants their employees to provide as many emergency contacts as possible. Employees work for different parts of the company. For instance, there are salespersons who manage important customers such business customers. To facilitate large-quantity sales, EMart provides salespersons with special funds for lobbying. The company will track the total amount of funds provided as well as the amount of funds used for each salesperson. In addition, the amount of funds left for use will be calculated and stored. On the other hand, marketers deal with potential customers. Their job is to contact local businesses that have not yet built any relationships with the company and to transform into future customers. To provide performance-based bonuses to these employees, Emart tracks the total number of new customers each marketer has attracted. Note that there are still many employees who cannot be categorized into the above two subgroups. Also, a salesperson cannot be a marketer at the same time.