Consider the following schema (PK Bold, FK in italics). Use MySQL Workbench to create the EER diagram that corresponds to the schema given below

EMPLOYEE(EmpID, EmpName, DeptNum, JobTitle, EmpSalary)

TRIP( TripID, DepartureCity, DestinationCity, DepartureDate, ReturnDate, EmpID)

EXPENSE( TripID, Item, Date, Amount)

Business rules:

all employees can have a pension plan

sales employees have clients

management employees have projects

Duplicate the EER diagram you created for item 2, rename it, and modify it as follows:

Modify the EMPLOYEE entity to reflect that employees are either clerical, sales or management. Make up attributes as needed and state any assumptions you need to make.

Modify the TRIP entity to reflect different kinds of trips: sales presentations, attend conferences, training

Business rules:

sales employees have sales presentations

sales and management employees attend conferences

all employees get training

Complete the following tasks:

State two conditions that indicate when a database designer should consider using supertype/subtype relationships.

Given an example of such a relationship (other than those discussed in the module) chosen from an application in your major (state your major).

What is the purpose of a subtype discriminator? Clearly identify the values (or some of the values if there are many) in your example.

Create the EER diagram for your example.