Table: ENROLL Table: PREREQUISITE Table: PROFESSOR EMP NUM 103 104 105 106 110 CLASS_CODE 10014 10014 10018 10018 10021 CRS CODE CIS-420 EHRE QM-261 QM-362 QM-362 DEPT_CODE HIST ENG ACCT MKT/MGT BIOL PROF OFFICE DRE 156 DRE 102 KLR 229D KLR 126 AAK 160 STU_NUM 321452 324257 321452 324257 321452 PROF EXTENSION 6783 5561 8665 3899 3412 Write SQL queries to answer the following questions: List the Professor's First (EMP_FNAME) and Last names (EMP_LNAME) of those who teach more than 2 classes (CLASS table). Use Noncorrelated Subquery with INNER JOIN. PRE TAKE CIS-220 MATH-243 MATH-243 QM-261 ENROLL_GRADE с B A B с PROF_HIGH_DEGREE Ph.D. MA Ph.D. Ph.D. Ph.D.
Table: ENROLL Table: PREREQUISITE Table: PROFESSOR EMP NUM 103 104 105 106 110 CLASS_CODE 10014 10014 10018 10018 10021 CRS CODE CIS-420 EHRE QM-261 QM-362 QM-362 DEPT_CODE HIST ENG ACCT MKT/MGT BIOL PROF OFFICE DRE 156 DRE 102 KLR 229D KLR 126 AAK 160 STU_NUM 321452 324257 321452 324257 321452 PROF EXTENSION 6783 5561 8665 3899 3412 Write SQL queries to answer the following questions: List the Professor's First (EMP_FNAME) and Last names (EMP_LNAME) of those who teach more than 2 classes (CLASS table). Use Noncorrelated Subquery with INNER JOIN. PRE TAKE CIS-220 MATH-243 MATH-243 QM-261 ENROLL_GRADE с B A B с PROF_HIGH_DEGREE Ph.D. MA Ph.D. Ph.D. Ph.D.
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...
Related questions
Question
Computer science
Transcribed Image Text:Table: ENROLL
Table: PREREQUISITE
Table: PROFESSOR
EMP_NUM
103
104
105
106
110
CLASS_CODE
10014
10014
10018
10018
10021
CRS_CODE
CIS-420
QM-261
QM-362
QM-362
DEPT_CODE
HIST
ENG
ACCT
MKT/MGT
BIOL
PROF_OFFICE
DRE 156
DRE 102
KLR 229D
KLR 126
AAK 160
STU_NUM
321452
324257
321452
324257
321452
PROF EXTENSION
6783
5561
8665
3899
3412
Write SQL queries to answer the following questions:
List the Professor's First (EMP_FNAME) and Last names (EMP_LNAME) of those who teach more than 2 classes (CLASS table). Use Noncorrelated Subquery with INNER JOIN.
PRE TAKE
CIS-220
MATH-243
MATH-243
QM-261
ENROLL GRADE
с
B
A
B
с
PROF HIGH DEGREE
Ph.D.
MA
Ph.D.
Ph.D.
Ph.D.
Transcribed Image Text:Based on the database below, answer the questions at the end. Note, the PROF_NUM in the CLASS table is equivalent to the EMP_NUM in the EMPLOYEE/PROFESSOR tables.
Table: CLASS
CLASS_CODE
10012
10013
10014
10015
10016
Table: COURSE
Table: EMPLOYEE
EMP_NUM
100
101
102
103
104
CRS_CODE
ACCT-211
ACCT-212
CIS-220
CIS-420
MATH-243
CRS_CODE
ACCT-211
ACCT-211
ACCT-211
ACCT-212
ACCT-212
EMP LNAME
Worley
Ramso
Edwards
Donelly
Yukon
CLASS SECTION
EMP_FNAME
James
Henry
Rosemary
Ronald
Preston
1
2
3
1
2
CRS_DESCRIPTION
Accounting I
Accounting II
Intro. to Microcomputing
Database Design and Implementation
Mathematics for Managers
EMP INITIAL
FM DOD
B
CLASS TIME
MWF 8:00-8:50 a.m.
MWF 9:00-9:50 a.m.
TTh 2:30-3:45 p.m.
MWF 10:00-10:50 a.m.
Th 6:00-8:40 p.m.
***
EMP_JOBCODE
CUST
CUST
TECH
PROF
PROF
ROOM_CODE
BUS311
BUS200
BUS252
BUS311
BUS252
EMP_HIREDATE
2/23/1978
11/15/1994
7/23/1990
7/1/1987
5/1/1992
CRS CREDIT
3
3
3
4
3
PROF NUM
105
105
342
301
301
EMP_DOB
6/12/1950
11/2/1961
7/3/1953
10/2/1952
2/23/1948
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY