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 PROJNO Project PROJNO EMPID | HOURSASSIGNED PROJNAME PROJMGRID | BUDGET 1001 101 30 1001 Jupiter 101 300000 1001 103 20 1005 Saturn 101 400000 1001 105 30 1019 Mercury 110 350000 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_fk FOREIGN KEY (projMgrld) REFERENCES Worker (empId) ); CREATE TABLE Assign ( projNo NUMBER(6), empId NUMBER(6), hours Assigned NUMBER(3), CONSTRAINT A_pk PRIMARY KEY (projNo, empId), CONSTRAINT Assign_projNo_fk FOREIGN KEY (projNo) REFERENCES Project (projNo), CONSTRAINT Assign_empId_fk FOREIGN KEY (empId) REFERENCES Worker (empId) ); If we attempt to insert a new worker (125, Null, 'Patricia', 'Pluto') into the Worker 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

Bioinformatics Databases And Systems

Authors: Stanley I. Letovsky

1st Edition

1475784058, 978-1475784053

More Books

Students also viewed these Databases questions

Question

List and describe the 5 V s of big data.

Answered: 1 week ago

Question

2. What should an employer do when facing an OSHA inspection?

Answered: 1 week ago