TEC 5323 Advanced Database Technology

Discussion of Week 2

 

This is the second 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:

During last week, you have installed Oracle database server on your onw computer.

This week, we start working at Structured Query Langauage (SQL). This is the major part of any database technology.

1. Please explain why we need SQL. In other words, what can we use SQL for?

2. For the project of this week, you are required to submit a SQL script.   What is SQL script?

3. How do you write (and save) your SQL script?

4. How do you test your SQL script to make sure it is working?

5. Please discuss and answer the following specific question:

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.

 

 

Discussion Board (D2L) Procedure:

  1. Login D2L from EIU's homepage.

  2. Click on TEC5323 600 Advanced Database Technology. 

  3. Click on "Communication" and then "Discussions."

  4. Click "Week 2: Discussion" for the second week's discussion.

    Week2

  5. Double click "Questions for Week 2." Do not use "Start a New Thread" since students are required to respond to the instructor's questions.

    Week 2

  6. Click "Reply to Thread" button.

    week 2

  7. Compose your message.

  8. After your check your reply, click "Post" button.

 

 

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