Week 7 Textbook assignment

Week 7 Textbook assignment - INSERT INTO EMP_1 VALUES(102...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Text activities week 7 Chapter 7 (pages 224-246): Review Questions: 1, 2, 4, 6, 7 1. CREATE TABLE EMP_1( EMP_NUM CHAR(3) NOT NULL UNIQUE, EMP_LNAME VARCHAR(15) NOT NULL, EMP_FNAME VARCHAR(15) NOT NULL, EMP_INITIAL CHAR(1), EMP_HIREDATE DATE NOT NULL, JOB_CODE CHAR(3) NOT NULL, PRIMARY KEY (EMP_NUM), FOREIGN KEY (JOB_CODE) REFERENCES JOB ON UPDATE CASCADE); 2. INSERT INTO EMP_1 VALUES (101, ‘News’, ‘John’, ‘G’, ‘08-Nov-00’, ‘502’);
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: INSERT INTO EMP_1 VALUES (102, ‘Senior’, ‘David’, ‘H’, ’12-Jul-89’, ‘501’); 3. SELECT * FROM EMP_1 WHERE JOB_CODE = 502; 4. COMMIT; or COMMIT EMP_1; 6. DELETE FROM EMP_1 WHERE EMP_NUM = 106; 7. ROLLBACK; Problem: 1 SELECT CHAR_TRIP, CHAR_DATE, AC_NUMBER, CHAR_DESTINATION FROM CHARTER;...
View Full Document

This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Penn State.

Ask a homework question - tutors are online