EMP: NUMBER (4) EMPNO VARCHAR2 (10) ΕΝΑΜΕ VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7, 2) SAL NUMBER (7, 2) СOMM NUMBER (2) DE PTNΟ DEPT: NUMBER (2) DE PTNΟ VARCHAR2 (14) DNAME VARCHAR2 (13) LOC

Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…

A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…

Q: List the number of customers living at each state that is included in the Customer_T table.

A: Query:-

Q: 7. For each project, display project name, project platform, project cost and total number of…

A: In sql, we use SELECT statement to display the table details according to the requirement. We will…

Q: The HR department needs a report to display employee information as shown from the job_history…

A: SOLUTION- With using DATEDIFF - Below is the SQL query that you could use to generate the report:…

Q: Write a C++ program that read a line of text from the user. The program will replace all four-letter…

A: Here have to determine about c++ code for code of replacing 4 letters words in string.

Q: Create a table with emp name. emp_no ,  emp_name  , emp_grade , emp_salary ,    dept_no  ,…

A: SQL query: creating table SQL> CREATE table emp  2  (  3  emp_no NUMBER,  4  emp_name…

Q: List the names and number of employees supervised (label this value HeadCount) for each supervisor…

A: List  the  nаmes  аnd  number  оf  emрlоyees  suрervised  (lаbel  this  vаlue  HeаdСоunt)  fоr  eасh…

Q: database HR Display the last name, salary, and commission for all employees who earn…

A: /* Creation of EMP table, I am creating column EMP_FIRST_NAME and EMP_LAST_NAME instead of…

Q: Create Department table Create table department with given columns Department department_id number…

A: In the above listed we have to create a table named department with the given table schema. Note as…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition.  student…

Q: List the department name and its instructor’s average salary in which the instructors teach a course…

A: SQL implements WHERE clause with SELECT command in order to retrieve stored information from the…

Q: For each different job_id group in the employee table, show the average salary and job_id for the…

A: SELECT Average_salary,              Job_id  FROM employees  WHERE EXISTS (SELECT *…

Q: List the department name, manager id and location id of all the departments that location id is 2500…

A: SELECT department_name, manager_id, location_id FROM departments where manager_id=124 ||…

Q: How are the column heading labels in a result table changed?

A: Column heading labels in a result table are changed by the SQL*Plus COLUMN command, By using…

Q: Rules term = factor Y $ Y = * factor Y = E factor = ~ factor factor = power power = atom X X = **…

A: Here are the Follow sets for the given grammar:

Q: a) Your task is to write a SQL query to find count of employee who does not have a manager in the…

A: SQL query output is given in step2.

Q: Find the total revenue generated by each product in the past quarter (last 3 months), you would need…

A: In SQL Server, we can use the DATEADD() function to get last 3 months (or n months) records.

Q: Find the staff name who has the maximum salary for each city.

A: The following SQL query will find the staff name who has the maximum salary for each city in the…

Q: Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than 5000.…

A: Let the table name be emp which has the following columns   employee_id, first_name, last_name,…

Q: Fetch and decode Instruction Boolean condition RTL name Fetch TO)L: AR<--PC, SC<-- 0 TI)L: IR<--…

A: RTL I E AC DR IR PC AR M[AR] Initial Value 0 0 3024 3015 3015 314…

Q: rrect Query from table given.

A: Querry is below:

Q: List the name of employee who is working on a project with the budget that is below this project's…

A:

Q: List the name of each department, and its total number of employees, and the total amount of…

A: Query:select dept.deptno, dname, sum(sal), count(empno) from emp  right outer join  dept on…

Q: Display the salesperson name, product finish, and total quantity sold (label as TotSales) for each…

A: In this answer I have provided the SQL code.

Q: Find the total revenue generated by each product in the past quarter (last 3 months), you would need…

A: Orders, Order_details, and products are the three main tables whose data we need to use in order to…

Q: display the first and last names, hire dates, and number of years employed for all employees who…

A: ORDER BY is the keyword used to sort the list and to make it in descending order, we use DESC…

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.