Randall_Hall_week_4_homework

Randall_Hall_week_4_homework - 4. SELECT STUDENT_ID FROM...

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

View Full Document Right Arrow Icon
Week 4 Homework Problems Randall Hall Chapter 7, page 290, Problems and Exercises 4a, 4b, 4c 4a. ALTER TABLE STUDENT ADD (CLASS VARCHAR);  4b. DROP TABLE IS_REGISTERED;  4c. ALTER TABLE FACULTY ALTER (FACULTY_NAME VARCHAR(40));  Chapter 8, page 318-319, Problems and Exercises 3, 4, and 5 3. SELECT FACULTY_ID FROM IS_QUALIFIED WHERE COURSE_ID = ISM 3113 AND COURSE_ID != ISM 4930;
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4. SELECT STUDENT_ID FROM IS_REGISTERED WHERE SECTION_ID = 2714 AND SEMESTER = I-2001; SELECT IS_REGISTERED.SECTION_ID, SECTION.SECTION_ID, STUDENT_ID, COURSE_ID WHERE IS_REGISTERED.SEMESTER = I-2001 AND SECTION.COURSE_ID = ISM 3113; 5. SELECT STUDENT.STUDENT_ID, IS_REGISTERED.STUDENT_ID WHERE IS_REGISTERED.SEMESTER != I-2001;...
View Full Document

This note was uploaded on 07/10/2011 for the course CS 360 taught by Professor Hammond during the Spring '09 term at Park.

Ask a homework question - tutors are online