Skip not places please. Following script is given to you at Google Classroom. Run script to generate tables inOracle APEX.EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)DEPT (DEPTNO, DNAME, LOC)SALGRADE (GRADE, LOSAL, HISAL)After setting up all relations, you need to apply following queries to get data from givenrelations: (Write queries and also paste screenshots in answer file)i. Display the employee id, name, salary, commissioned salary (incremented salary +commission) with label "Commissioned_Salary".ii. Write a query that displays the sum of all salaries of each job!iii. Get the average of clerks salaries.iv. President takes maximum salary in our record. Find maximum salary of employees otherthan president.v Show employee name, job, salary and incremented salary (25% incremented salary) ofemployees.vi. Get all Clerk or Salesman salaries that are below 3000 in descending order with respectto sum of salaries.vii. Show accumulated high salary and low salary from SALGRADE table.viii. Display the highest, lowest, sum, average salary of all employees in a single query. Namethe column accordingly.ix. Write a query to display the difference between highest and lowest salary.x. Write a query that displays the sum of all salaries of each job.

The question is asking for a query that displays the sum of salaries for each job in the EMP table.…

Answered: kip not places please.

Engineering

Computer Science

kip not places please.

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

Q: rite the sequence of commands required to update the CHAR_WAIT_CHG attribute values in the CHARTER…

A: Required: Write the sequence of commands required to update the CHAR_WAIT_CHG attribute values in…

Q: How to create multiple primary keys? Create multiple primary keys for below table…

A: A primary key is a column or combination of columns in a table that uniquely identifies each row in…

Q: LIST THE FIRST AND LAST NAMES OF ALL OWNERS WHO OWN A TWO-BEDROOM PROPERTY. USE THE IN OPERATOR IN…

A: Considering there are 2 tables:- OWNER: which holds the OWNER_NUM, FIRST_NAME, and LAST_NAME…

Q: Alter the INVOICE_LINE table by adding the INVOICE_NUM column as a foreign key referencing the…

A: Alter table : used to modify column, add column/columns, add constraints, drop column, rename, drop…

Q: Create a procedure to add a row to the INVOICES table.

A: I give the code ,output is not shown because table is not given. refer it

Q: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and…

A: We need to insert some columns from property table to largeproperty table whose square footage is…

Q: salary. Permanently remove the column “First Name” from the DataFrame. Do not use del. Permanently…

A: To insert a column in data frame,df['newColumn'] = df['oldColumn'] *operationTo permanently remove…

Q: Create a procedure called sp_InsertTeamDetails that will be used to insert data into the…

A: Creating a procedure called sp_InsertTeamDetails that will be used to insert data into the…

Q: mysql> select * from item_db; | item_code | item_name 2 B 8 10 33 85 200 500 9 6 rows in set (0.00…

A: The number of orders made for the item with code '200' directly from the provided item_db table.…

Q: Use a subquery to find employees' last names and hire date from the employees table whose manager is…

A: Let us see the answer:-

Q: How many distinct visit reasons start with the word "Pain"? Name the result column as NumPainReason.…

A: SELECT COUNT(DISTINCT VisitReason) AS NumPainReason FROM VisitWHERE VisitReason LIKE 'Pain%';

Q: Display the RID, RType and Bedroom of all ROOMS whose number of bedrooms is less than RID 105. Use…

A: Required:

Q: Your company needs to contact the 1st author of each textbook and to discuss reprint options. Pull…

A: Microsoft AccessMicrosoft Access is a relational database management system that allows you to…

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: Create your own format of the market list to include, name of items or supplies that are used…

A: import java.util.ArrayList; import java.util.List; import java.util.Scanner; class Product { //…

Q: That is not the answer to the above question. Please create CKY tables for the question that was…

A: 0 1 2 3 0 S - - - 1 NP VP - - 2 - V - NP 3 - - Det Noun 4 - - a View S -> NP VP…

Q: What is the index at the end letter of your first name in Yname?

A: Start Input string Yname Input letter you want to find the index Iterate over the string Compare…

Q: SQL List the item number in lower case, description in upper case, order date 30 days later (add 30…

A: ORDER Table: Creating ORDER table: create table ORDERS(ORDER_NUM integer,ORDER_DATE…

Q: _FNAME VARCHAR(15) NOT NULL, INITIAL CHAR(1), _AREACODE CHAR(3) DEFAULT '615' NOT N…

A: Given CREATE 'TABLE CUSTOMER CU S_CODE NUMBER PRIMARY KEY, CUS_LNAME VARCHAR( 1 5) NOT NULL,…

Q: rows by descending MaxWindMPH, and then by Name.

A: Syntax : - SELECT */<column_names> FROM <table_name> ORDER BY [column_name_1] ASC|DESC,…

Q: Display only unique last_name from students table.

A: This question comes from Database Management System which is a paper of Computer Science. Let's…

Q: Add a CHECK constraint to the orders table requiring the quantity field to be greater than or equal…

A: CHECK constraint: A check constraint is a type of veracity constraint in SQL…

Q: List all painting titles with price greater than 5000$. How many paintings does ‘Ross Georgette’…

A: All SQL Query in step and screenshot with output

Q: Display the lowest rate for each RType having more than 10 minimum rate in the ROOMS table.

A: SQL (Structured Query Language) is a standard programming language that used to manage relational…

Q: Select employee first name, concatenate it with job, find length of department id, find location of…

A: Select employee first name, concatenate it with job, find length of department id, find location of…

Q: Use the appropriate MySQL command to view the structure of the user table

A: SQL (Structured Query Language) is a standard programming language that used to manage relational…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Mark as unused the Category column in the BOOK_PRICING table. Check that the column is no longer…

A: The BOOK_PRICING table is a part of a database used for managing pricing information for books. One…

Q: Can you give more details onceach section mentionned above ?

A: Data modelling: Envision it as the diagram of a data set. It includes planning how data is…

Q: Write about item presentation sequence.

A: Given data is To write about item presentation sequence.

Q: Add validation on CTYPE column in CUSTOMERS table. It must accept either ‘New’ or ‘Old’ only

A: SQL Command to add validation in CTYPE attribute of the table CUSTOMERS is: ALTER TABLE CUSTOMERS…

Q: List State, Sales Year, Current Year Sales, Last Year Sales, and Change in Total Yearly Sales for…

A: based on your description, here's an example SQL query that give you the result you're looking for:…

Q: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit…

A: Here, the new record has to be added to a table and this process is called as Insertion and the…

Q: Alter the given table by adding new column of"Job" in it and assign the sequence values to the…

A: Given the table with four columns namely, Employee_ID Last_Name Annsal Hire_Date To add a new…

Q: Mark the Category field in the BOOK_PRICING table as not being used. Check to see if the field can…

A: "Category" field in the "BOOK_PRICING" table as not being used. However, you would like to determine…

Q: For all trips located in New Hampshire (NH), increase the maximum group size by five. Update the…

A: UPDATE command: The "UPDATE" command is employed to update information present in a table. It is…

Q: Which results would show if the artist table LEFT JOINed the album table? Only rows from the…

A: Given To know about the left join result for artist left join album.

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

Skip not places please.

Following script is given to you at Google Classroom. Run script to generate tables in
Oracle APEX.
EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
DEPT (DEPTNO, DNAME, LOC)
SALGRADE (GRADE, LOSAL, HISAL)
After setting up all relations, you need to apply following queries to get data from given
relations: (Write queries and also paste screenshots in answer file)
i. Display the employee id, name, salary, commissioned salary (incremented salary +
commission) with label "Commissioned_Salary".
ii. Write a query that displays the sum of all salaries of each job!
iii. Get the average of clerks salaries.
iv. President takes maximum salary in our record. Find maximum salary of employees other
than president.
v Show employee name, job, salary and incremented salary (25% incremented salary) of
employees.
vi. Get all Clerk or Salesman salaries that are below 3000 in descending order with respect
to sum of salaries.
vii. Show accumulated high salary and low salary from SALGRADE table.
viii. Display the highest, lowest, sum, average salary of all employees in a single query. Name
the column accordingly.
ix. Write a query to display the difference between highest and lowest salary.
x. Write a query that displays the sum of all salaries of each job.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Trending now

This is a popular solution!

Step by step

Solved in 7 steps with 9 images

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.

Similar questions

Which function does the PRIMARY KEY clause perform in table creation? It ensures that’s non-NULL values can act as unique keys. It ensures that non-NULL values can as candidate keys. It ensures that each value in row is unique. It ensures that each value in the column is unique
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Add a column named ON_HAND_VALUE to the NONCAT table. The on-hand value is a seven-digit number with two decimal places that represents the product of the number of units on hand and the price. Then set all values of ON_HAND_VALUE to ON_HAND * PRICE.
In the BOOK_PRICING table, you should indicate that the Category field is not being utilized. Confirm that the column is no longer an option to choose.
Mark as unused the Category column in the BOOK_PRICING table. Check that the column is no longer accessible.
Create a table with customer names, ID and cities. Create a view of the table where entry is a particular city for example, Columbia.
Write a query on the Songs table to print Taylor Swift’s songs along with the name of the Artist.
The incomplete box plot and table show some information about some marks. Use the information in the table to complete the box plot. Use the information in the box plot to complete the table.
Mark the BOOK_PRICING table's Category field as empty. Check to see whether the column is no longer accessible.
Go to the Scores by Date worksheet. In cell A3, insert another PivotTable based on the Calls table. Use Scores as the name of the PivotTable. Display the Date values as column headings, which automatically groups the data by month. Display the Service Rep names as row headings and the Average score data as values.
Could you please help me with a cyber security problem?
Insert at least three rows into your EMPLOYEE_xx table. Use the next value of the sequence you created , EMPL_SEQUENCE_xx as the value for the employee ID for every row inserted. You may choose values for the other columns Test your constraint on the rate column by trying to update a row in the EMPLOYEE_xx table with the value of 6 used for the Pay Rate (you choose the row). Drop your EMPLOYEE_xx table and make sure it HAS been purged from the recyclebin