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

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

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: Create a view of the Join of Deposit and Withdraw transactions to Bank Branch UNION with the join of…

A: To create the requested view, you can use the following SQL query:

Q: Following script is given to you at Google Classroom. Run script to generate tables in Oracle APEX.…

A: Note: since your question contain multiple question having multiple sub-parts but we can answer…

Q: The task is to write SQL statements to define tables for the corresponding relations. Make sure that…

A: SQL, which stands for Structured Query Language, is a programming language used for managing and…

Q: The property management team wants to ensure that the property and owner information always…

A: : to speak or write in replythink carefully before answering 2a: to be or make oneself responsible…

Q: How do you create an index? How do you create a unique index? What is the difference between an…

A: -Creating an index involves the CREATE INDEX command. -it allows us to name the index, to specify…

Q: Check your understanding Do these joins by hand, without a computer. Join a row of Table 1 with a…

A: Inner Join:- In this join, the rows will only return when the join condition is true.

Q: Create the SQL code necessary to create an entity that reflects the following table. Make the ID a…

A: In SQL, tables are defined with CREATE TABLE command. When a table is created, its fields name, data…

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: DELETE CASCADE: - When we constitute a foreign key using this option, it deletes the referencing…

Q: The head of hospital auditing wants to know which patients were charged the most for a treatment.…

A: The solution is given below with demo data inserted into table

Q: Create a view of the Join of Deposit and Withdraw transactions to Bank Branch UNION with the join of…

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: Write SQL commands to create a database and add data to them. There will be two tables: Courses…

A: The question is answered in step2

Q: Using Azure Data Studio & place example after each question: The head DBA has requested the…

A: To create a sequence for the primary key columns of the Criminals and Crimes tables and add a new…

Q: insert the tasks in a batch into the database. In other words, they want to insert the rows all…

A: According to given answer , value will inserted one by one. So below i write code to insert two rows…

Q: Oracle APEX. EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) DEPT (DEPTNO, DNAME, LOC)…

A: DUE TO GUIDELINES, WE CAN ANSWER ONLY ONE QUESTION CREATING TABLES USING oracle APEX CREATE TABLE…

Q: how to Create two or more MySQL VIEWS using the Pizza Store Database. Each of the Views must have a…

A: Given: Create two or more MySQL VIEWS using the Pizza Store Database. . Conditions: Each of the…

Q: You need to run SELECT query and return all travel data from TRAVELS table filtered by the drivers…

A: The driver id in the both tables to be same and the rating of driver in Driver table should be less…

Q: Display all product information for products that contain the string ‘saw’ anywhere in their…

A: LIKE keyword is used to match the values

Q: what happens when we create our tables with relationships and then have to modify the relationship?…

A: we create our table with relationship and then have to modify the relationship:

Q: se MySQL Workbench to create an EER model from the script file named create_my_guitar_shop.sql…

A: ANSWER:-

Q: kip not places please.

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

Q: Which of the following statements about JOIN in relational algebra is false? a. inner join only…

A: Option B is false: X join Y is not the same as Y join X

Q: 10. Which of the following is not an example of single value attribute of a person? a. gender b.…

A: Answer 10:- The correct answer is " date of birth " Explanation:- Therefore, age of a person is a…

Q: Compare between the following: Temporary table vs. View Assertion vs. Triggers

A: 1. Temporary Table vs. View:Temporary Table: As mentioned before, a temporary table is a storage…

Q: • create a sql script that loads your tables with data. Note: in addition to the data present in the…

A: Hi .. Here i'm assuming that you have already created the table LanguageSchool with the attributes…

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

Part 7 89
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.
11
12

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

Trending now

This is a popular solution!

Step by step

Solved in 5 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

14. How many records are created when you apply a Cartesian join (Cross join) to the invoice and invoice items table? 1. The following diagram is a depiction of what type of join? a. Inner Join b. Full outer join C. Left join d. Right join 16. Select which of the following statements are true regarding inner joins. (Select all that apply) a. There is no limit to the number of table you can join with an inner join. b. Performance will most likely worsen with the more joins you make Inner joins retrieve all matching and nonmatching rows from a table d. Inner joins are one of the most popular types of joins use 17. Which of the following is true regarding Aliases? (Select all that apply.) a. Aliases are often used to make column names more readable b. SQL aliases are used to give a table, or a column in a table, a temporary name. An alias only exists for the duration of the query. 18. What is wrong with the following query? SELECT Customers.CustomerName, Orders.OrderID FROM LEFT JOIN ON…
What exactly do nulls mean? What type of field does not permit invalid values? Why?
Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.
!I am doing all this from cengage! Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. I did with: SELECT * FROM (SELECT * from KimTay) WHERE ROWNUM <= 11; and with: SELECT * FROM (SELECT TABLE_NAME FROM ALL_TABLES ORDER BY TABLE_NAME ) WHERE ROWNUM <= 10; and with: SELECT * FROM SYSTABLES but nothing worked and some of them gave me an error as (ERROR 1248 (42000) at line 1: Every derived table must have its own alias) and I need answers for these too: Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA. Task 12: List all the views contained within the system catalog, but only display the first 12 records. Task 13: Write the command to display only tables within the system catalog that have the KimTay TABLE_SCHEMA and are of the type BASE TABLE. Display only the following columns:…
You are working with a database table that contains invoice data. The table includes columns for invoice_id and billing_state. You want to remove duplicate entries for billing state and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the billing_state column. NOTE: The three dots (...) indicate where to add the clause. SELECT ... FROM invoice ORDER BY invoice_id What billing state appears in row 17 of your query result? 1 point 1-CA 2-NV 3-WI 4-AZ
Code SQL (Screenshot code and output) Create three tables for a company that sells computer software, the tables are employees, department, and product. You can specify the attributes for each table based on what you see fit. Then, Link the three tables together. Note : Work on Oracle SQL live, take a screenshots of you work.
For this assignment, write SQL code based on the tables provided. Create three tables Tables -1.Customer 2.Flower 3.Order Decide what fields, field lengths, and datatypes you need. Do this for each of the 3 tables. Only use VARCHAR2, NUMBER, and DATE datatypes. Assign a primary key to one field in each table Provide the code to insert the records into each of the tables in the database.