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.
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 mandatory aspects of each entity, if applicable).
List the number of tables needed and the columns in the tables including the Primary and Foreign Key postings.
List the SQL/Oracle statements to create the tables.