You are using and illustrating Generalization and or Specialization in this exercise.make Super Entity named Employee.  The class has these attributes.

 

It has the following attributes

 

    Employee number

    First name

    Last name

    Address

    Email

 

  The employee number, first name, and last name attributes are text data types

 

There are two sub entities that inherit from the super entity Employee.  

1. hourlyEmployee entity
2. salariedEmployee entity

 

The hourlyEmployee entity has two attributes

1. pay rate
2. hours worked

The salariedEmployee entity has three attributes

1. annual salary
2. pay frequency
3. salary

 

construct a design that will make it possible to keep track of the the following

salary history of an employee

address history of an employee

collection of email addresses for an employee

 

Show both a Disjointed Model and an Overlapping Model

 

use Microsoft Visio, Microsoft Word