Database help: Create an ERD, Relational Diagram, and do the tables exhibit entity integrity or referential integrity.
Not what you're looking for?
1.) Create the ERD to show the relationship between EMPLOYEE and JOB.
2.) Create the relational diagram to show the relationship between EMPLOYEE and JOB.
3.) Do the tables exhibit entity integrity? Yes or no and explain.
4.) Do the tables exhibit referential integrity? Yes or no, then explain. Write not applicable if the table does not have a foreign key.
5.) Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB AND PLAN.
6.) Create the relational diagram to show the relationships among EMPLOYEE, BENEFIT, JOB AND PLAN.
Please see attachment for full question details.
Purchase this Solution
Solution Summary
The expert creates an ERD, relational diagrams and determines whether tables exhibit entity integrity or referential integrity.
Solution Preview
Table name: EMPLOYEE Table name: BENEFIT
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
PLAN
PLAN_CODE PLAN_DESCRIPTION
1 Term life
2 Stock purchase
3 Long-term disability
4 Dental
Table name: JOB
Table name: ...
Purchase this Solution
Free BrainMass Quizzes
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
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.
Javscript Basics
Quiz on basics of javascript programming language.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Basic Networking Questions
This quiz consists of some basic networking questions.