Question
Asked Nov 12, 2019
8 views

Find the employment age of each employee?

 

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
help_outline

Image Transcriptionclose

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

fullscreen
check_circle

Expert Answer

Step 1

The SQL statement is given below to construct an EMP table and to add the values according to the given information.

Statement:

CREATE TABLE EMP(EMPNO NUMBER(4), ENAME VARCHAR(10), JOB VARCHAR(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2),

COMM NUMBER(7, 2), DEPTNO NUMBER(2), PRIMARY KEY(EMPNO));

INSERT INTO EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)

VALUES (11, 'ROBIN', 'TUTOR', 456, '19...

help_outline

Image Transcriptionclose

COMM EMPNO ENAME JOB MGR HIREDATE SAL DEPTNO ANDREW SME 200 1980-11-25 130 251 20 11 12 NEIL QA 201 1998-05-26 1456 252 21 CARRY 13 202 1995-07-18 1814 253 22 AM

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Using the network access control for a diagram drawn as a model, investigate the network access cont...

A: Network Access Control (NAC):Network Access Control (NAC) is one of the most important approaches fo...

question_answer

Q: For the following problems assume 1 kilobyte (KB) 1024 kilobytes. 1024 bytes and 1 megabyte (MB) For...

A: (a) The last bits of virtual address are called offset. And for a 4K page, the number of bits will b...

question_answer

Q: Write a simplified expression for the Boolean function defined by the following Kmap.

A: Answer:Given K-map:                  

question_answer

Q: A variable name in the programming language Visual Basic must begin with a letter (uppercase or lowe...

A: Answer:Number of letters (uppercase + lowercase) = 26 + 26 = 52Number of digits (0 to 9) = 10Number ...

question_answer

Q: An administrator has received a call indicating that some users are having difficulty logging on aft...

A: Domain Controller:Domain controller is a server computer on Microsoft servers.The purpose of domain ...

question_answer

Q: Given a nested list named table, use a loop to print each sub list of the nested list. The sub lists...

A: Program descriptionOne 3 x3 list is created to demonstrate the conceptdisplay the elements of the su...

question_answer

Q: Write a method named sumInts that can take a variable number of int arguments and return the sum of ...

A: Below is the approach, and a java program to display the sum of integer arguments, passed in the sum...

question_answer

Q: What are the SQL commands to create TABLE BOOK, that includes  both primary and foreign keys, with t...

A: Primary key:A PRIMARY KEY is used to uniquely define every tuple in a table. The PRIMARY KEY imposes...

question_answer

Q: Suppose you want to build a program using WebGL that draws two kinds of objects - shiny billiard bal...

A: Drawing multiple objects in WebGLIn order to draw two kinds of objects in WebGL, first call function...