Randall_Hall_week_4_homework

Randall_Hall_week_4_homework - the attribute; ADD (CLASS...

Info iconThis preview shows pages 1–2. 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;   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 pts: Syntax error—missing the required data type for
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the attribute; ADD (CLASS VARCHAR2(15))-5 pts: Syntax errorwrong attribute modification clause; it is MODIFY not ALTER-5 pts: all string values must be enclosed in single quotes-5 pts: all string values must be enclosed in single quotes-5 pts: supposed to return a count of how many, not the value of attributes-5 pts: all string values must be enclosed in single quotes-5 pts: supposed to return a count of how many, not the value of attributes 5. SELECT STUDENT.STUDENT_ID, IS_REGISTERED.STUDENT_ID WHERE IS_REGISTERED.SEMESTER != I-2001;-20 pts: Not even close....
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.

Page1 / 2

Randall_Hall_week_4_homework - the attribute; ADD (CLASS...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online