Write the SQL queries for the following questions and show results. List all the section numbers of course 'Syst Analysis'. List, in alphabetical order, the names of those students who have been enrolled in “ISM” class.
Write the SQL queries for the following questions and show results. List all the section numbers of course 'Syst Analysis'. List, in alphabetical order, the names of those students who have been enrolled in “ISM” class.
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter1: Database Systems
Section: Chapter Questions
Problem 11P: Using your schools student information system, print your class schedule. The schedule probably...
Related questions
Question
Write the SQL queries for the following questions and show results.
List all the section numbers of course 'Syst Analysis'.
List, in alphabetical order, the names of those students who have been enrolled in “ISM” class.
![QUALIFIED (FacultylID, CourselD, DateQualified)
STUDENT (StudentID, StudentName)
FacultylD
CourselD
DateQualified
StudentID
StudentName
38214
54907
66324
70542
Letersky
Altvater
Aiken
Marra
2143
2143
3467
3467
4756
ISM 3112
ISM 3113
ISM 4212
ISM 4930
ISM 3113
ISM 3112
9/1988
9/1988
9/1995
9/1996
9/1991
...
4756
9/1991
...
FACULTY (FacultylD, FacultyName)
SECTION (SectionNo, Semester, CourselD)
FacultyID
FacultyName
SectionNo
Semester
CourselD
1-2008
1-2008
1-2008
1-2008
2143
3467
4756
Birkin
Berndt
Collins
2712
2713
ISM 3113
ISM 3113
2714
2715
ISM 4212
ISM 4930
COURSE (CourselD, CourseName)
REGISTRATION (StudentID, SectionNo, Semester)
CourselD
CourseName
StudentID
SectionNo
Semester
1-2008
1-2008
1-2008
1-2008
38214
54907
2714
2714
ISM 3113
ISM 3112
ISM 4212
ISM 4930
Syst Analysis
Syst Design
Database
54907
2715
Networking
66324
2713
...](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3d78981a-bbff-4eef-a8c6-94f025de4702%2F36f47395-48f3-4d10-bcc4-2aaa2e3b9090%2Fd2c9oul_processed.png&w=3840&q=75)
Transcribed Image Text:QUALIFIED (FacultylID, CourselD, DateQualified)
STUDENT (StudentID, StudentName)
FacultylD
CourselD
DateQualified
StudentID
StudentName
38214
54907
66324
70542
Letersky
Altvater
Aiken
Marra
2143
2143
3467
3467
4756
ISM 3112
ISM 3113
ISM 4212
ISM 4930
ISM 3113
ISM 3112
9/1988
9/1988
9/1995
9/1996
9/1991
...
4756
9/1991
...
FACULTY (FacultylD, FacultyName)
SECTION (SectionNo, Semester, CourselD)
FacultyID
FacultyName
SectionNo
Semester
CourselD
1-2008
1-2008
1-2008
1-2008
2143
3467
4756
Birkin
Berndt
Collins
2712
2713
ISM 3113
ISM 3113
2714
2715
ISM 4212
ISM 4930
COURSE (CourselD, CourseName)
REGISTRATION (StudentID, SectionNo, Semester)
CourselD
CourseName
StudentID
SectionNo
Semester
1-2008
1-2008
1-2008
1-2008
38214
54907
2714
2714
ISM 3113
ISM 3112
ISM 4212
ISM 4930
Syst Analysis
Syst Design
Database
54907
2715
Networking
66324
2713
...
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
![LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.](https://www.bartleby.com/isbn_cover_images/9781337569798/9781337569798_smallCoverImage.gif)
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:
9781337569798
Author:
ECKERT
Publisher:
CENGAGE L
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning