SUBJECT: DATABASE MANAGEMENT SYSTEMNOTE: All these tasks must be done in Oracle Database 10g Enterprise EditionDisplay the Employee name and designation in one column.Display all records from table whose name is Smith using all uppercases in where clause.Display all records from table whose name is Smith using first letter captializaed in where clause.Display all records from table whose name is Smith using all lowercases in where clause.Display all records from table whose name is Smith using lower and upper cases both. i.e. SMITH, smith both should be acceptable.Show the result of those employees whose name length exceeds 8.Display ename, salary and concatenated result of deptno and empno from table EMP where salary is less than 2500 or job is equal to MANAGER.Display first 3 characters of ename, deptno and job from table EMP where second character of ename is ‘A’ and deptno is 30 or job is SALESMAN.Right Append dollar sign in Employee table to make salary 8 digit value.Calculate annual salary and rename it as PER_ANNUM_SALARY of the employee whose ename is KING and salary is greater than 1500 from table EMP.Round 345.6665 upto 2 digits from table DUAL.Members of the HR department want to have more flexibility with the queries that you are writing. They would like a report that displays the last name and salary of employees who earn more than an amount that the user specifies after a promptThe HR department wants to run reports based on a manager. Create a query that prompts the user for a manager ID and generates the employee ID, last name, salary, and department for that manager’s employees. The HR department wants the ability to sort the report on a selected column. You can test the data with the following values:manager ID = 103, sorted by employee last name:manager ID = 201, sorted by salary:Write a query that displays the last name (with the first letter uppercase and all other letters lowercase) and the length of the last name for all employees whose name starts with the letters J, A, or M. Give each column an appropriate label. Sort the results by the employees’ last names.Write a query to display the current date. Label the column DateThe HR department needs a report to display the employee number, last name, salary, and salary increased by 15.5% (expressed as a whole number) for each employee. Label the column New Salary.The HR department wants to find the length of employment for each employee. For each employee, display the last name and calculate the number of months between today and the date on which the employee was hired. Label the column MONTHS_WORKED. Order your results by the number of months employed. Round the number of months up to the closest whole number.Write a query that produces the following for each employee:<employee last name> earns <salary> monthly but wants <3 times salary>. Label the column Dream Salary

As per our guidelines we are supposed to answer only 1st three parts. Kindly repost the remaining…

Answered: Display the Employee name and…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

SUBJECT: DATABASE MANAGEMENT SYSTEM

NOTE: All these tasks must be done in Oracle Database 10g Enterprise Edition

Display the Employee name and designation in one column.
Display all records from table whose name is Smith using all uppercases in where clause.
Display all records from table whose name is Smith using first letter captializaed in where clause.
Display all records from table whose name is Smith using all lowercases in where clause.
Display all records from table whose name is Smith using lower and upper cases both. i.e. SMITH, smith both should be acceptable.
Show the result of those employees whose name length exceeds 8.
Display ename, salary and concatenated result of deptno and empno from table EMP where salary is less than 2500 or job is equal to MANAGER.
Display first 3 characters of ename, deptno and job from table EMP where second character of ename is ‘A’ and deptno is 30 or job is SALESMAN.
Right Append dollar sign in Employee table to make salary 8 digit value.
Calculate annual salary and rename it as PER_ANNUM_SALARY of the employee whose ename is KING and salary is greater than 1500 from table EMP.
Round 345.6665 upto 2 digits from table DUAL.
Members of the HR department want to have more flexibility with the queries that you are writing. They would like a report that displays the last name and salary of employees who earn more than an amount that the user specifies after a prompt
The HR department wants to run reports based on a manager. Create a query that prompts the user for a manager ID and generates the employee ID, last name, salary, and department for that manager’s employees. The HR department wants the ability to sort the report on a selected column. You can test the data with the following values:
manager ID = 103, sorted by employee last name:
manager ID = 201, sorted by salary:
Write a query that displays the last name (with the first letter uppercase and all other letters lowercase) and the length of the last name for all employees whose name starts with the letters J, A, or M. Give each column an appropriate label. Sort the results by the employees’ last names.
Write a query to display the current date. Label the column Date
The HR department needs a report to display the employee number, last name, salary, and salary increased by 15.5% (expressed as a whole number) for each employee. Label the column New Salary.
The HR department wants to find the length of employment for each employee. For each employee, display the last name and calculate the number of months between today and the date on which the employee was hired. Label the column MONTHS_WORKED. Order your results by the number of months employed. Round the number of months up to the closest whole number.
Write a query that produces the following for each employee:
<employee last name> earns <salary> monthly but wants <3 times salary>. Label the column Dream Salary

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Display the Employee name and designation in one column. Display all records from table whose name is Smith using all uppercases in where clause. Display all records from table whose name is Smith using first letter captializaed in where clause.