LAB EXERCISE 9 ICT502 PDF

Preview

Summary

BACHELOR OF COMPUTER SCIENCE (HONS)FACULTY OF COMPUTER AND MATHEMATICAL SCIENCESUiTM SHAH ALAMTITLE OF INDIVIDUAL LAB:LAB 2PREPARED BY:NUR HIDAYAH BINTI ISHAK2020496204 (CS2303C)COURSE:ICT 502 – DATABASE ENGINEERINGLECTURER:MADAM NOR DIANA BINTI AHMADSUBMISSION DATE:4 NOVEMBER 2021SEMESTER:OCTOBER 2...

Description

BACHELOR OF COMPUTER SCIENCE (HONS) FACULTY OF COMPUTER AND MATHEMATICAL SCIENCES UiTM SHAH ALAM

TITLE OF INDIVIDUAL LAB: LAB 2

PREPARED BY: NUR HIDAYAH BINTI ISHAK 2020496204 (CS2303C)

COURSE: ICT 502 – DATABASE ENGINEERING

LECTURER: MADAM NOR DIANA BINTI AHMAD

SUBMISSION DATE: 4 NOVEMBER 2021

SEMESTER: OCTOBER 2021 – FEBRUARI 2022

NUR HIDAYAH BINTI ISHAK 2020496204 CS2303C

Lab Exercise 2: Restricting and Sorting Data By using HR Schema in Oracle Express Edition, answer the following SQL questions. 1. Select the ID, last name, and email for all the employees that have ST_MAN and FI_ACCOUNT as their job.

SELECT EMPLOYEE_ID, LAST_NAME, EMAIL FROM EMPLOYEES WHERE JOB_ID IN ('ST_MAN' , 'FI_ACCOUNT');

1

NUR HIDAYAH BINTI ISHAK 2020496204 CS2303C

2. By modifying the SQL in question 1, add a new column name “Salary”. The display must only show the employees that have salary from 2000 to 6500. SELECT EMPLOYEE_ID, LAST_NAME, EMAIL, SALARY FROM EMPLOYEES WHERE JOB_ID IN ('ST_MAN' , 'FI_ACCOUNT') AND SALARY BETWEEN 2000 AND 6500;

2

NUR HIDAYAH BINTI ISHAK 2020496204 CS2303C

3. Find the employees from department 50 that have no commission. SELECT EMPLOYEE_ID, LAST_NAME, EMAIL, commission_pct FROM EMPLOYEES WHERE department_id = '50' AND commission_pct IS NULL ;

3

NUR HIDAYAH BINTI ISHAK 2020496204 CS2303C

4. Find the department that have no manager and the last letter of the department’s name must be ‘g’. SELECT last_name, department_id, manager_id FROM EMPLOYEES WHERE last_name LIKE '%g' AND manager_id IS NULL ;

4

NUR HIDAYAH BINTI ISHAK 2020496204 CS2303C

5. Find the employees that have a salary less than the prompted value. Sort the output by salary column number. SELECT first_name,last_name, salary FROM EMPLOYEES WHERE salary...