Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
The figure below shows a sample database containing information about: ·        Students and their registrations ·        Courses and their sections ·        Faculty and their qualified courses The sample data is shown in each table for your understanding.       Write SQL DML commands to do the following tasks: How many students were enrolled in ISM 3113 during semester I-2015? Which students were not enrolled in any courses during semester I-2015? Find the name of faculty member who taught ISM 3113 course in I-2015 semester.   Note: If a faculty member has qualified a course, then he is eligible to teach that course. Moreover, you can also consider the Qualified table as the Faculty Course Allocation table.

The figure below shows a sample database containing information about: ·        Students and their registrations ·        Courses and their sections ·        Faculty and their qualified courses The sample data is shown in each table for your understanding.       Write SQL DML commands to do the following tasks: How many students were enrolled in ISM 3113 during semester I-2015? Which students were not enrolled in any courses during semester I-2015? Find the name of faculty member who taught ISM 3113 course in I-2015 semester.   Note: If a faculty member has qualified a course, then he is eligible to teach that course. Moreover, you can also consider the Qualified table as the Faculty Course Allocation table.

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
Related questions
Question

The figure below shows a sample database containing information about:

·        Students and their registrations

·        Courses and their sections

·        Faculty and their qualified courses

The sample data is shown in each table for your understanding.

 

 

 

Write SQL DML commands to do the following tasks:

  1. How many students were enrolled in ISM 3113 during semester I-2015?
  2. Which students were not enrolled in any courses during semester I-2015?
  3. Find the name of faculty member who taught ISM 3113 course in I-2015 semester.

 

Note:

If a faculty member has qualified a course, then he is eligible to teach that course.

Moreover, you can also consider the Qualified table as the Faculty Course Allocation table.

STUDENT (StudentID, StudentName) QUALIFIED (FacultylD. CourselD, DateQualified) StudentID StudentName FacultylD CourselD DateQualified IŠM 3112 ISM 3113 38214 Letersky Altvater 2143 9/2005 54907 2143 9/2005 ISM 4212 IŠM 4930 ISM 3113 ISM 3112 66324 Aiken Marra 3467 9/2012 9/2013 70542 3467 4756 9/2008 9/2008 4756 FACULTY (FacultylD, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultyID FacultyName SectionNo Semester CourselD ISM 3113 ISM 3113 ISM 4212 2143 Birkin 2712 -2015 3467 Berndt 2713 -2015 Il-2015 4756 Collins 2714 2715 Il-2015 ISM 4930 COURSE (CourselD, CourseName) REGISTRATION (StudentID, SectionNo) CourselD StudentID CourseName SectionNo ISM 3113 Syst Analysis 38214 2714 ISM 3112 IŠM 4212 ISM 4930 Syst Design Database 54907 2714 54907 2715 Networking 66324 2713
Transcribed Image Text:STUDENT (StudentID, StudentName) QUALIFIED (FacultylD. CourselD, DateQualified) StudentID StudentName FacultylD CourselD DateQualified IŠM 3112 ISM 3113 38214 Letersky Altvater 2143 9/2005 54907 2143 9/2005 ISM 4212 IŠM 4930 ISM 3113 ISM 3112 66324 Aiken Marra 3467 9/2012 9/2013 70542 3467 4756 9/2008 9/2008 4756 FACULTY (FacultylD, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultyID FacultyName SectionNo Semester CourselD ISM 3113 ISM 3113 ISM 4212 2143 Birkin 2712 -2015 3467 Berndt 2713 -2015 Il-2015 4756 Collins 2714 2715 Il-2015 ISM 4930 COURSE (CourselD, CourseName) REGISTRATION (StudentID, SectionNo) CourselD StudentID CourseName SectionNo ISM 3113 Syst Analysis 38214 2714 ISM 3112 IŠM 4212 ISM 4930 Syst Design Database 54907 2714 54907 2715 Networking 66324 2713
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS