m university database , Write the following queries in SQL Find the titles of courses in the Comp. Sci. department that have 3 credits Find all instructors earning the highest salary (there may be more than one with the same salary) Find all courses that have never been offered (i.e., do not occur in the section relation). b) given the following tables( instructor, teaches) what is the output of the following query select i.name from instructor as i, teaches as t where i.ID=t.ID and semester=’ Fall’ and year=2017;

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

a) from university database , Write the following queries in SQL

  • Find the titles of courses in the Comp. Sci. department that have 3 credits
  • Find all instructors earning the highest salary (there may be more than one with the same salary)
  • Find all courses that have never been offered (i.e., do not occur in the section relation).
  1. b) given the following tables( instructor, teaches) what is the output of the following query

select i.name

from instructor as i, teaches as t

where i.ID=t.ID and semester=’ Fall’ and year=2017;

ID
пате
dept name
salary
22222
Einstein
Physics
95000
12121
Wu
Finance
90000
32343
El Said
History
Comp. Sci.
Elec. Eng.
Biology
Comp. Sci.
History
Comp. Sci.
Music
60000
45565
Katz
75000
98345
Kim
80000
76766
Crick
72000
10101
Srinivasan
65000
58583
Califieri
62000
83821
Brandt
92000
15151
Mozart
40000
33456
Gold
Physics
87000
76543
Singh
Finance
80000
the instructor relation.
Transcribed Image Text:ID пате dept name salary 22222 Einstein Physics 95000 12121 Wu Finance 90000 32343 El Said History Comp. Sci. Elec. Eng. Biology Comp. Sci. History Comp. Sci. Music 60000 45565 Katz 75000 98345 Kim 80000 76766 Crick 72000 10101 Srinivasan 65000 58583 Califieri 62000 83821 Brandt 92000 15151 Mozart 40000 33456 Gold Physics 87000 76543 Singh Finance 80000 the instructor relation.
ID
соurse_id
sec_id
semester
уear
10101
CS-101
1
Fall
2017
10101
CS-315
1
Spring
2018
10101
CS-347
1
Fall
2017
12121
FIN-201
Spring
Spring
1
2018
15151
MU-199
1
2018
22222
PHY-101
1
Fall
2017
32343
HIS-351
1
Spring
Spring
Spring
2018
45565
CS-101
1
2018
45565
CS-319
1
2018
76766
BIO-101
1
Summer
2017
76766
BIO-301
1
Summer
2018
83821
Spring
Spring
Spring
Spring
CS-190
1
2017
83821
CS-190
2017
83821
CS-319
2018
98345
EE-181
1
2017
The teaches relation.
Transcribed Image Text:ID соurse_id sec_id semester уear 10101 CS-101 1 Fall 2017 10101 CS-315 1 Spring 2018 10101 CS-347 1 Fall 2017 12121 FIN-201 Spring Spring 1 2018 15151 MU-199 1 2018 22222 PHY-101 1 Fall 2017 32343 HIS-351 1 Spring Spring Spring 2018 45565 CS-101 1 2018 45565 CS-319 1 2018 76766 BIO-101 1 Summer 2017 76766 BIO-301 1 Summer 2018 83821 Spring Spring Spring Spring CS-190 1 2017 83821 CS-190 2017 83821 CS-319 2018 98345 EE-181 1 2017 The teaches relation.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

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