CREATING TABLES USING oracle APEX   CREATE TABLE DEPT ( DEPTNO NUMBER(10) NOT NULL, DNAME VARCHAR2(50) NOT NULL, LOC VARCHAR2(50), CONSTRAINT DEPT_PK PRIMARY KEY (DEPTNO) );   NOTNULL constraint is used it represents cell should not be empty Here NUMBER AND VARCHAR are data types   Step 2 Now create emp table   CREATE TABLE EMP( EMPNO NUMBER(10) NOT NULL, ENAME VARCHAR2(50) NOT NULL, JOB VARCHAR2(50), MGR VARCHAR2(50), HIREDATE DATE, SAL NUMBER(6), DEPTNO NUMBER(10) NOT NULL, CONSTRAINT EMP_PK PRIMARY KEY (EMPNO), CONSTRAINT EMP_FK FOREIGN KEY ( DEPTNO) REFERENCES DEPT (DEPTNO) );   oracle consists of standard DATE formats we have to use that PRIMARY KEY is used to uniquely identify records from the table FOREIGN KEY is used to establish the connection between any two tables Here DEPT is a resultant table of EMP table   Step 3 Now SALGRADE TABLE   CREATE TABLE SALGRADE ( GRADE NUMBER (10) NOT NULL, LOSAL NUMBER(6), HISAL NUMBER(6), CONSTRAINT SALGRADE_PK PRIMARY KEY (GRADE) );   Combination of unique and not-null constraints we get primary key constraint   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.

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
icon
Related questions
Question

CREATING TABLES USING oracle APEX

 

CREATE TABLE DEPT (

DEPTNO NUMBER(10) NOT NULL,

DNAME VARCHAR2(50) NOT NULL,

LOC VARCHAR2(50),

CONSTRAINT DEPT_PK PRIMARY KEY (DEPTNO)

);

 

  • NOTNULL constraint is used it represents cell should not be empty
  • Here NUMBER AND VARCHAR are data types

 

Step 2

Now create emp table

 

CREATE TABLE EMP(

EMPNO NUMBER(10) NOT NULL,

ENAME VARCHAR2(50) NOT NULL,

JOB VARCHAR2(50),

MGR VARCHAR2(50),

HIREDATE DATE,

SAL NUMBER(6),

DEPTNO NUMBER(10) NOT NULL,

CONSTRAINT EMP_PK PRIMARY KEY
(EMPNO),

CONSTRAINT EMP_FK FOREIGN KEY (
DEPTNO) REFERENCES DEPT (DEPTNO)

);

 

  • oracle consists of standard DATE formats we have to use that
  • PRIMARY KEY is used to uniquely identify records from the table

  • FOREIGN KEY is used to establish the connection between any two tables

  • Here DEPT is a resultant table of EMP table

 

Step 3

Now SALGRADE TABLE

 

CREATE TABLE SALGRADE (

GRADE NUMBER (10) NOT NULL,

LOSAL NUMBER(6),

HISAL NUMBER(6),

CONSTRAINT SALGRADE_PK PRIMARY KEY (GRADE)

);

 

  • Combination of unique and not-null constraints we get primary key constraint

 

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.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
SQL Query
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education