a) Ax(OB.b2-10B) b) AXA.a4=B.b3 B c) AN (A.a1=B.b1 AND A.a3=B.b2) B

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%
3.
Using tables given below, show the results of the following operations given in relational
algebra.
A
a1
a2
аз
a4
c1
c2
2
3
4
4
4
1
8
12
3
4
6
7
4
4
12
4
7
7
6
b2
4
b1
b3
7
12
3
7
4
12
11
7
4
a) Ax(OB.b2>10B)
b) AX A.a4=B.b3 B
c) AM (A.a1=B.b1 AND A.a3=B.b2) B
d) BU (Пlа1, а2, а3) А)
e) P (d1, d2, d3)(c1 ICOUNT c2, SUM c2 C)
) C+ (P (62) ( T(a3) A))
Transcribed Image Text:3. Using tables given below, show the results of the following operations given in relational algebra. A a1 a2 аз a4 c1 c2 2 3 4 4 4 1 8 12 3 4 6 7 4 4 12 4 7 7 6 b2 4 b1 b3 7 12 3 7 4 12 11 7 4 a) Ax(OB.b2>10B) b) AX A.a4=B.b3 B c) AM (A.a1=B.b1 AND A.a3=B.b2) B d) BU (Пlа1, а2, а3) А) e) P (d1, d2, d3)(c1 ICOUNT c2, SUM c2 C) ) C+ (P (62) ( T(a3) A))
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