Question: SQL APPENDIX: DEPTNO is a PK in DEPT and EMPNO is a PK in EMP, whereas DEPTNO is a FK in EMP table SQL> select

SQL

SQL APPENDIX: DEPTNO is a PK in DEPT and EMPNO is a

PK in EMP, whereas DEPTNO is a FK in EMP table SQL>

select from dept; DEPTNO DNAME Loc 10 ACCOUNTING 20 RESEARCH 30 SALES

40 OPERATIONS NEW YORK DALLAS CHICAGO BOSTON SL> select from emp: EMPNO

ENAME JOB MGR HIREDATE SAL COMM DEPTNO 800 1600 1250 2975 1250

APPENDIX: DEPTNO is a PK in DEPT and EMPNO is a PK in EMP, whereas DEPTNO is a FK in EMP table SQL> select from dept; DEPTNO DNAME Loc 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS NEW YORK DALLAS CHICAGO BOSTON SL> select from emp: EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 800 1600 1250 2975 1250 2850 2450 3000 5000 1500 1100 950 3000 1300 12000 20 30 30 20 30 30 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER 7935 EJAZ CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK ANALYST 7902 17-DEC-1980 7698 20-FEB-1981 7698 22-FEB-1981 7839 02-APR-1981 7698 28-SEP-1981 7839 01-MAY-1981 7839 09-JUN-1981 7566 19-APR-1987 300 500 1400 20 17-NOV-1981 7698 08-SEP-1981 7788 23-MAY-1987 7698 03-DEC-1981 7566 03-DEC-1981 7902 23-JAN-1982 7782 30 20 30 20 500 16 rows selected

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!

SQL APPENDIX: DEPTNO is a PK in DEPT and EMPNO is a PK in EMP, whereas DEPTNO is a FK in EMP table SQL> select from dept; DEPTNO DNAME Loc 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS NEW YORK...

Hello, I am taking an Intro to Database Management Course and there are a few queries that I need help on for an assignment. I have posted the SQL code that the instructor wants us to work with and...

CREATE TABLE EMP ( EMPNO NUMBER ( 6 ) NOT NULL, ENAME VARCHAR 2 ( 2 0 ) , JOB VARCHAR 2 ( 1 0 ) , MGR NUMBER ( 4 ) , DEPTNO NUMBER ( 3 ) , SAL NUMBER ( 7 , 2 ) , PRIMARY KEY ( EMPNO ) ) ; CREATE...

drop table department purge; drop table employee purge; create table department (ID, department_name) as select deptno, dname from dept; create table employee (employee_id, dept_id) as select empno,...

This is script. We need to use Table EMP and Table DEPT. -- echo Building demo tables. Please wait. DROP TABLE EMP CASCADE CONSTRAINTS; DROP TABLE DEPT; DROP TABLE SALGRADE; DROP TABLE Prod CASCADE...

Sub-query with an inequality operator. 1. Write a SQL query that uses a sub-query to show the empno, ename, job and total salary for all employees from the emp table that earn more than the average...

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

Problem Set 15 In this assignment you will be creating views. Views are a way to display information from various tables or views in a way that is easily comprehended by end-users. 1. Log on to your...

In this assignment you will be creating views. Views are a way to display information from various tables or views in a way that is easily comprehended by end-users. 1. Log on to your Oracle ApEx...

VIEWS In this assignment you will be creating views. Views are a way to display information from various tables or views in a way that is easily comprehended by end-users. 1. Log on to your Oracle...

Assume that flow in the converging nozzle of Fig. P4.2 has the form V =Vo (1 + 2x/L) i. Compute (a) The fluid acceleration at x = L; and (b) The time required for a fluid particle to travel from x =...

The data stored in Drink represents the amount of soft drink in a sample of fifty 2- liter bottles. a. Construct a histogram and a percentage polygon. b. Construct a cumulative percentage polygon. c....

PTS Inc has preferred and common stock outstanding. The stock pays a dividend of $ 4 per share and sells for $ 4 0 with 7 , 0 0 0 shares. The corporate tax rate is 2 1 % . Common stock is valued at $...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

What effect will each of the changes listed in Study Question 3 of Chapter 8 have on the equilibrium level of GDP in the private closed economy? Explain your answers.

KEY QUESTION Refer to columns 1 and 6 in the table for question

Incorporate government into the table by assuming that it plans to tax and spend $20 billion at each possible level of GDP. Also assume that the tax is a personal tax and that government spending...