4. Using the EMPLOYEE, JOB, and PROJECT tables; write the SQL code that will join the EMPLOYEE and PROJECT tables using EMP NUM as the common attribute. Display the attributes shown in the results presented below, sorted by project value. PROJ NAME PROJ VALLE FROJ BALANCE EMP LNAME BMP_FNAME EMP NTIAL JOB CODE JOB_ DESCRPTION JOB_CHO HOUR Roling Tide Evergreen Startight Anber Wave 805000.00 500345 20 Senior David H 501 Systems Analyst 96.75 1453500.00 2650500.00 3500500.00 Programmer Programmer Systems Analyst 1002350.00 Arbough June 500 35.75 2309880 00 Alonzo Maria 00 35.75 2110346 00 viashington Ralph 501 96.75 5. Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted by project number.
4. Using the EMPLOYEE, JOB, and PROJECT tables; write the SQL code that will join the EMPLOYEE and PROJECT tables using EMP NUM as the common attribute. Display the attributes shown in the results presented below, sorted by project value. PROJ NAME PROJ VALLE FROJ BALANCE EMP LNAME BMP_FNAME EMP NTIAL JOB CODE JOB_ DESCRPTION JOB_CHO HOUR Roling Tide Evergreen Startight Anber Wave 805000.00 500345 20 Senior David H 501 Systems Analyst 96.75 1453500.00 2650500.00 3500500.00 Programmer Programmer Systems Analyst 1002350.00 Arbough June 500 35.75 2309880 00 Alonzo Maria 00 35.75 2110346 00 viashington Ralph 501 96.75 5. Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted by project number.
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
Related questions
Concept explainers
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Question
Transcribed Image Text:4. Using the EMPLOYEE, JOB, and PROJECT tables; write the SQL code that will join the EMPLOYEE and
PROJECT tables using EMP_NUM as the common attribute. Display the attributes shown in the results
presented below, sorted by project value.
PROJ NAME PROJ VALLE FROJ BALANCE EMP_LNAME EMP_FNAME EMP_NTIAL JOB_CODE JOB_DESCRIPTION JOB_CHG HOUR
Roling Tide
Evergreen
Startight
Amber Wave
96.75
35.75
35.75
805000.00
500345.20 Senior
David
H
501
Systems Analyst
1453500.00
1002350.00 Arbough
June
500
Programmer
Programmer
Systems Analyst
2650500.00
2309880.00 Alonzo
Maria
D
500
3500500.00
2110346.00 Washington Ralph
501
96.75
5. Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted by
project number.
Transcribed Image Text:1. Table : ASSIGNMENT
2. TABLE: EMPLOYEE
E EMPLOYEE
E ASSIGNMENT
EMP NU . EMP LNAM - EMP FNAM - EMP INITIA - EMP HIREDAT JOB COL - EMP YEAI -
4101
- 102
E 103
ASSIGN_NUM - ASSIGN_DATE. PROJ_NUM . EMP_NUM . ASSIGN_JOB . ASSIGN_CHG_HR
- ASSIGN_CHARGE.
295.75
ASSIGN_HOURS
News
Senior
G
08-Nov-00 502
12 Jul-89 501
01-Dec-96 503
John
6.
1001
22-Mar-14 18
103
503
84.50
3.5
David
H.
17
1002
22-Mar-14 22
117
509
34 55
4.2
145.11
1003
22-Mar-14 18
117
509
34.55
2.0
69.10
Arbough
June
E
10
1004
22-Mar 14 18
103
503
84.50
5.9
498.55
- 104
Ramoras
Anne
K
15-Nov-87 501
19
- 105
+ 106
O 107
- 108
Johnson
Smithfield
Alonzo
Washington
Alice
William
1005
K
01-Feb-93 502
14
22-Mar-14 25
22-Mar-14 22
22 Mar-14 25
108
501
96.75
96.75
22
212.85
406.35
1006
104
501
4.2
22-Jun-04 500
2
1007
113
508
50 75
38
192 85
Maria
D
10-Oct-93 500
13
1008
22-Mar-14 18
103
503
84.50
0.9
70.05
Ralph
Larry
22-Aug-91 501
18-Jul-97 501
B
15
1009
23-Mar-14 15
115
501
96 75
5.6
541.80
+ 109
- 110
- 111
+ 112
Smith
9
1010
23 Mar-14 15
117
509
34.55
2.4
82.92
Olenko
Wabash
1011
23-Mar.14 25
105
502
105.00
4.3
451.50
Gerald
11-Dec-95 505
11
04-Apr-91 506
23-Oct-94 507
1012
23-Mar-14 18
108
501
96.75
3.4
328.95
Geoff
B
15
193.50
270.90
1013
23-Mar-14 25
115
501
96.75
2.0
Smithson
Darlene
12
1014
23-Mar-14 22
104
501
98.75
2.8
113
Joenbrood
Delbert
K
15-Nov-96 508
10
1015
23-Mar-14 15
103
503
84.50
0.1
515.45
- 114
E 115
4 116
Jones
Annelise
20-Aug-93 508
13
1016
23-Mar-14 22
105
502
105.00
4.7
493.50
Bawangi
Travis
B
25-Jan-92 501
15
23-Mar-14 18
23 Mar-14 25
1017
117
509
34.55
3.8
131.29
Gerald
Angie
1018
117
509
34.55
22
76.01
Pratt
05-Mar-97 510
10
19-Jun-96 509
24-Mar-14 25
24-Mar-14 15
24-Mar-14 22
24-Mar-14 22
1019
104
501
110.50
4.9
541.45
国117
Williamson
10
1020
101
502
125.00
3.1
387.50
- 118
Frommer
James
04-Jan-05 510
2
1021
108
501
110.50
2.7
298.35
1022
115
501
110.50
4.9
541.45
437.50
278. 85
1023
24-Mar-14 22
105
502
125.00
3.5
1024
24-Mar-14 15
103
503
84.50
3.3
1025
24-Mar-14 10
117
509
34.55
4.2
145.11
3. TABLE: JOB
曲 IOR
JOB
JOB_COI . JOB DESCRIPTION- JOE CHO_HOL - JOB_LAST_UPDA -
+500
+ 501
35.75
Programmer
Syslems Analyst
Database Designer
Electical Engineer
Mecharical Engineer
Civil Engineer
Clerical Support
DSS Analyst
Applications Designer
Bio Technician
General Support
20-Nov-13
4. TABLE: PROJECT
90.75
20-Nuv-13
+ 502
125.00
24-Mar-14
田 503
+ 504
I PROJECT
PROJ_NL. PROJ_NAME . PROJ_VALUE . PROJ_BALANC. EMP_NU.
84.50
20-Nav-13
67.90
20-Nov-13
+505
55.78
20-Nov-13
Cvergreon
1453500.00
1002350.00 103
2110346.00 108
+ 506
26.87
20 Nov 13
+ 18
O 22
+ 25
Amber Wave
3500500.00
+ 507
4 508
+ 509
4 510
45.95
20-Nov-13
Roling Tide
805000.00
500345.20 102
24-Mar- 14
20-Nov-13
20-Nov-13
48.10
Starfight
2650500.00
2309880.00 107
34.55
18.36
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education