.Il T-Mobile 11:12 PM 734%O, instructure-uploads,s3.amazonaws.com opics: Tabies
ID: 3724291 • Letter: #
Question
.Il T-Mobile 11:12 PM 734%O, instructure-uploads,s3.amazonaws.com opics: Tabies & Constraints, Data Manipuiation Commands Follow the same instructions as previous homework assignments art A Review Questions in the lecture textbook-Page 306 #3, #5 art B Assume you successfully executed the following SQL command CREATE TABLE employee ( CHAR(3) PRIMARY KEY, emp num emp Inam emp fname emp initial emp_hiredate job code FOREIGN KEY (job code) REFERENCES job ); VARCHAR(15)NOT NULL VARCHAR(15)NOT NULL, CHAR(1), DATE CHAR(3), Assume you populated the "EMPLOYEE" table with these values EMP EMP EMP EMP INTIAL EMP ATE JOE 08-Nov-00 502 12-Jul-89 501 01-Dec-96 500 15 Nov-87 501 01-Feb-93 502 22-Jun-04 500 10-Oct-93 500 22-Aug-91 501 18-Jul-97 501 103 104 105 Arbough June Ramoras Smthfield Wiliam Washington Rolph 109 CREATE TABLE jo job code job _type job_charge CONSTRAINT job cons pk PRIMARY KEY (job code) ); CHAR(3), VARCHAR(15), NUMBER (6,2), Assume you populated the "JOB" table with these values JOB CODE JOB TYPE 499 500 501 502 503 JOB CHARGE 25.25 Documentation 45.00 57.85 Consulting30.75 Programming 75.50 Training Questions to Answer are on the Next Page à Part B (Continued) Answer these questions:Explanation / Answer
Note: to undo the changes you made in Question #2 & #3 the questions are not provided here.so, sorry for that.
Solution #5
DELETE FROM
employee
WHERE
emp_fname = 'William'
AND emp_lname = 'Smithfield'
AND emp_hiredate = '22-Jun-04'
AND job_code = 500;
Solution #6
INSERT INTO
JOB
VALUES('499', '', 25.25);
Solution #7
Natual join of the two tables will look like:-
emp_lname job_type Arbough Documentation Smithfield Documentation Alonzo Documentation Senior Training Ramoras Training Washington Training Smith Training News Consulting Johnson ConsultingRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.