Solution-Do the tables exhibit referential integrity

Do the tables exhibit referential integrity

Assignment Help Database Management System

Reference no: EM13949229

Table name: EMPLOYEE

EMPLOYEE
EMP_CODE	EMP_LNAME	JOB_CODE
14	Rudell	2
15	McDade	1
16	Ruellardo	1
17	Smith	3
20	Smith	2

Table name: JOB

JOB
JOB_CODE	JOB_DESCRIPTION
1	Clerical
2	Technical
3	Managerial

Table name: BENEFIT

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

Table name:PLAN

PLAN
PLAN_CODE	PLAN_DESCRIPTION
1	Term life
2	Stock purchase
3	Long-term disability
4	Dental

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.

Reference no: EM13949229

Questions Cloud

What aspects of compensation are most important to you : Discuss the pay and compensation you receive at your most recent place of employment and what aspects of compensation are most important to you?

Define the differences between data mart and data warehouse : Define and describe the differences between OLTP and OLAP databases.

How many kilograms of u235 would be used in 1000 hours : A reactor is developing energy at the rate of 3000kW. How many atoms of U235 undergo fission per second? How many kilograms of U235would be used in 1000 hours of operation assuming that on an average energy of 200MeV is released per fission?

Indentify the variable overhead costs : Select cost allocation bases to use in allocating variable overhead costs to input - Indentify the variable overhead costs associated with each cost-allocation base

Do the tables exhibit referential integrity : Do the tables exhibit referential integrity? Yes or no, then explain. Write not applicable if the table does not have a foreign key.

Calculate the current produced assuming all the energy is : α particles of energy 5MeV pass through an ionization chamber at the rate of 10 per second. Assuming all the energy is used in producing ion pairs, calculate the current produced.(35 eV is required for producing an ion pair)

Amount of gross profit : Ajax Company appropriately accounts for certain sales using the installment sales method. The perpetual inventory system is used.Calculate the amount of gross profit that would be recognized each year on installment sales.

How is it the same or how is it different : Is this deal in keeping with Buffett's style of investing? How is it the same or how is it different? Is Buffett paying too little or too much for Heinz? Any other comments?

Two barriers that influence your critical thinking : Write at least 100 words for each barrier, describing them and how you can overcome them. Total word count will be at least 200 words.Format your assignment consistent with APA guidelines.

User Account

All Pages

Do the tables exhibit referential integrity

Reference no: EM13949229

Reference no: EM13949229

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT