Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
1. Create the emp table and insert the date as showed in the picture. (EMPNO is PK) 2. Rename JOB column with Title. 3. Add a column and name it as Date of Birth

1. Create the emp table and insert the date as showed in the picture. (EMPNO is PK) 2. Rename JOB column with Title. 3. Add a column and name it as Date of Birth

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
1۱۲:۰۱ Ĉ EE A bartleby.com = bartleby Q&A Engineering / Computer Science / Q&A Library / Lab Exercise... Lab Exercise Consider the following emp t... SOlve timIS (SQL) Lab Exercise Consider the following emp table given below and perform the given below operations. + Oracle SQL Plus te Ek Serch gkns bep SQL> select from enp; ENPND ENAE JOD HGR MIREDATE SAL COMM 7369 SMITH 7499 ALLEN 7521 MARD 7566 JONES 7654 HARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING CLERK SALESHAN SALESHAN HANAGER 7982 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 7839 02-APR-81 800 1600 1250 300 500 2975 1250 2850 2450 3000 SALESHAN 7698 28-SEP-81 1400 HANAGER HINAGER ANALYST PRESIDENT 7839 01-HAV-81 7839 09-JUN-81 7566 19-APR-87 17-NOU-81 7698 -SEP-81 7788 23-HAY-87 7698 03-DEC-81 7566 03-DEC-81 782 29-JAN-82 784A TURNER SALESHAN 1580 7876 ADAMS 7900 JAHES 7902 FORD 7934 HILLER CLERK CLERK ANALYST CLERK 1180 950 300 1300 14 rows selected. SOL> | 1. Create the emp table and insert the date as showed in the picture. (EMPNO is PK) 2. Rename JOB column with Title. 3. Add a column and name it as Date of Birth 4. Drop the COMM column 5. Rename the table as Employees. 6. Check that the SAL column value is between 500 and 10000 7. Delete all records from the table. - For each step screenshot the SQL code you wrote + screenshot the table showing the changes done. - Upload your work to Blackboard as a PDF file.
Transcribed Image Text:1۱۲:۰۱ Ĉ EE A bartleby.com = bartleby Q&A Engineering / Computer Science / Q&A Library / Lab Exercise... Lab Exercise Consider the following emp t... SOlve timIS (SQL) Lab Exercise Consider the following emp table given below and perform the given below operations. + Oracle SQL Plus te Ek Serch gkns bep SQL> select from enp; ENPND ENAE JOD HGR MIREDATE SAL COMM 7369 SMITH 7499 ALLEN 7521 MARD 7566 JONES 7654 HARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING CLERK SALESHAN SALESHAN HANAGER 7982 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 7839 02-APR-81 800 1600 1250 300 500 2975 1250 2850 2450 3000 SALESHAN 7698 28-SEP-81 1400 HANAGER HINAGER ANALYST PRESIDENT 7839 01-HAV-81 7839 09-JUN-81 7566 19-APR-87 17-NOU-81 7698 -SEP-81 7788 23-HAY-87 7698 03-DEC-81 7566 03-DEC-81 782 29-JAN-82 784A TURNER SALESHAN 1580 7876 ADAMS 7900 JAHES 7902 FORD 7934 HILLER CLERK CLERK ANALYST CLERK 1180 950 300 1300 14 rows selected. SOL> | 1. Create the emp table and insert the date as showed in the picture. (EMPNO is PK) 2. Rename JOB column with Title. 3. Add a column and name it as Date of Birth 4. Drop the COMM column 5. Rename the table as Employees. 6. Check that the SAL column value is between 500 and 10000 7. Delete all records from the table. - For each step screenshot the SQL code you wrote + screenshot the table showing the changes done. - Upload your work to Blackboard as a PDF file.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS