Student Enrollment nationality US studentNr courseNr section 100 CS 1713 100 ENG1043 100 HIS1033 midTerm final studentNrclassif 100 FR 200 SO 95 85 80 80 1 2 85 85 US 300 JR CN 100 MAT1224 200 CS 1713 100 100 90 400 SR CN 500 FR GT 91 200 CS 3743 1 85 95 US US 600 SR 50 80 200 MAT1224 300 CS 1083 300 CS 1713 1 700 SO 800 SO US 1 50 75 65 80 58 90 300 CS 3743 500 CS 1713 3 100 80 95 90 500 HIS1033 700 HIS1033 1 95 90 Course courseNr dept title CS 1083 CS Intro to CS I Intro to CS II Database System English I History of the World Part I Calculus I CS 1713 CS CS 3743 CS ENG1043 ENG HIS1033 HIS MAT1224 MAT

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

Relatioal algebra: 

 

Get the Student Number and Nationality of the senior students who have failed (based only on the final grade) the course entitled "Intro into CS II" 

Student
Enrollment
studentNrclassif
100 FR
200 SO
300 JR
studentNr courseNr section
100 CS 1713
100 ENG1043
100 HIS1033
midTerm final
95
85
80
nationality
US
1
80
US
1
85
CN
85
100
100 MAT1224
200 CS 1713
200 CS 3743
200 MAT1224
300 CS 1083
300 CS 1713
300 CS 3743
500 CS 1713
500 HIS1033
700 HIS1033
100
90
95
80
75
80
90
400 SR
CN
1
2
91
500 FR
600 SR
GT
US
85
50
50
65
58
100
95
95
1
700 SO
US
1
1
800 SO
US
3
80
1
90
1
90
Course
courseNr dept
CS 1083
CS 1713
CS 3743
title
Intro to CS I
Intro to CS II
Database System
English I
History of the World Part I
Calculus I
CS
CS
CS
ENG1043 ENG
HIS1033 HIS
MAT1224 MAT
22
Transcribed Image Text:Student Enrollment studentNrclassif 100 FR 200 SO 300 JR studentNr courseNr section 100 CS 1713 100 ENG1043 100 HIS1033 midTerm final 95 85 80 nationality US 1 80 US 1 85 CN 85 100 100 MAT1224 200 CS 1713 200 CS 3743 200 MAT1224 300 CS 1083 300 CS 1713 300 CS 3743 500 CS 1713 500 HIS1033 700 HIS1033 100 90 95 80 75 80 90 400 SR CN 1 2 91 500 FR 600 SR GT US 85 50 50 65 58 100 95 95 1 700 SO US 1 1 800 SO US 3 80 1 90 1 90 Course courseNr dept CS 1083 CS 1713 CS 3743 title Intro to CS I Intro to CS II Database System English I History of the World Part I Calculus I CS CS CS ENG1043 ENG HIS1033 HIS MAT1224 MAT 22
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 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