ΕΡARTMΕNT dept name building budget Biology Comn. Sci Watson 90000 Taylor 100000

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
Question 3 (foo3 s)
Consider the following states of DEPARTMENT and COURSE relations.
DEPARTΤΜΕΝT
dept name
building
budget
Biology
Comp. Sci.
Elec. Eng.
Finance
Watson
90000
Taylor
Taylor
Painter
100000
85000
120000
History
Music
Painter
50000
80000
Packard
Watson
Physics
70000
COURSE
dept_name
Biology
Biology
Biology
Comp. Sci.
Comp. Sci.
Comp. Sci.
Comp. Sci.
Database System Concepts Comp. Sci.
Elec. Eng.
Finance
course id
title
credits
BIO-101
BIO-301
BIO-399
Intro. to Biology
Genetics
4
4
Computational Biology
Intro. to Computer Science
Game Design
Robotics
CS-101
4
CS-190
CS-315
CS-319
4
Image Processing
3
CS-347
EE-181
FIN-201
HIS-351
Intro. to Digital Systems
Investment Banking
World History
History
Music
3
MU-199
Music Video Production
Physical Principles
Physics
PHY-101
4
Print the results (as a relation [with attribute names]) of the following relational algebra queries.
(a) Tcourse_id, title, credits (Odept_name = 'Biology (COURSE) )
(b)
dept_name SUM credits ( Tcourse_id, dept_name, credits(COURSE) )
( dept_name, course_id, building (COURSE*DEPARTMENT)
(d) T credits(COURSE) I Tbuilding (DEPARTMENT)
COURSE % T credits
(е) F.
SUM budget((T dept_name>credits
COURSE)*DEPARTMENT)
Transcribed Image Text:Question 3 (foo3 s) Consider the following states of DEPARTMENT and COURSE relations. DEPARTΤΜΕΝT dept name building budget Biology Comp. Sci. Elec. Eng. Finance Watson 90000 Taylor Taylor Painter 100000 85000 120000 History Music Painter 50000 80000 Packard Watson Physics 70000 COURSE dept_name Biology Biology Biology Comp. Sci. Comp. Sci. Comp. Sci. Comp. Sci. Database System Concepts Comp. Sci. Elec. Eng. Finance course id title credits BIO-101 BIO-301 BIO-399 Intro. to Biology Genetics 4 4 Computational Biology Intro. to Computer Science Game Design Robotics CS-101 4 CS-190 CS-315 CS-319 4 Image Processing 3 CS-347 EE-181 FIN-201 HIS-351 Intro. to Digital Systems Investment Banking World History History Music 3 MU-199 Music Video Production Physical Principles Physics PHY-101 4 Print the results (as a relation [with attribute names]) of the following relational algebra queries. (a) Tcourse_id, title, credits (Odept_name = 'Biology (COURSE) ) (b) dept_name SUM credits ( Tcourse_id, dept_name, credits(COURSE) ) ( dept_name, course_id, building (COURSE*DEPARTMENT) (d) T credits(COURSE) I Tbuilding (DEPARTMENT) COURSE % T credits (е) F. SUM budget((T dept_name>credits COURSE)*DEPARTMENT)
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

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