Show students’ first name, last name, the grades of the students, and the credits of the course for the students who took (don’t include currently taking) the course ‘MISM4221’.STUDENT TABLE100001 Johnson Ariel 2000-07-10 Y100002 Green Robin 2001-11-02 Y100003 Johnson Charles 1995-01-12 Y100004 Pearson Jeffery 1996-02-06 Y100005 Sears Miguel 1998-10-31 Y100006 Kyle Leah 2000-05-29 Y100007 Myers Lynda 1980-08-24 Y DB Browser for SQLite - CAUsers\13309\OneDrive\Desktop\sqlite\LabAssignment3.sqliteFileEdit View Tools HelpoNew DatabaseOpen DatabaseWrite ChangesBRevert ChangesOpen ProjectSave ProjectAttach DatabaseX Close DatabaseDatabase StructureBrowse DataEdit PragmasExecute SQLTable:|ENROLLMENTFiter in any columnStudentID CourseID GradeFilterFilterFilter10000110001 A210000110003 NULL310000110004 A410000210006 NULL510000210004 B6.10000210005 B710000310004 NULL810000410002 A10000410003 B1010000410005 NULL1110000510001 NULL1210000610001 C1310000610003 C1410000610004 NULL DB Browser for SQLite - C:\Users\13309\OneDrive\Desktop\sqlite\LabAssignment3.sqliteFileEdit View Tools HelpCONew DatabaseOpen DatabaseGWrite ChangesRevert ChangesOpen ProjectSave ProjectAttach DatabaseX Close DatabaseDatabase Structure Browse DataEdit PragmasExecute SQLTable: COURSEa Fiter in any columnCourseID CourseNumber DescriptionCreditFilterFilterFilterFilter10001MISM4221 System .3210002MISM4222 System .3310003CPSC3131 Database I410004CPSC3132 Database II3510005CPSC4231 Cyber .610006MISM3136 Database310007ECON3221 Principles.

Select St.FristName, St.LastName, Et.Grade, C.CourseIDfrom Student St INNER JOIN Enrollment Et ON…

Answered: Show students’ first name, last name,…

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

See similar textbooks

Related questions

Concept explainers

Question

Show students’ first name, last name, the grades of the students, and the credits of the course for the students who took (don’t include currently taking) the course ‘MISM4221’.

STUDENT TABLE

100001 Johnson Ariel 2000-07-10 Y
100002 Green Robin 2001-11-02 Y
100003 Johnson Charles 1995-01-12 Y
100004 Pearson Jeffery 1996-02-06 Y
100005 Sears Miguel 1998-10-31 Y
100006 Kyle Leah 2000-05-29 Y
100007 Myers Lynda 1980-08-24 Y

DB Browser for SQLite - CAUsers\13309\OneDrive\Desktop\sqlite\LabAssignment3.sqlite
File
Edit View Tools Help
oNew Database
Open Database
Write Changes
BRevert Changes
Open Project
Save Project
Attach Database
X Close Database
Database Structure
Browse Data
Edit Pragmas
Execute SQL
Table:
|ENROLLMENT
Fiter in any column
StudentID CourseID Grade
Filter
Filter
Filter
100001
10001 A
2
100001
10003 NULL
3
100001
10004 A
4
100002
10006 NULL
5
100002
10004 B
6.
100002
10005 B
7
100003
10004 NULL
8
100004
10002 A
100004
10003 B
10
100004
10005 NULL
11
100005
10001 NULL
12
100006
10001 C
13
100006
10003 C
14
100006
10004 NULL

DB Browser for SQLite - C:\Users\13309\OneDrive\Desktop\sqlite\LabAssignment3.sqlite
File
Edit View Tools Help
CONew Database
Open Database
GWrite Changes
Revert Changes
Open Project
Save Project
Attach Database
X Close Database
Database Structure Browse Data
Edit Pragmas
Execute SQL
Table: COURSE
a Fiter in any column
CourseID CourseNumber Description
Credit
Filter
Filter
Filter
Filter
10001
MISM4221 System .
3
2
10002
MISM4222 System .
3
3
10003
CPSC3131 Database I
4
10004
CPSC3132 Database II
3
5
10005
CPSC4231 Cyber .
6
10006
MISM3136 Database
3
10007
ECON3221 Principles.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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