TEC 5323 Advanced Database Technology

Discussion of Week 6

 

This is the 6th discussion of the semester. Please use the discussion guidelines in Course Policy to formulate your response! The grading scale in the policy will be used for the discussions starting this week.

Discussion Topic:

The TEACHER table contains these columns:

Name Null? Type
TEACHER_ID NOT NULL NUMBER(9)
NAME   VARCHAR2(25)
SALARY   NUMBER(7,2)
SUBJECT_ID NOT NULL NUMBER(3)
SUBJECT_DESCRIPTION   VARCHAR2(2)

You need to increase the salary of all SCIENCE teachers by 8%. The SUBJECT_ID for science teachers is 011. Which statement will you use?

    1. UPDATE teacher
      SET salary = salary * 1.08
      WHERE subject_description LIKE 'SCIENCE'

    2. UPDATE teacher
      SET salary = salary * .08
      WHERE subject_description LIKE 'SCIENCE'

    3. UPDATE teacher
      SET salary = salary * 1.08
      WHERE subject_id = 011;

    4. UPDATE teacher
      SET salary = salary * 1.08
      WHERE subject_description LIKE 'SCIENCE'

Please explain why. Note that there is only one correct answer.

 

When you are ready, please click Discussion Board to login.

Class Index

School of Technology
College of Business & Applied Sciences
Eastern Illinois University