ISM641week2-interactiveassignmentupdated2.pdf

ENTITY RELATIONSHIPS 2

Entity Relationship Diagram for CosntructCo Database Project

Entity Relationship Diagram

EMPLOYEE

EMP_NUM

EMP_FNAME

EMP_INITIAL

EMP_HIREDATE

JOB_CODE

PROJECT

PROJ_NUM

PROJ_NAME

PROJ_VALUE

PROJ_BALANCE

EMP_NUM

ASSIGNMENT

ASIGN_NUM

ASSIGN_DATE

ASSIGN_HOURS

ASSIGN_CHG_HOUR

ASSIGN_CHARGE

EMP_NUM

JOB

JOB_CODE

JOB_DESCRIPTI ON

JOB_CHG

JOB_HOUR