Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

( 0 . 5 p ) Insert < 'Robert', ' F ' , 'Scott', ' 9 4 3 7 7 5 5 4 3

"(0.5p) Insert <'Robert', 'F', 'Scott', '943775543','1972-06-21','2365 Newcastle Rd, Bellaire, TX','M',58000,'888665555',1> into EMPLOYEE
(0.5p) Insert <'ProductA', 4, 'Bellaire', 2> into PROJECT
(0.5p) Insert <'Production', 4,'943775543','2007-10-01'> into DEPARTMENT
(0.5p) Insert <'677678989', NULL, '40.0'> into WORKS_ON
(0.5p) Insert <'453453453', 'John', 'M','1990-12-12', 'Spouse'> into DEPENDENT
(2p) Delete the WORKS_ON tuples with Essn ='333445555'
(2p) Delete the EMPLOYEE tuple with Ssn ='987654321'
(2p) Delete the PROJECT tuple with Pname = 'ProductX'
(1p) Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber =5 to '123456789' and '2007-10-01', respectively
(0.5p) Modify the Super_ssn attribute of the EMPLOYEE tuple with Ssn ='999887777' to '943775543'"

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

More Books

Students also viewed these Databases questions

Question

Why do you think this problem has occurred?

Answered: 1 week ago

Question

=+ Do you think it is a wise investment of the firm?

Answered: 1 week ago