Question: SHOW SQL CODE WITH OUTPUT Question 9: 1. Consider the following tables: EMP (EMPNO, ENAME, JOB, SAL, DEPTNO, HOURS_WORKED) DEPT (DEPTNO, DNAME) a) Consider an

SHOW SQL CODE WITH OUTPUT

SHOW SQL CODE WITH OUTPUT Question 9: 1. Consider the following tables:

Question 9: 1. Consider the following tables: EMP (EMPNO, ENAME, JOB, SAL, DEPTNO, HOURS_WORKED) DEPT (DEPTNO, DNAME) a) Consider an employee can work in more than 1 department. Display the no. of hours worked by each employee if the no. of hours is greater than 40. b) Write a query to display the name, department number, and department name for all employees c) Write a trigger to stop the transaction if the salary of the employee entered by the user is below 2000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

SHOW SQL CODE WITH OUTPUT Question 11: 1. Consider the following table: EMP (Empno, Ename, Employer, Hiredate, Deptno) DEPT (Deptno, Dname, Loc_Id) LOCATION(Loc_Id, City) a. For each employee display...

1. For employees with salary greater than 15000 an 10% increment has been announced by the company, write a query that increments the salaries for these employees. Name this column as Updated Salary...

B . Consider the "emp" and "dept" tables from a part of the relational database schema of "Company" database given below, and answer the following questions: ) = ( 5 marks Emp ( empno , ename, job,...

SQL statements. 1. Show employees who do not have commission. What commando to use? 2. Show today's date and time in Norwegian format. What commando to use? 3. Show employees who do not have 500 in...

PS13 Write a SQL query that shows the empno, ename, job and total salary for all employees from the emp table, and uses a sub-query to show that earn more than the average salary. You will have to...

PS12 Sub-query with an inequality operator, and a weakly correlated sub-query. 1. a) Write a SQL query that shows the empno, ename, job and total salary for all employees from the emp table, and uses...

SQL Queries to Develop Develop SQL statements using the EMP and DEPT tables explained in Oracle APEX. Use Oracle APEX to try out and test each SQL statement. Note that SAL is a month salary. Send in...

SQL Queries to Develop SQL statements. Develop SQL statements using the EMP and DEPT tables explained in the lecture notes and available in Oracle APEX. Use Oracle APEX to try out and test each SQL...

Populate.sql: Please show with steps on cmd SQL format Rem ******** dropping tables ************* DROP TABLE SALGRADE; DROP TABLE EMPLOYEE; DROP TABLE DEPT; Rem ******** create table DEPT...

EMPLOYEE TABLE (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) DEPT (DEPTNO, DNAME, LOC) Solve the following DML queries for the above two tables. 1- Display the name of all the clerks who...

A crate with mass 325 kg initially at rest on a warehouse floor is acted on by a net horizontal force of 140 N. (a) What acceleration is produced? (b) How far does the crate travel in 10.0 s? (c)...

Show that the roots of the equation. (1 + x)^2n + (1-x)^2n = 0 are given by i tan (2r - 1) where r= 1, 2, 3, ....., n. It 4n

Diff'erences between actual costs and standard costs are found in the variance accounts of which a great number are discussed in the chapter. What considerations might determine the number of...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

How would redundant storage of values in columns in a Table be eliminated?

What do Primary Keys, along with Third Normal Form Design in a Database Model, achieve?

Describe Table Structures in RDMSs.