Week 7 Textbook assignment

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

Info icon This 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’);
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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern