Questions #1 Given the following business scenarios, use MS Visio or any other Database Design CASE Tool to create an ERD using a specialization hierarchy if appropriate.

1. An organization has three types of employees: Hourly, Salaried, and Contract. Following are attributes of each employee type:

a. HOURLY: Emp_ID, LName, FName, Address, Date Hired, Hourly_Rate

b. SALARIED: Emp_ID, LName, FName, Address, Date Hired, Annual_Salary, Stock_Option

c. CONSULTANT: Emp_ID, LName, FName, Address, Date Hired, Contract_Number, Billing_Rate.

Questions #2 Assume each employee must be a member of exactly one of these sub-types. Using generalization, develop an EER model segment to represent this situation. Remember to include the subtype discriminator.