how can I Create an Enhance ER Diagram (EERD) using microsoft word for the following diagram. You are using and illustrating Generalization and or Specialization in this exercise. Create a 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. hourlyEmployee entity salariedEmployee entity The hourlyEmployee entity has two attributes pay rate hours worked The salariedEmployee entity has three attributes annual salary pay frequency 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
how can I Create an Enhance ER Diagram (EERD) using microsoft word for the following diagram. You are using and illustrating Generalization and or Specialization in this exercise.
Create a Super Entity named Employee. The class has these attributes.
It has the following attributes
Employee number
First name
Last name
Address
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.
- hourlyEmployee entity
- salariedEmployee entity
The hourlyEmployee entity has two attributes
- pay rate
- hours worked
The salariedEmployee entity has three attributes
- annual salary
- pay frequency
- 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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images