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

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

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.  

  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

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY