Get the student#, course# and midterm grade of the enrollments for courses of the CS department.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Relational algebra: 

 

Get the student#, course# and midterm grade of the enrollments for courses of the CS department. 

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
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education