5:45 PM a instructure-uploads.s3.amazonaws.com .Il T-Mobile 58%. rartD Assume yo

Question

5:45 PM a instructure-uploads.s3.amazonaws.com .Il T-Mobile 58%. rartD Assume you successfully executed the following SQL command CREATE TABLE employee ( CHAR(3) PRIMARY KEY, emp nuim emp lname 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 FNAME EMP INTIAL EMP HREDATE JOB CODE John EMP NUM EMP 08-Now-00 502 12-44-89 501 01-Dec-96 500 15-Noy-87 501 01 -Fob-93 502 22-in-04 500 10-oc-93 500 22-4ug-91 50 18-44-97 501 102 103 104 Arbough June 106 107 Alonzo Washington Ralph Snth Maria 109 CREATE TABLE 0 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 Consulting 30.75 Programming 75.50 Training Questions to Answer are on the Next Page à ar ontinued) Answer these questions #1 would you use to save the If you executed several "INSERT" commands, what command changes that you made? Write the SQL code that will list all attributes for a job code of #2. 502 #3. Write the SQL code to change the job code to 501 for the person whose employee number "EMP NUM" is 107

Explanation / Answer

1.) In order to save the changes, we need to perform commit command.

2.) SELECT * FROM JOB
WHERE JOB_CODE = 502;

3.) Update EMPLOYEE

SET JOB_CODE = 501

Where EMP_NUM = 107

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.