Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started