he 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: List the IDs of all faculty members who are qualified to teach both ISM 3112 and ISM 3113. Modify the query above in part 16 so that both qualifications must have been earned after the year 2005. List the ID of the faculty member who has been assigned to teach ISM 4212 during the semester II-2015. Display the course ID and course name for all courses with an ISM prefix
he 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: List the IDs of all faculty members who are qualified to teach both ISM 3112 and ISM 3113. Modify the query above in part 16 so that both qualifications must have been earned after the year 2005. List the ID of the faculty member who has been assigned to teach ISM 4212 during the semester II-2015. Display the course ID and course name for all courses with an ISM prefix
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter3: The Relational Database Model
Section: Chapter Questions
Problem 25P: Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many...
Related questions
Question
The figure below shows a sample
· 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:
- List the IDs of all faculty members who are qualified to teach both ISM 3112 and ISM 3113.
- Modify the query above in part 16 so that both qualifications must have been earned after the year 2005.
- List the ID of the faculty member who has been assigned to teach ISM 4212 during the semester II-2015.
- Display the course ID and course name for all courses with an ISM prefix.
- Display all courses for which Professor Berndt has been qualified.
- Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212. Class roster means attendance list.
- Which instructors are qualified to teach ISM 3113?
- Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930?
- What are the names of the course(s) that student Altvater took during the semester I-2015?
- List names of the students who have taken at least one course that Professor Collins is qualified to teach.
- How many students did Professor Collins teach during the semester I-2015?
- How many students were enrolled in section 2714 during semester I-2015?
- 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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
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…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage