3' CREATE STUDENT SECTION AS

1
CHAPTER 9 3,5,6,7,8,9,10,19
3. CREATE STUDENT SECTION AS SELECT
STUDENT ID, STUDENT NAME, COURSE ID,
SECTION ID, SEMESTER FROM STUDENT ID,
STUDENT NAME, COURSE ID, SECTION ID,
SEMESTER
5. a. SELECT COURSE ID, COURSE NAME
FROM COURSE ID ISM AND COURSE NAME
2
B. SELECT COURSE NAME FROM FACULTY NAME
PROFESSOR BERNDT C. SELECT CLASS ROSTER
FROM STUDENT NAME WHERE SECTION ID
2714 AND ISM 4212 6. SELECT STUDENT
RECORD FROM STUDENT ID, STUDENT NAME,
COURSE ID, SECTION ID, SEMESTER You
would use retrieval when you are not certain
about what data it contains. The view
definition is used when you are certain. 7.
SELECT FACULTY NAME FROM FACULTY NAME
WHERE ISM 3113 Y
3
8. SELECT FACULTY NAME FROM FACULTY
NAME WHERE ISM 3113 Y
AND ISM 4930 N 9. CREATE STUDENT TOTAL
AS SELECT STUDENT NAME, SUM (STUDENT
NAME) TOTAL FROM ISM 2714
Y CREATE STUDENT TOTAL AS SELECT
STUDENT NAME, SUM (STUDENT NAME)
TOTAL FROM ISM 3113 Y 10. CREATE
STUDENT TOTAL AS SELECT STUDENT NAME
FROM COURSE ID N