Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Instance of the Company Database Worker EMPID LASTNAME FIRSTNAME | SALARY 101 Smith Tom 50000 103 Jones Mary 48000 105 Burns Jane 39000 110 Burns

image text in transcribed

image text in transcribed

Instance of the Company Database Worker EMPID LASTNAME FIRSTNAME | SALARY 101 Smith Tom 50000 103 Jones Mary 48000 105 Burns Jane 39000 110 Burns Michael 70000 115 Chin Amanda 60000 Assign Project PROJNO PROJNO EMPID | HOURSASSIGNED PROJNAME PROJMGRID | BUDGET 1001 101 30 1001 Jupiter 101 300000 1001 103 20 1005 Saturn 101 400000 350000 1001 105 30 1019 Mercury 110 1001 115 20 1025 Neptune 110 600000 1005 103 20 1030 Pluto 110 380000 1019 110 20 1019 115 10 Company Database Schema CREATE TABLE Worker ( empId NUMBER(6) PRIMARY KEY, lastName VARCHAR2(20) NOT NULL, firstName VARCHAR2(15) NOT NULL, salary NUMBER(8,2) ); CREATE TABLE Project ( projNo NUMBER(6) PRIMARY KEY, projName VARCHAR2(20), projMgrld NUMBER(6), budget NUMBER (8,2), CONSTRAINT Project projMgrid_ FOREIGN REFERENCES Worker (empId) ); (projMgrld) CREATE TABLE Assign projNo NUMBER(6), empId NUMBER(6), hoursAssigned NUMBER(3), CONSTRAINT A_pk PRIMARY KEY (projNo, empld), CONSTRAINT Assign_projNo_fk FOREIGN KEY (projNo) REFERENCES Project (projNo), CONSTRAINT Assign_empId_fk FOREIGN KEY (empId) REFERENCES Worker (empId) ); If we attempt to delete (1001, 115, 20) from the Assign relation, will that action be accepted? Explain

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

Step: 3

blur-text-image

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

Concepts Of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

4th Edition

0619064625, 978-0619064624

More Books

Students also viewed these Databases questions

Question

Developing and delivering learning that is integrated with the job.

Answered: 1 week ago

Question

Use of assessments to determine trainees learning styles.

Answered: 1 week ago

Question

7. Discuss the advantages of embedded learning.

Answered: 1 week ago