Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the figure below showing the tables in a database to answer the questions below Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB CODE Table name: BENEFIT

image text in transcribed

image text in transcribed

Use the figure below showing the tables in a database to answer the questions below Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB CODE Table name: BENEFIT EMP CODE PLAN CODE 14 Rucdell 15 McDade 16 Ruellardo 17 Smith 20 Smith 17 17 17 20 Table name: JOB Table name: PLAN JOB CODE JOB DESCRIPTION PLAN.CODE PLAN. DESCRIPTION 1Clerical 2 Technical 3 Managerial 1 Term life 2 Stock purchase 3 Long-term disabilit 4 Dental 2. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. TABLE EMPLOYEE ENTITY INTEGRITY EXPLANATION BENEFIT JOB PLAN 3. Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. TABLE EMPLOYEE REFERENTIAL INTEGRITY EXPLANATION BENEFIT JOB PLAN 4. Create a basic Crow's Foot ERD to show the relationships among the EMPLOYEE, BENEFIT, JOB and PLAN tables

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analytics Systems Engineering Cybersecurity Project Management

Authors: Christopher Greco

1st Edition

168392648X, 978-1683926481

More Books

Students also viewed these Databases questions

Question

Resolving conflicts starts with identifying problem ownership.

Answered: 1 week ago

Question

Discuss the Rights issue procedure in detail.

Answered: 1 week ago

Question

Discuss the Rights issue procedure in detail.

Answered: 1 week ago

Question

Explain the procedure for valuation of shares.

Answered: 1 week ago

Question

Which months of this year 5 Mondays ?

Answered: 1 week ago

Question

Define Leap year?

Answered: 1 week ago