Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212 (display StudentID, StudentName, CourseID, and SectionNo, use inner join):   5. How many courses in section 2714 during semester I-2021?   6. How many students were enrolled in section 2714?

Principles of Information Systems (MindTap Course List)
12th Edition
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter5: Database Systems And Applications
Section: Chapter Questions
Problem 11SAT
icon
Related questions
Question
100%

4. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212 (display StudentID, StudentName, CourseID, and SectionNo, use inner join):

 

5. How many courses in section 2714 during semester I-2021?

 

6. How many students were enrolled in section 2714?

 

STUDENT (StudentID, StudentName)
StudentID
38214
54907
66324
70542
FacultyID
FACULTY (FacultyID, FacultyName)
2143
3467
4756
StudentName
CourselD
Letersky
Altvater
Aiken
Marral
ISM 3113
ISM 3112
ISM 4212
ISM 4930
FacultyName
COURSE (CourselD, CourseName)
Birkin
Berndt
Collins
CourseName
Syst Analysis
Syst Design
Database
Networking
QUALIFIED (FacultyID, CourselD, DateQualified)
FacultyID
2143
2143
3467
3467
4756
4756
Ⓒ2022 Pearson Education, Inc.
Questions 1 to 8 are based on the above tables.
Section No
2712
2713
2714
2715
CourselD
SECTION (Section No, Semester, CourseID)
StudentID
ISM 3112
ISM 3113
38214
54907
54907
66324
ISM 4212
ISM 4930
ISM 3113
ISM 3112
Semester
1-2021
I-2021
1-2021
I-2021
DateQualified
SectionNo
9/2011
9/2011
9/2018
9/2019
9/2014
9/2014
REGISTRATION (StudentID, SectionNo)
2714
2714
2715
2713
CourselD
ISM 3113
ISM 3113
ISM 4212
ISM 4930
Transcribed Image Text:STUDENT (StudentID, StudentName) StudentID 38214 54907 66324 70542 FacultyID FACULTY (FacultyID, FacultyName) 2143 3467 4756 StudentName CourselD Letersky Altvater Aiken Marral ISM 3113 ISM 3112 ISM 4212 ISM 4930 FacultyName COURSE (CourselD, CourseName) Birkin Berndt Collins CourseName Syst Analysis Syst Design Database Networking QUALIFIED (FacultyID, CourselD, DateQualified) FacultyID 2143 2143 3467 3467 4756 4756 Ⓒ2022 Pearson Education, Inc. Questions 1 to 8 are based on the above tables. Section No 2712 2713 2714 2715 CourselD SECTION (Section No, Semester, CourseID) StudentID ISM 3112 ISM 3113 38214 54907 54907 66324 ISM 4212 ISM 4930 ISM 3113 ISM 3112 Semester 1-2021 I-2021 1-2021 I-2021 DateQualified SectionNo 9/2011 9/2011 9/2018 9/2019 9/2014 9/2014 REGISTRATION (StudentID, SectionNo) 2714 2714 2715 2713 CourselD ISM 3113 ISM 3113 ISM 4212 ISM 4930
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 3 images

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
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
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
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage