For each of these scenarios, draw an ER model using any standard notation, clearly denoting maximum and minimum cardinality constraints. Write the one liner and four sentences for each diagram (statements that specify degree and mandatoriness of each entity, if applicable). Number of tables needed and the columns in the tables especially Primary and Foreign Key postings must be complete.

__________________________________________

All employees have an id, name, department and datejoined. In addition, salespersons have commission and salary, consultants have hourly rates and a vendor firm, and regular employees have simply yearly salary. An employee must belong to only of the subgroups and all employees belong to one of these three categories.