Purchase Solution

Entity relationship diagram

Not what you're looking for?

Ask Custom Question

1. Draw the entity relationship diagram for the relationship between EMPLOYEE and JOB.

Employee

EMP_CODE | EMP_LNAME | JOB_CODE

14 Rudell 2
15 McDade 1
16 Ruellardo 1
17 Smith 3
20 Smith 2

Benefit

EMP_CODE | PLAN_CODE
15 2
15 3
16 1
17 1
17 3
17 4
20 3

Job

JOB_CODE | JOB_DESCRIPTION
1 Clerical
2 Technical
3 Managerial

Benefit

Plan

PLAN_CODE | PLAN_DESCRIPTION
1 Term Life
2 Stock Purchase
3 Long-life disability
4 Dental

Attachments
Purchase this Solution

Solution Summary

This solution provides an entity relationship diagram for various datasets

Purchase this Solution


Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Javscript Basics

Quiz on basics of javascript programming language.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C++ Operators

This quiz tests a student's knowledge about C++ operators.